Hello,
I am using the configuration below (local-tx-datasource) because I would like
to use transactions. Based on the documentation found here:
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources
I would assume that the connections would have auto-commit set to false (as an
exception will occur if I try to call setAutoCommit on the java.sql.Connection
I retrieve from the datasource).
I receive the following error
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call
rollback when autocommit=true
Why is autocommit=true? I don't understand... How can I change that?
I am using jboss-4.0.5 (default)
<local-tx-datasource>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<jndi-name>jdbc/MyAdBox</jndi-name>
<connection-url>
jdbc:mysql://localhost/mydb?autoReconnectForPools=true&dumpQueriesOnException=true&useServerPrepStmts=false
</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>****</user-name>
****
<idle-timeout-minutes>10</idle-timeout-minutes>
<min-pool-size>0</min-pool-size>
<max-pool-size>100</max-pool-size>
<exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
<!--
valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name
-->
<type-mapping>mySQL</type-mapping>
</local-tx-datasource>
Thank you very much for any help you might be able to offer.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4001451#4001451
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4001451
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
