🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #422

Transaction with queryDataset

#422
From: Salvo Cammaroto
Date: Sat, 03 Dec 2005 10:41
36 lines
2147 bytes
Hi, i'm italian, excuse me for my poor english.
I use JBX and 2005 and MySQL 4.1 with InnoDB, my application works fine.
Now i should want to use transactions, but, if i use:
QueryProvider qProv = new QueryProvider();
   ParameterRow num = new ParameterRow();
   Column param = new Column();
   num.setColumns(new Column[] {param});
   param.setColumnName("ID");
   param.setDataType(com.borland.dx.dataset.Variant.INT);
   param.setParameterType(ParameterType.IN);
   num.setInt("ID",3);
   String qry = new String("Update country SET countryname='USA2' WHERE
ID= :ID ");
   qProv.executeStatement(db2,qry,num);
   db2.commit();
   //or
   //db2.rollback();
It work fine, while if i use QueryDataSet and edit a JdbTable or
some field of a form, and then in an Jbutton_actionPerformed:
qds.saveChanges(qds);
db2.rollback();

rollback() NOT WORK!!!

What'is the code that i have to use for work???

In JbInit() i have:
db2.setTransactionIsolation(java.sql.Connection.
                                TRANSACTION_READ_UNCOMMITTED);
    db2.setUseTransactions(true);
    db2.setAutoCommit(false);
    db2.start();

Thanks, regards
Salvo, Nessina, Italy
      
Technical Details
Message-ID: <4391760a@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!atl-c05.usenetserver.com!news.usenetserver.com!pd7cy2so!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,cffe2fca1563a3ce,start
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Message-ID: <4391760a@newsgroups.borland.com>
From: Salvo Cammaroto <salvocammaroto@tiscalinet.it>
Subject: Transaction with queryDataset
Newsgroups: borland.public.jbuilder.database
Followup-To: salvocammaroto@tiscalinet.it
Reply-To: salvocammaroto@tiscalinet.it
Date: Sat, 03 Dec 2005 11:41:00 +0100
Lines: 36
Organization: xpoint
User-Agent: KNode/0.9.2
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
NNTP-Posting-Host: 82.49.50.248
X-Trace: newsgroups.borland.com 1133606411 82.49.50.248 (3 Dec 2005 02:40:11 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!atl-c05.usenetserver.com!news.usenetserver.com!pd7cy2so!pd7cy1no!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail