HSQLDB and url database

why i receive this error message with HSQLDB?


java.sql.SQLException: Errore nella creazione del socket


at org.hsqldb.jdbc.Util.sqlException(Unknown Source)


at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)


at org.hsqldb.jdbcDriver.getConnection(Unknown Source)


at org.hsqldb.jdbcDriver.connect(Unknown Source)


at java.sql.DriverManager.getConnection(Unknown Source)


at java.sql.DriverManager.getConnection(Unknown Source)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:206)


at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:246)


at chemaxon.jchem.gui.Connector.go(Connector.java:64)


at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:561)


at chemaxon.jchem.JChemManager.init(JChemManager.java:89)


at chemaxon.jchem.JChemManager.main(JChemManager.java:106)








this is my "jcman" panel:





JDBC driver: org.hsqldb.jdbcDriver


URL of database: jdbc:hsqldb:hsql://localhost/


Property table : JChemProperties


Login name:


Password:





then if i configure with: URL of database: jdbc:hsqldb:mem:.


the program start!





what's the difference?





thanks for attention

Hi,





The first URL tries to connect to a standalone server on the network.


You do not have a server running, that's why the socket creation error message.


The particular HSQLDB version I have has a runServer.bat (and .sh) under the "demo" directory.








The URL with the "mem" stores the data in memory. It's only useful for temporary storage, your data will be lost as you exit the program.





HSQLDB also has a direct file access mode, where you don't have to start up a server, but only one application can access the database at any given time.





You can find more information on HSQLDB at the official website:





http://www.hsqldb.org/web/hsqlDocsFrame.html





Best regards,





Szilard