Re: batch update is sporadically incomplete



Yes, I commit before I select again.

Thanks for the advice on connections. I hadn't heard that but it makes
sense. I'll try a connection per Thread and let you know.

Thanks

.



Relevant Pages

  • Re: Psycopg and threads problem
    ... > Istvan Albert wrote: ... >> have a commit at the end of your insert threads. ... > you could store the db connections in a data structure shared across ... the same database session/transaction amongst different connections ...
    (comp.lang.python)
  • RE: Slow connection to Oracle 9i
    ... Call commit, at the end of each "event" ... do not get a transaction too long error (can't remember exactly what its ... Slow connection to Oracle 9i ... >>connections once, and hold open oracle connections across transactions. ...
    (perl.dbi.users)
  • Re: Drop a Global Temporary Table using Classic ASP
    ... the objects you mention are good to clean up. ... An Oracle GTT exists as a single table for all connections. ... away on commit or stays around on commit based on your creation ... Your cleanup step for these should be an issuance of a ...
    (comp.databases.oracle.server)
  • Re: Drop a Global Temporary Table using Classic ASP
    ... the objects you mention are good to clean up. ... An Oracle GTT exists as a single table for all connections. ... away on commit or stays around on commit based on your creation ... Your cleanup step for these should be an issuance of a ...
    (comp.databases.oracle.server)
  • Re: jdbc executeupdate bug
    ... watch for other connections to the database that might be waiting for a ... commit. ...
    (comp.lang.java.programmer)