Solved

How to use HSQL Database?

Posted on 2001-09-15
2
321 Views
Last Modified: 2008-03-10
   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
Comment
Question by:Tension
2 Comments
 
LVL 16

Accepted Solution

by:
heyhey_ earned 100 total points
ID: 6484876
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
 
LVL 20

Expert Comment

by:Venabili
ID: 8916099
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle SQL syntax check  without executing 6 108
maven module vs maven project 3 74
Android development question 2 81
How to fix  socket closed error 11 31
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This video teaches viewers about errors in exception handling.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question