freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Can not execute two sentences into the same transaction!

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.

Can not execute two sentences into the same transaction!, Jordi, 02/01/2001
- <Possible follow-up(s)>
- Re: Can not execute two sentences into the same transaction!, Pier Paolo Bortone, 02/01/2001
- Re: Can not execute two sentences into the same transaction!, Jordi, 02/01/2001
- Re: Can not execute two sentences into the same transaction!, Rich McAneny, 02/26/2001