Article View: borland.public.jbuilder.database
Article #422Transaction with queryDataset
From: Salvo Cammaroto
Date: Sat, 03 Dec 2005 10:41
Date: Sat, 03 Dec 2005 10:41
36 lines
2147 bytes
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-mailShow 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