Catch raiserror via java

[mashinata]

i have procedure

create procedure sp_raiserrorSample()
begin
declare num integer;
set num=1;
if num = 1 then
raiserror 99999 'I raised this error';
end if;

set num=2;
if num = 2 then
//execute code
end if;
end;


I call procedure from java via this method:

public void sampleCode() throws SQLException, ClassNotFoundException
{
java.sql.ResultSet rs = null;
Connection _con = null;

try
{
//create connection

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

String url = String.format("jdbc:sybase:Tds:%s:%s", "xxx.xxx.xxx.xxx","xxxx");

Properties prop= new Properties();
prop.setProperty("user","xxxxx");
prop.setProperty("password","xxxxx");
prop.setProperty("ServiceName","xxxxx");

_con = DriverManager.getConnection(url, prop);
_con.setAutoCommit(false);



//after connection is created

CallableStatement cst = _con.prepareCall("{call sp_raiserrorSample()}");
rs = cst.executeQuery();
while(rs.next())
{
System.out.println(" in while ");
}

if (rs != null)
rs.close();

}
catch (SQLException ex)
{
System.err.println("ERROR:"+ex.getMessage());
}
catch (Exception ex)
{
System.err.println("ERROR:"+ex.getMessage());
}
finally
{
if(_con != null)
_con.close();
}
}//end sampleCode()




Problem is: when execute
raiserror 99999 'I raised this error';
, executing of procedure continue.
When execute
set num=2;
if num = 2 then
//execute code
end if;

after that I get raiserror .
How to stop executing of procedure when is execute raiserror 99999 'I raised this error';


When set option continue_after_raierror = off
result is equal;

[PhHein]

International crossposting day or something.
Java Database Connectivity (JDBC) - Catch raiserror via java

[Steve11235]

The problem is in your stored procedure. Look at the database manager documentation. This has nothing to do with Java.