[jboss-user] [JCA/JBoss] - Results caching in Connection Pool

[harish_here]

We are using JBoss 4.0.2 with MySQL 5.0. We are using Connection Pooling of JBoss with MySQL database. The records updated in one query in not getting reflected in another query though the records are committed and is updated in database. 

For ex: A connection X is feteched from connection pool (using datasource & JNDI mapping). Some fields of a record are updated with this "X" connection and transaction is committed. The connection is then closed. Immediately after this, a new connection "Y" is fetched from connection pool (this returns an different connection from pool) and same record is fetched. However it shows up data prior to the updation!!!  But the same data is reflected in database. After sometime (1 min or idle-timeout-in-minutes value), if the records are fetched again, it shows up the new/updated data. I assume there is some caching of results at the Jboss connection pool level. 

Please let me know if there is some problem with configuration.

Following is the mysql-ds.xml for the same
********************************************************

  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://172.17.182.102:3306/uiia</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>x</user-name>
    y
    <min-pool-size>1</min-pool-size> 
    <max-pool-size>20</max-pool-size>
    <idle-timeout-minutes>1</idle-timeout-minutes>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    
       <type-mapping>mySQL</type-mapping>
    
  </local-tx-datasource>


*****************************************************

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3965420#3965420

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3965420