#109 Add Autocommit as URL Parameter

[amallon]

Tibco BusinessWorks throws errors when attempting to use the JTDS application with it. The error is as follows:

com.tibco.pof.entity.EntityStoreException: java.sql.SQLException: commit() should not be called while in auto-commit mode.
at com.tibco.pof.entitystore.db.DBEntityStore.init(DBEntityStore.java:568)
at com.tibco.pof.entitystore.EntityStoreManager.a(EntityStoreManager.java:221)
at com.tibco.pof.entitystore.EntityStoreManager.getEntityStore(EntityStoreManager.java:202)
at com.tibco.pof.entitystore.EntityStoreManager.getReadOnlyEntityDomain(EntityStoreManager.java:333)

etc.

The incompatibility arises because Tibco BusinessWorks does not explicitly set AutoCommit to false and the driver defaults to true. I modified the source code to add autocommit as a parameter in the URL connection string. For example:

jdbc:jtds:sqlserver://localhost:1433/tibco_sys;domain=ACME;autocommit=false

The code is additive, no changes to existing functionality were made. The driver still defaults AutoCommit to true and it follows the same patterns for defining parameters as the current ones.

[amallon]

[momo]

The patch you provided has been applied to the SVN sources and is included in release 1.2.6.
Thanks for your input!

Cheers,
momo