Does jboss support pool of preparedstatement?

[avihai marchiano]

The preparestatement is cached on the connection, so another connection will not contain the preparedstatement i create moment ago.

In jdbc 3.0 added - support for preparedstatement pool, does jboss support it?
will preparestatement on another connection from jboss conection pool create new preparestatement?

Thank you

[Mark Spritzler]

When you create a datasource there is a property for turning query cache on, which I believe holds the PreparedStatements that have recently run. You can set the size too.

Mark

[avihai marchiano]

i am familiar with this property , but i am not sure if this enable cache on the connection level or the cache is shared between all connections.

thank you

[avihai marchiano]

As far as i see it in performance , the cache of preparestatement is not between connection.

Taking another connection from the pool and call to prepare statement on the same statement take time.