hi remy,
I have tested the JDBCDescriptorStore for oracle database with the
setAutoCommit(false)
commented out and it works fine. The base data is loaded successfully.
thanks,
rajkumar
-----Original Message-----
From: Remy Maucherat [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 11:19 AM
To: [EMAIL PROTECTED]
Subject: Re: Enlist error when using JDBCDescriptor store for Sybase
> hi remy,
> It does look like some DB's would start in auto-commit true .
> I heard from somebody that even oracle does not allow
setAutoCommit(false)
> when dealing with a global trabsaction though i have not tested it yet.I
> will do some testing with oracle database and let you know the result.
> I think setAutoCommit(false) can be in seperate try catch block and any
> expection ignored if there is no possibility
> of SQLException being raised because of other problem or may be the
> setAutoCommit(false) can be removed all together
> if the behavior is the same for all the databases.
I'm sure that sentence would make Assaf have a good laugh :)
Maybe you should go ask him about what we should expect databases to do with
the auto-commit mode by default ...
Remy
