HSQLDB CONNECTIONS

hi,

when iam trying to connect to hsqldb throgh Jchemmanager iam

getting an error: Type not found or user lacks privilege:NULL.

though i provided privileges to user.

help me,

thanks in advance,

Hi,

 

Please provide the following information:

- Your exact Jchem version

- The full stack trace of the error (should be visible in a console window)

- The JDBC connection strings (driver, URL) 

Best,

 

Szilard

Hi,

Could you please send the version of JChem, and HSQLDB which you use?

Did you use the driver and URL references for the connection as our document describes them?
http://www.chemaxon.com/jchem/doc/admin/JChemBaseFAQ.html#dburl

I'm also wondering that you use our bundled JDBC driver or your own?

Regards, Edvard

hi,

Thanks for the response.

Jchem Version: 5.5.1.0

HSQLDB : 2.2.5

Driver :  org.hsqldb.jdbcDriver

url:  jdbc:hsqldb:hsql://localhost/mydb

1)       iam placing hsqldb.jar in jchem/lib/jdbc   and

iam starting the hsqldb server  -->java -cp .;C:\Users\win7user1\hsqldb\lib\hsqldb.jar org.hsqldb.Server -database.0 file:db\mydb -dbname.0 mydb

then iam getting the following error.

stack trace::

Error executing statement:
CREATE TABLE JChemproperties(
        prop_name NVARCHAR(200) NOT NULL PRIMARY KEY,
        prop_value NVARCHAR(200), prop_value_ext null)
java.sql.SQLSyntaxErrorException: type not found or user lacks privilege: NULL
        at chemaxon.jchem.db.DatabaseProperties.createPropertyTable(DatabaseProp
erties.java:662)
        at chemaxon.jchem.db.DatabaseProperties.createPropertyTable(DatabaseProp
erties.java:632)
        at chemaxon.jchem.gui.Connector.go(Connector.java:82)
        at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:619)
        at chemaxon.jchem.JChemManager.init(JChemManager.java:89)
        at chemaxon.jchem.JChemManager.main(JChemManager.java:106)

 

2)       otherwise iam getting like this:

java.net.ConnectException: Connection refused to connect

stack trace:

java.sql.SQLTransientConnectionException: java.net.ConnectException: Connectio
refused: connect
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at chemaxon.util.ConnectionHandler.connectToDatabase(ConnectionHandler
ava:346)
        at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:334)
        at chemaxon.jchem.gui.Connector.go(Connector.java:64)
        at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:619)
        at chemaxon.jchem.JChemManager.init(JChemManager.java:89)
        at chemaxon.jchem.JChemManager.main(JChemManager.java:106)
Caused by: org.hsqldb.HsqlException: java.net.ConnectException: Connection ref
ed: connect
        at org.hsqldb.ClientConnection.openConnection(Unknown Source)
        at org.hsqldb.ClientConnection.initConnection(Unknown Source)
        at org.hsqldb.ClientConnection.<init>(Unknown Source)
        ... 11 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
        ... 14 more

 

 

 

 

thanks,

Hi,

I could reproduce the error in case 1). We'll try to include the fix in in our next release (5.6) if it is possible.

Regarding 2), could you be a bit more specific in describing the circumstances?
To be exact, I don't understand what "otherwise" refers to: what do you do differently in the second case? (Do you change the connecction string, do not start manually the HSQLDB server, ...?)

Best regards,
Tamás

Hi Tamas,

thank you for the reply,

second case was when server not started,by mistake i put that one. plz ignore that..

Is it  (jchem)Version related problem ? if so,which (previous)version of jchem

is compatible with HSQLDB ?.

 

Thaks,

Hi manjusha,

JChem has not changed, the problem occurs due to a change introduced in HSQLDB V 2.0.
Previous versions (1.8.*, 1.7.*, ...) of hsqldb.jar work fine with JChem.

Best regards,
Tamás