SelectMethod=cursor
did the trick. > -----Original Message----- > From: Bruce Snyder [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 3:44 PM > To: [EMAIL PROTECTED] > Subject: Re: [castor-dev] [SQLServer JDBC Driver]Can't start a cloned > connection while in m anual transaction mode. > > > This one time, at band camp, Alan Cabrera said: > > AC >java.sql.SQLException: [Microsoft][SQLServer JDBC > Driver]Can't start a > AC >cloned connection while in manual transaction mode. > > Alan, > > I'm just taking a stab at this, but try a db.setAutoCommit( false ) > to see if that affects the error. > > It appears that someone else had this same problem back in early > December: > > http://castor.exolab.org/list-archive/msg12352.html > > > I've also found something here that seems to point the problem at > the driver: > > > http://forum.java.sun.com/thread.jsp?thread=184797&forum=48&me ssage=648658 OK. There is a message in that thread stating that if transaction mode is disabled, the problem goes away. Even more interesting, the last message states that if you pass a particular property to the driver, this will go away: jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
