File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes Does jboss support pool of preparedstatement? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Does jboss support pool of preparedstatement?" Watch "Does jboss support pool of preparedstatement?" New topic
Author

Does jboss support pool of preparedstatement?

avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
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
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Does jboss support pool of preparedstatement?