Re: WO 5.3 and MS SQL
Re: WO 5.3 and MS SQL
- Subject: Re: WO 5.3 and MS SQL
- From: Chuck Hill <email@hidden>
- Date: Sun, 8 Jul 2007 10:26:07 -0700
On Jul 8, 2007, at 9:23 AM, Travis Britt wrote:
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.
I am happy to say that I am not seeing this with SQL Server 2005. I
have not done anything special with the setup, I don't know how.
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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