cloudscape db and connection pool

[rgsuresh]

Hi all,
I palced the following lines in jboss.jcml file in order to create a connection pool. But on calling a servlet with
DriverManager.getConnection(jdbc:cloudscape:db)
an error message appeares and reports that the accessed "able is not found"



COM.cloudscape.core.JDBCDriver
db


<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=somepool
db
somepool
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc:cloudscape:db




1200000
10
false
false
false
true
120000
1800000
false
false
1.0
0


I put the db(database name)into jboss/db directory
i want to know the format of getConnection string. should i place the db name(db) or pool name somepool?

any help is greatly appreciated
rgsuresh

[luke_t]

You shouldn't be using DriverManager.getConnection() at all.

I think you need to look at some basic examples on using javax.sql.Datasource - get the manual from flashline which has everything you need to know about JBoss 2.4 in it.

Try to copy some of the examples in there - using the hypersonic database and the default datasource in jboss.jcml. Then move on to setting up your own datasources.

Luke.