Re: hsql datasource - can't make it work

[Richard Woodward]

Oh, right.

Might need to see your data-source config file then. 

If you are going to post it to the group, dont forget to replace any
sensitive info like passwords etc... with bogus ones ;-)


---

Richard Woodward

G8 Labs Ltd.

Direct Dial (04) 9393414
---
On Thu, 17 Aug 2000, Alex Johnson wrote:

 Thanks Richard. Unfortunatly, I get the very same error when I do this...
 
 
 
 --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward 
 [EMAIL PROTECTED] wrote:
 
 
  Alex,
 
  Only put the jar file (hsql.jar) in your lib dir.
 
 
  ---
 
  Richard Woodward
 
  G8 Labs Ltd.
 
  Direct Dial (04) 9393414
  ---
  On Thu, 17 Aug 2000, Alex Johnson wrote:
 
  Hi All...
 
  I'm sorry to ask such a basic question, but I have searched the archive
  with no luck.
 
  I can't make Hypersonic SQL work. I have downloaded hsql version 142 and
  Orion 1.2.0.
 
  I believe my problem is confusion about where everything goes. The docs
  say:
 
  2. Put the hSql directory under /orion/lib/
 
  When I examine the hsql distribution, I see the top level directory is
  "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution
  below  the orion/lib directory (which I suspect is wrong).
 
  I then modified the data-sorces.xml as indicated by the doc, changing
  the  username and password attributes.
 
  When I restart Orion, I get:
 
  C:\orionjava -jar orion.jar
  Error initializing server: DriverManagerDataSource driver 'hSql.hDriver'
  not found
 
  I expect this is a simple problem, but I can't find the solution and
  would  appreciate any help offered. What should it say when it does work?
 
  Thanks in advance...
 
  Alex
 
 
 
 
 
 
 
 
 
 

RE: MySql?

[Richard Woodward]

MySQL can be used with EJB's, but entities will have to be written in such
a way as to get around the lack of transaction support, ie. using table
locks (Yuck!). THis however alone does not guarantee data integrity, as a
connection that is dropped in the middle of a set of queries, will result
in the locks being dropped, meaning table locks are only useful when two
concurrect connections are trying to write/ read to the same table, and
locks will ensure that one connection blocks till the other drops the
lock. 

So, you can still do session beans, but not standard entity beans.

MaxSQL is MySQL with Berkeley DB support for transactions. THis has been
announced, but not released yet. I think they are waiting till the
existing Berkeley DB transactions mod is more stable before they release
it. You could have a preview by getting the Mod and installing it with
MySQL and seeing how it goes with EJB's under Orion. 

Have not had too much of a play with EJB support on Orion yet, but i 
understand you have to create a schema for particular databases to use
them as EJB datasources ??

cheers,

Richard.

ps. I have been using MySQL for some time on Orion, as a standard
datasource, but have not tried it with EJB's yet. It is fine as a standard
datasource, the JDBC drivers ( the mm variety ) even have transaction
handling routines. (commit, rollback, etc... ) They just dont work, ie.
The transaction gets fired through query by query without regard for data
integrity. 

---

Richard Woodward

G8 Labs Ltd.

Wellington
New Zealand

Direct Dial (04) 9393414
---
On Wed, 16 Aug 2000, Michael Bushe wrote:

 Since MySQL doesn't support transactions (hence IMHO is a toy like
 MSAccess), so I would be surprised if it would work with any EJB server.  If
 you want an open source solution I'd try PostgreSQL or Inprise's Interbase.
 I'm starting with Oracle and moving to one of those.  I did try PostgreSQL
 with the RI and that worked, so I bet Orion would work too.  Let us know or
 I'll let y'all know in a couple of months.
 
 Michael
   -Original Message-
   From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Steven Punte
   Sent: Wednesday, August 16, 2000 1:01 PM
   To: Orion-Interest
   Subject: MySql?
 
 
   Has anyone ever use the database "mysql" successfully with Orion?
 
   Steve
 
 
   STeve Punte
   e-Business Software Architect
   Technologent Inc
   [EMAIL PROTECTED]