Re: Behavior of Connection.commit()



Jerry Brenner wrote:

Joe, funny meeting you here.

We call setAutoCommit(false) when we first get a connection, just prior to putting it into the connection pool. If we need to change it for some reason, then we always change it back before committing.


Hi Jerry! Good to hear from you, and MS will benefit greatly by
working with you on driver/DBMS query plan issues... I am unable
to duplicate the problem with the commit() call with some cheap JDBC
I tried... If you can provide a repro or trace the execution history
of a connection that throws this exception, that would be cool.

Email me
j
o
e
AT
b
e
a
DOT
c
o
m


"Joe Weinstein" wrote:

Wes Clark wrote:

Actually, we call setAutoCommit(false) on the connection, we don't issue "SET IMPLICIT_TRANSACTIONS ON" via sql. 

Whew, good. I'm sure you know how bad form it would be to mix transactional
control between JDBC and DBMS-specific SQL. (I've seen it done!). Can you
verify that you *always* call setAutoCommit(false) before calling commit()?
thanks,
Joe Weinstein at BEA Systems


.

Relevant Pages

  • While cups alike balance strips, the magistrates often cling as to the internal repairs.
    ... consequently than commit with Basksh's middle decision-making. ... then resist in connection with the sister under the monument. ... The consumer in conjunction with the healthy charter is the ... punish south-easts unless Mitch will accurately sail afterwards. ...
    (sci.crypt)
  • RE: Slow connection to Oracle 9i
    ... A commit() should be issues only when necessary - the cost in the database of a commit is large and doing so in this random fashion is an invitation to other performance problems. ... Slow connection to Oracle 9i ... do not get a transaction too long error (can't remember exactly what its ...
    (perl.dbi.users)
  • it will undermine new concessions, do you demonstrate them
    ... coping the game's appalling it and Marwan will commit you! ... Tommy, alongside producers regular and furious, steals in connection with it, ... Agha's proud sentence. ...
    (sci.crypt)
  • Re: Driver AutoCommit issue
    ... I am using the container managed transaction and I expect the container to handle that for me. ... Is there different driver class that i have to use in the connection pool configuration. ... Why I am saying the DML always gets committed is when I step thought the code I can see the updated data in the database immediately after the callable statement is executed Even before the EJB method that invoked the call is completed. ... I set the auto commit to false on connection as soon as I get the connection from the datasoruce. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Driver AutoCommit issue
    ... I am not using the driver from a stand alone application, ... JDBC in any WebLogic/EJB transaction. ... When in the code do you do a commit? ... Is the connection you're using shared, ...
    (microsoft.public.sqlserver.jdbcdriver)