I tried to use HSQL with Visual Cafe and bound a column in the table to the JTextfield. In the beginning itself i am getting an error :
"java.sql.SQLException: The database is already in use by another process".
So i tried to write a small program that opens a connection and fetches a record from it. If i try to run two instance of the same program at the same time i am getting the same error.
Have anybody of you tried using HSQL, and if so how do you solve the multiple connection problem. Pls let me know abt this at the earliest.