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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to