From: | jeffreylyon at mac(dot)com (Jeffrey Lyon) |
---|---|
To: | |
Subject: | [Pljava-dev] Savepoints and PL/Java |
Date: | 2006-10-04 00:13:00 |
Message-ID: | 54C58E85-14CF-43F9-8B4A-A0EC5DF468A1@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Perhaps an easy one...
I'd like to drop a Savepoint to be committed or rolled-back,
depending upon the results of a function call, i.e.:
int something()
{
Database db = DriverManager.getConnection("jdbc:default:connection");
Savepoint savePoint = db.setSavepoint();
int result;
try
{
result = trySomethingWithSQL(db);
}
catch (Exception e)
{
db.rollback(savePoint);
return -1;
}
db.commit(savePoint);
return result;
};
I see that, although setSavepoint and releaseSavepoint are available,
commit and rollback are not. What is the point of set/
releaseSavepoint if I cannot commit or rollback from a Savepoint? Is
there any other way to accomplish the above?
Thanks in advance,
Jeff Lyon
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-10-04 05:17:44 | [Pljava-dev] Savepoints and PL/Java |
Previous Message | Markus Schaber | 2006-10-02 15:02:56 | [Pljava-dev] pljava on Debian AMD64: undefined symbol: JNI_CreateJavaVM during installation |