Does JBoss cache PreparedStatements?

[toddh]

I read that Weblogic now caches PreparedStatements and was wondering if JBoss does.

If not, are there any plans to add this?

[davidjencks]

jboss has cached prepared statements since at least feb 2001. There has been some discussion, however, that this may not be always appropriate since a well designed db driver could cache prepared statements in a more appropriate way for the particular database, and 2 caches might possibly interfere with each other.

[lolsson]

How does one code stateless session beans to benefit
from this caching?

Can I write my business methods so that they release
connections and statements as soon as they are
done with them? Something like this:

public void BM(...) throws .....{
 Connection c = mydatasource.getConnection();
 PreparedStatement s = c.prepare("select ...");
 ....
 ... use <s> ....
 ....
 s.close();
 c.close();
}

[davidjencks]

well, close the result set(if any) too. In fact, you _must_ close connections before the transaction commits in jboss, and get new ones after the start of the next transaction, in order to assure enrollment in the correct transaction.