This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

store procedure with jdbc

Posted by stunning on December 11, 2001 at 9:04 PM

i want to know how to use transaction with procedures.it seems that i need write a transact-sql such as
BEGIN TRANSACTION
EXEC procedure1....
GO
EXEC procedure2...
GO
COMMIT
question 1:how can i excute the same function as the transact-sql sentences above in my java code.now i can execute transaction in 1 procedure.i wrote some code that excute 2 procedures in one transation.it can't run.the error is
[Microsoft][SQLServer JDBC Driver]Can't start a cloned connection while in manual transaction mode.
question 2:i want to know whether it's just the problem of sqlserver or any other database jdbc driver.
thanx in advance and welcome discussion

• Are you closing the connection? Senthoor December 12, 2001 at 7:16 PM (3)
  • thanx for ur reply stunning December 13, 2001 at 8:17 PM (2)
    • Adv & Dis Senthoor December 14, 2001 at 10:06 PM (1)
      • thanx again stunning December 16, 2001 at 8:30 PM (0)