Re: hsql datasource - can't make it work
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: hsql datasource - can't make it work
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: hsql datasource - can't make it work
Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: 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: hsql datasource - can't make it work
Thanks Richard. That did it. It wanted: org.hsql.jdbcDriver I appreiate your help very much. Orion team, if your reading, do you think you could correct your docs/FAQ? Alex --On Friday, August 18, 2000 10:57 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: I just re-examined the contents of the jar file, and the class you are after is in org/hsql/jdbcDriver.class So try changing the driver line to "org.hsql.jdbcDriver" if that does not work, try org.hsql.Driver I will have a closer look when i am home from work in about 4 or 5 hours. Richard. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: tatus: RO X-Status: X-Keywords: X-UID: 394 Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: 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: hsql datasource - can't make it work
Using the latest version: hsql_142.zip (1.42 from June 2000), I had to change the value of: connection-driver="hSql.hDriver" to connection-driver="org.hsql.jdbcDriver" -Original Message- From: Alex Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 4:19 PM To: Orion-Interest Cc: Orion-Interest Subject: Re: hsql datasource - can't make it work Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: 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