error with jdbc

• bob20000

  SSC Veteran

  Points: 228

  More actions

  November 12, 2002 at 2:45 am

  #79049

  i have got this error

  what does it mean?

  and how i can resolve this error?

  Exception : java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

  Details : [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

  Stack Trace :

  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

  thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 12, 2002 at 4:36 am

  #441097

  This seems to depend on the JDBC driver version you are running as some folks do not run across. Try adding

  SelectMethod=cursor

  to your connection string like this

  pmf.setConnectionURL("jdbc:microsoft:sqlserver://xxx;databasename=yyy;SelectMethod=cursor");

  and see what happens. Found this in the forums at http://www.libelis.com/, they are very helpfull in the java realm there.