Hi All,
I tried using both the doWork() and doReturningWork() methods but for some reasons I have issues when executing the stored procedure in Sybase.
The SP's are by default in "unchained" mode in our environments , so when executing this gives me an error saying 'SP should run only in chained mode .........,'.
Code:
session.doWork(new Work() {
public void execute(Connection connection) throws SQLException {
//connection.setAutoCommit(true);
//sess.createSQLQuery("set chained off").executeUpdate();
}
});
To fix this i tried to even "set chained off" within the above methods using the connection object but then again it fails with the below error.
SET CHAINED command not allowed within multi-statement transaction.Sybase version is 15.5 and hibernate version is 4.1.9
jconn3.jar is used.
Any help is appreciated on this.
Login
FAQ
Search