Re: WO 5.3 and MS SQL
Re: WO 5.3 and MS SQL
- Subject: Re: WO 5.3 and MS SQL
- From: Travis Britt <email@hidden>
- Date: Sun, 8 Jul 2007 12:23:11 -0400
On Jul 8, 2007, at 2:21 AM, Chuck Hill wrote:
On Jul 7, 2007, at 12:30 PM, Travis Britt wrote:
BTW, I also had to set SelectMethod=Cursor in the URL to get
around the JDBC driver's "Can't start a cloned connection while in
manual transaction mode" exception.
Happily, I have not run across that one yet. What causes that to
happen?
I did some digging (haven't actually used MS SQL in years.)
Apparently, at least with the SQL Server 2000 JDBC driver, if the DB
connection is in manual transaction mode (AutoCommit=false) then the
default SelectMethod (direct) will cause this exception if you
execute multiple statements using the same connection.
I suppose you may not see it if you're not in manual transaction
mode, but have no idea if that mode is default. Maybe that's been
specifically configured on the DB I'm connecting to.
tb
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden