Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
- Subject: Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
- From: Bob McCormick <email@hidden>
- Date: Fri, 10 Oct 2003 00:02:53 -0700
Hi All,
Sorry - new here and trying to get my head around WO with FrontBase. I
have been following the tutorial in the Web Applications manual for WO5
and am having a database problem which is certainly something that I've
done or not done.
I've followed the directions very closely and have an application that
compiles OK, and also runs OK except when I hit the Save button. Once
I hit Save, I get a pretty impressive error page, but I'll be darned if
I can see what is going on in the code. Since the example is setup to
use OpenBase, I'm not sure if I'm missing something that I need for
FrontBase. I did add the FrontBasePlugin.framework, but wondering if
I'm missing something else.
Here is the error that I'm getting:
Error:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: : Next exception:SQL State:null -- error code: 226 -- msg:
Semantic error 226. Referenced column - BOB - not found. Next
exception:SQL State:null -- error code: 485 -- msg: Semantic error 485.
Near: SELECT \"T0\".\"AUTHOR_ID\" FROM \"AUTHOR\" AS \"T0\" WHERE
(\"T0\".\"FIRST_NAME\"=\"BOB\") AND
(\"T0\".\"LAST_NAME\"=\"MCCORMICK\");. Next exception:SQL
State:null -- error code: 485 -- msg: Semantic error 485. Near:
\"BOB\". Next exception:SQL State:null -- error code: 217 -- msg:
Semantic error 217. Datatypes are not comparable or don't match.
Next exception:SQL State:null -- error code: 226 -- msg: Semantic error
226. Referenced column - MCCORMICK - not found. Next exception:SQL
State:null -- error code: 485 -- msg: Semantic error 485. Near:
\"MCCORMICK\". Next exception:SQL State:null -- error code: 217 --
msg: Semantic error 217. Datatypes are not comparable or don't match.
Next exception:SQL State:40 -- error code: 363 -- msg: Exception
condition 363. Transaction rollback.
Reason:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression:
"SELECT t0."AUTHOR_ID" FROM "Author" t0 WHERE (t0."FIRST_NAME" = Bob
AND t0."LAST_NAME" = McCormick)">: Next exception:SQL State:null --
error code: 226 -- msg: Semantic error 226. Referenced column - BOB -
not found. Next exception:SQL State:null -- error code: 485 -- msg:
Semantic error 485. Near: SELECT \"T0\".\"AUTHOR_ID\" FROM \"AUTHOR\"
AS \"T0\" WHERE (\"T0\".\"FIRST_NAME\"=\"BOB\") AND
(\"T0\".\"LAST_NAME\"=\"MCCORMICK\");. Next exception:SQL
State:null -- error code: 485 -- msg: Semantic error 485. Near:
\"BOB\". Next exception:SQL State:null -- error code: 217 -- msg:
Semantic error 217. Datatypes are not comparable or don't match.
Next exception:SQL State:null -- error code: 226 -- msg: Semantic error
226. Referenced column - MCCORMICK - not found. Next exception:SQL
State:null -- error code: 485 -- msg: Semantic error 485. Near:
\"MCCORMICK\". Next exception:SQL State:null -- error code: 217 --
msg: Semantic error 217. Datatypes are not comparable or don't match.
Next exception:SQL State:40 -- error code: 363 -- msg: Exception
condition 363. Transaction rollback.
Now, since I'm using this EOModeler tool and I'm technically not
supposed to have to touch SQL code, I'm really not sure where to even
begin looking for a problem. Ah, the joys of being a newbie.
Any kind soul out there care to set me straight?
Appreciate any help on this.
Thanks...Bob
Bob McCormick
XebraTech
(805) 302-3359
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.