Problem using HSQL DB for my Java Application

[venkatesh_r]

Hi Friends,

I have a problem using HSQL DB in my application.

I get connection to the HSQLDB table the first time i deploy the application. The next time i deploy i get a "Connection already in use by another process" SQL Connection error. I have kept HSQLDB in the C drive of the server.

Any sort of help will be appreciated.

Regards,

Venkatesh

[Former Member · Accepted solution]

Hi Venkatesh,

Check the paragraph for closing the db from this link

http://www.hsqldb.org/doc/guide/ch01.html#N101DB

I assume you have to programatically call shutdown in order to be able to use the db normally, that is call shutdown as an sql stamement before closing the connection:

stmt.execute("SHUTDOWN");

stmt.close();

conn.close();

Greetings, Myriana

[JPReyes]

Hi Venkatesh,

I presume you need to extend the number of sessions your DB can handle.

Hope this help!

Juan

Please reward with points if helpful