Hi, In my current project, we are using JBoss 5 GA application server. For database interactions, we are using JNDI data source configured in JBoss AS. I am trying to configure the Autocommit to "FALSE", however, it is not happening. Even if I have put the required configuration in my oracle-ds.xml file, the autocommit seems to be in TRUE state and all my inserts are commited automatically in the DB. Please see below my configuration of oracle-ds.xml file.
| <?xml version="1.0" encoding="UTF-8"?> | | <datasources> | <local-tx-datasource> | <jndi-name>MyDS</jndi-name> | <use-java-context>false</use-java-context> | | <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> | <connection-url>MY_URL</connection-url> | <user-name>USER</user-name> | <password>PASSWORD</password> | | <!-- The minimum connections in a pool/sub-pool --> | <min-pool-size>5</min-pool-size> | | <!-- The maximum connections in a pool/sub-pool --> | <max-pool-size>10</max-pool-size> | | <!-- The time before an unused connection is destroyed --> | <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use --> | <idle-timeout-minutes>0</idle-timeout-minutes> | | <!-- ORACLE benefits from prepared statement caching --> | <prepared-statement-cache-size>32</prepared-statement-cache-size> | | <!-- Connection Properties --> | <connection-property name="auto-commit">false</connection-property> | | </local-tx-datasource> | </datasources> | This seems to be very strange. Is this a BUG in Jboss? Or I am missing any configuration? Please HELP. Thanks, Niranjan View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4232012#4232012 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4232012 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
