Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in savepoint

 
Naresh Rajan
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which database do you use? What does its documentation say is error -880? Does the DB even support SavePoints?
 
Naresh Rajan
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic