I am using a HSQL driver to connect to my database. I am able to connect without any errors but I can t see any of my tables in the table tree under public. I am able.
I have recently downloaded hsqldb from sourceforge and configured it in JBoss 7.1 Final Brontes. The in-memory database is starting up as soon as my application.
- SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database.
- Squirrel-sql-users HSQLDB database and stored procedures Exception e System.out.println ERROR: failed to load HSQLDB JDBC driver. ; e.
HSQLDB database and stored procedures. The main method of the attached Java file shows how SQuirreL executes To me it looks like the HSQLDB driver does.
HSQLDB HyperSQL DataBase is the leading SQL relational database software written in Java. It offers a small, fast multithreaded and transactional database engine.
Fred Toussi maintainer of the HSQLDB Project was kind enough to tell me how to get stored procedures to work. Thanks again. The main method of the attached Java file shows how SQuirreL executes procedures and why it does not display the ResultSet: Since SQuirreL does not really know what kind of statement is being executed it uses probably the most generic way JDBC offers to find out what the outcome of a statement is.
I don't know enough about JBoss configuration to answer this. But your URL is incorrect as it mixes the mem: protocol with server:port specification. A URL for external connections is like "jdbc:hsqldb:http://localhost/etc" You can try this with HSQLDB 2.2.9: Set up the org.hsqldb.server.Servlet as a servlet in JBoss. Configure it to connect to the mem: database in question with the URL "jdbc:hsqldb:mem:yourmemdb". Your JBoss web apps connect to the database with this URL.
Uwe, I was able to connect to HSQL. The only difference I could figure out was the way in which the server was started I used the following java -cp. ./lib/hsqldb.jar.
I use SQuirrel SQL Client Version 3.5.3 and HSQLDB for my database. I have been able to specify the corresponding driver In-memory to it and create an Alias. I have.
connect to HSQLDB in JBoss 7.1 from external
SQuirreL SQL Client