BEA Connection Pools

[aschbacher]

Hi, we are just evaluating to move from BEA 8.1.x to JBoss 4.0.x.
On the Weblogic Server we used connection pools to access the database. Up to now I found no way to define connection pools in JBoss 4.0.3.
Are DataSources the only way to access the database on JBoss?
If connection pools exist (the way they exist on a BEA server), where are they configured?

[javidjamae]

You can do this in *-ds.xml files in the deploy directory. The default one is hsqldb-ds.xml. It has settings in there for the connection pool size, prepared statement cache, etc.

[aschbacher]

Thanks for your answer. But I have one more question.
How could I access these connection pools?
Via a DataSource?
Or also via the DriverManager?
thanks in advance
Karl

[aschbacher]

Maybe I`m not making myself clear enough:

Up to now we created connections using the following statement:
Connection connection = DriverManager.getConnection("jdbc:weblogic:pool:<pool_name>");
(This functionality is encapsulated in our own framework, so it can not be changed very easily).

For JBoss 4.0.3 I only found the following way to create a connection:

Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:<pool_name>");
Connection con = ds.getConnection();

So my question is:
Is there a way to acces a connection pool in JBoss using method number 1?
(DriverManager....)
thank in advance
Karl