Skip to Content.
Sympa Menu

freetds - Can not execute two sentences into the same transaction!

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Jordi" <jgimenez AT dc.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Can not execute two sentences into the same transaction!
  • Date: Thu, 1 Feb 2001 06:36:26 -0500


Hi all,

I'm using Freetds JDBC Driver.

First, i execute setAutocommit(false).
After, i execute an UPDATE sentece and SELECT to see results table.
The process hangs at the SELECT statement.
If i use setAutocommit(true) or Commit after Update sentence, the
process works!!. I don't want to commit results if i'm not sure of them,
this is the reason to run UPDATE and SELECT into the same transaction.

Why?.

Thank a lot.





Archive powered by MHonArc 2.6.24.

Top of Page