Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Does jboss support pool of preparedstatement?

 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic