Two Laptop Bag
The moose likes JDBC and the fly likes how to create a database instance in HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "how to create a database instance in HSQLDB" Watch "how to create a database instance in HSQLDB" New topic
Author

how to create a database instance in HSQLDB

Pravin Jagan
Greenhorn

Joined: Feb 28, 2005
Posts: 27
hi all,
I have two applications (J2EE applications) running on JBoss 4.0 and Hsqldb as the database. The problem is , im having a table UserInfo(say) for each of the application. ( but ofcourse the column values are different). and the requirement is that i have to deploy both the applications on the same Jboss. So i need to create two seperate instances of the database for each of the application. I tried creating two seperate users(with admin privileges in Hsqldb) and creating the table of the same name UserInfo(say)under each user respective to the corresponding application, but does not allow me to create so. So how should I go about resolving this issue..
put in simple words, how to create instance of database in hsqldb

thanks in advance
pravin
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: how to create a database instance in HSQLDB
 
Similar Threads
Apache Tomcat/4.0.6 - HTTP Status 500 - Internal Server Error
application log
How to configure mulitple datasource files on JBoss 4.3 application server ?
Class Loader
Create an instance of database in HSQLDB