• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

  • Follow-Ups:
    • Re: Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
      • From: email@hidden
  • Prev by Date: Validating in a subcomponent (reusable component)
  • Next by Date: Re: Rép : WebObjects and Panther
  • Previous by thread: Re: Validating in a subcomponent (reusable component)
  • Next by thread: Re: Help Please: Problem with Insert in Chapter 10 of Web Applications Tutorial
  • Index(es):
    • Date
    • Thread