Re: Help, with HypersonicSQL/ Orion

[Robert]

Hello,

A Huge thanks to everyone that
helpt me out with my orion/hsql problem.
Everything runs perfect now.


cheers,
Robert Karlsson

Re: Help, with HypersonicSQL/ Orion

[thm]

I have the same difficulty!
I write a little program to access the Hypersonic Base, but I ve an
error message : no surch driver.

Thanks for your help
ThM
[EMAIL PROTECTED]
http://www.idocw.com

Robert a écrit :

 Hi,

 Anyone knows what I'm not doing right, I want to
 connect to a HypersonicSQL database using the
 webserver connection. But when I use the following
 URL:

 "jdbc:HypersonicSQL:http://localhost:8080"

 It wont connect.

 I have orion on the url: localhost:8080. I've installed
 hSQL in the /lib dir and made a classpath to it in the
 global-web-application.xml file. I have also modified the
 file data-sources.xml as it says in the docs:

   url="jdbc:HypersonicSQL:defaultdb"
   connection-driver="hSql.hDriver"
   username="xxx"
   password="yyy"
   schema="database-schemas/hypersonic.xml"

 I have named my database files to 'mydb.*'.

 Thanks in advance,
 /Robert Karlsson

RE: Help, with HypersonicSQL/ Orion

[Joe Walnes]

 Anyone knows what I'm not doing right, I want to
 connect to a HypersonicSQL database using the
 webserver connection. But when I use the following
 URL:
 connection-driver="hSql.hDriver"

Try changing the driver to org.hsql.jdbcDriver (which was recently updated
in the hsql distribution).

-Joe Walnes

Re: Help, with HypersonicSQL/ Orion

[Wong Kok Wai]

Try this (edit the username and password to match your setup):

  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/demoPool"
  url="jdbc:HypersonicSQL:defaultdb"
  connection-driver="org.hsql.jdbcDriver"
  username="sa"
  password=""
  schema="database-schemas/hypersonic.xml"
  /

Note to Orion team: PLEASE update your documentation!

thm wrote:

 I have the same difficulty!
 I write a little program to access the Hypersonic Base, but I ve an
 error message : no surch driver.

Re: Help, with HypersonicSQL/ Orion

[Brian Cunningham]

If that still won't do it, look on the hsql site for the socket connection
patch. I applied it just as specified by its author, recompiled, and the
client/server version suddenly worked great, where before I could not connect at
all. The same issue may apply to the web server version.

Brian

Robert wrote:

 Hi,

 Anyone knows what I'm not doing right, I want to
 connect to a HypersonicSQL database using the
 webserver connection. But when I use the following
 URL:

 "jdbc:HypersonicSQL:http://localhost:8080"

 It wont connect.

 I have orion on the url: localhost:8080. I've installed
 hSQL in the /lib dir and made a classpath to it in the
 global-web-application.xml file. I have also modified the
 file data-sources.xml as it says in the docs:

   url="jdbc:HypersonicSQL:defaultdb"
   connection-driver="hSql.hDriver"
   username="xxx"
   password="yyy"
   schema="database-schemas/hypersonic.xml"

 I have named my database files to 'mydb.*'.

 Thanks in advance,
 /Robert Karlsson



--
*

Brian Cunningham
North Bay Data
[EMAIL PROTECTED]
415-451-4879

*