File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem in savepoint Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in savepoint" Watch "Problem in savepoint" New topic

Problem in savepoint

Naresh Rajan
Ranch Hand

Joined: Sep 08, 2005
Posts: 45
I have problem while using Savepoint in my code. the code is something like this.

Savepoint asd = new Savepoint("asd");

//do the Process

if (!success){ //sucess is a boolean which says what the process returned
conn.rollback(asd); //conn is the connection variable

It gives me -880 error. Please help me in this regard


Am not a pro and thats why am here!!!
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
Which database do you use? What does its documentation say is error -880? Does the DB even support SavePoints?
Naresh Rajan
Ranch Hand

Joined: Sep 08, 2005
Posts: 45
I am using DB2 and am calling an SP in the process i had described. The description given is that there is no such savepoint or it is not valid in the context used.
I agree. Here's the link:
subject: Problem in savepoint
It's not a secret anymore!