[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to use HSQL Database?

Posted on 2001-09-15
2
Medium Priority
?
328 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 400 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Suggested Courses
Course of the Month17 days, 18 hours left to enroll

829 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