The Source for Java Technology Collaboration

Home » java.net Forums » GlassFish » GlassFish

Thread: Creating Connectionpool with hsqldb

Welcome, Guest Help
Login Login
Guest Settings Guest Settings
Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 1 - Last Post: Oct 21, 2008 3:11 AM by: sm157516
kbrforever

Posts: 2
Creating Connectionpool with hsqldb
Posted: Oct 20, 2008 8:44 AM
  Click to reply to this thread Reply

Hi,

Can anybody tell me how to create database connection pool with HSQLDB(standalone database).
Which driver jar we should use, and what properties we need to specify.



Thanks
KB

sm157516

Posts: 182
Re: Creating Connectionpool with hsqldb
Posted: Oct 21, 2008 3:11 AM   in response to: kbrforever
  Click to reply to this thread Reply

JDBC Connection pool can be created in glassfish in 3 ways
- Admin console (http://localhost:4848)
- Admin CLI (asadmin create-jdbc-connection-pool /create-jdbc-resource commands)
- asadmin add-resources command using a sun-resources.xml file with the properties specified.

Please refer the documentation for the above.
Datasource classname : org.hsqldb.jdbc.jdbcDataSource
Properties : User, Password and Database (in the format jdbc:hsqldb:hsql://localhost).
Driver : org.hsqldb.jdbcDriver




 XML java.net RSS