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: Sat, 7 Jul 2007 12:11:53 -0700
On Jul 7, 2007, at 11:20 AM, Travis Britt wrote:
I'm getting this exception when attempting to fetch data from a MS
SQL Server 2000 database.
Caused by: com.webobjects.eocontrol._private.ParseException:
Encountered "not" at line 1, column 11.
Was expecting one of:
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<STRING_LITERAL> ...
<NULL> ...
<VARIABLE> ...
<IDENTIFIER> ...
<ARGUMENT_PATH> ...
"(" ...
"-" ...
Anyone have any ideas? My EOModel is set to use the
"MicrosoftPlugIn" (though removing it doesn't make a difference)
and I'm using the MS SQL 2000 JDBC driver.
Regrettably, I have some experience with this alleged database. ;-)
Which version are you using? Which driver, this one?
http://www.microsoft.com/downloads/details.aspx?
FamilyID=6d483869-816a-44cb-9787-a866235efc7c&DisplayLang=en
I'd turn on SQL logging -DWOEOAdaptorDebugEnabled=true
and take a look at what it is generating. It might be something in a
qualifier that is not getting generated correctly (or the qualifier
itself may just be wrong).
Chuck
P.S. I recently added a delegate and support code to Wonder
specifically to order operations to avoid the FK constraint
violations that sometimes happen with MS SQueaL.
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