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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
