[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

How to use HSQL Database?

   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.

Thank you.
0
Tension
Asked:
Tension
1 Solution
 
heyhey_Commented:
hypersonic sql is 'minimal' SQL-compatible database implementation - it probably works with plain text files (or memory data) and does not have 'database server'.

you have to
1. either use some 'real' db server
2. write your own middle-layer that receives requests from multiple clients (using RMI or whatever)
0
 
VenabiliCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- Points for heyhey_

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Venabili
EE Cleanup Volunteer
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now