File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in savepoint" Watch "Problem in savepoint" New topic
Author

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
}
else{
conn.commit();
}

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

Regards


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

Joined: Mar 22, 2005
Posts: 42956
    
  73
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Problem in savepoint
 
It's not a secret anymore!