[Pljava-dev] Savepoints and PL/Java

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

Responses

Browse pljava-dev by date

  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