How to set my Datasource with autoCommit = false ?

[btal]

I am using JBoss 4 and I configured my data source this way:


<no-tx-datasource>
<jndi-name>appilogDataSource</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:TB</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<min-pool-size>10</min-pool-size>
<max-pool-size>40</max-pool-size>
<user-name>xxx</user-name>
xxx
</no-tx-datasource>

Every time that I try to get a connection the autoCommit property is being set to "true" by default.

I tried adding this line to the datasource:
<connection-property name="autoCommit">false</connection-property>
It didnt help either.

Any help would be great. Thanks.

[darranl]

I think it might have something to do with the "<no-tx-datasource>" you have specified that you don't want transactions which means that you want everything to autocommit.

[btal]

It behaves the same way when I configure it as -
<local-tx-datasource>

In your opinion which method will have autoCommit = false as default?

[btal]

Also, my need is to use the no-tx. So I should find how to set the autoCommit to false through the datasource anyway.

Maybe I am using the property element wrongly...
Again, any help will be greatly appreciated.

[btal]

Again, if some one can figure out this problem for me I will be really grateful.

Thanks.