This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'ap_SystemAccess' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. I am trying to execute procedure, //cs.executeUpdate("SET CHAINED OFF"); // String sptest = " { call sp_procxmode ccsys.dbo.ap_SystemAccess" + "," + " anymode }" ;
boolean rc1 = cs.execute(); con.commit(); con.setAutoCommit(true); It is giving me above error, then I tried to run sp_proxmode anymode, it is giving syntax error near '.'[ccsys.dbo.ap_SystemAccess] any help appreciated, Thanks, Srini
subject: SybSQLException: Stored procedure 'xxx be run only in un chained mode