How to catch sybase raiseerror in java ?

[Shan Tiruvarur]

assume i am doing this

query= "exec <stored proc name>"
stmt.execute(query)

now, this is a single line stored proc.
...
begin
raiseerror 100001
end
...
...

how do i catch this raiseerror thing back in java ?
i tried catching SQLException but
raiseerror is not wrapped into SQLException.

can someone help me with this ?
thanks.

[Steve Knott]

set nocount on in the sp.
The error code should now be in the resultset on the statement.
perform a ResultSet.next() and getInt()