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.
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
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?
thank in advance