Auto-Commit and Rollback does not work as documented in "Repository File"

[Ajitesh Das]

Again is this a bug? Or I am missing something.

The followings are snippets of two jdbc descriptors defined in two
different respository xmls.

    <jdbc-connection-descriptor  platform="MsSQLServer"
         jcd-alias="zdb"
         default-connection="false"
         jdbc-level="2.0"
         driver="net.sourceforge.jtds.jdbc.Driver"
         protocol="jdbc"
         subprotocol="jtds:sqlserver"
         dbalias="//localhost:1433/adb;user=aaa;password=ppp;"
         username="aaa"
         password="ppp"

         <!-- useAutoCommit="1" which is default -->
    />

AND 

    <jdbc-connection-descriptor  platform="MsSQLServer"
         jcd-alias="zdb"
         default-connection="false"
         jdbc-level="2.0"
         driver="net.sourceforge.jtds.jdbc.Driver"
         protocol="jdbc"
         subprotocol="jtds:sqlserver"
         dbalias="//localhost:1433/adb;user=aaa;password=ppp;"
         username="aaa"
         password="ppp"
         useAutoCommit="2"
    />

Please note the following difference:
  One uses useAutoCommit="2" and other uses useAutoCommit="1" as a
default.

My expectation was that the 2nd one would save the data in the DB as
soon as 
PB.store() is called whereas the 1st one would commit the data in to the
DB only when Tx.commit() is called. 

But, in reality, both  of them are showing the "1st's case" behavior i.e
one would commit the data in to the DB only when Tx.commit() is called.
[Note in 1st case, I have used useAutoCommit="1"] and this seems
misaligned with the claim of the documentation.

Thanks
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]