• 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
SQLite INSERT errors with WO
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SQLite INSERT errors with WO


  • Subject: SQLite INSERT errors with WO
  • From: Josef Vanek <email@hidden>
  • Date: Sat, 17 Jan 2009 15:11:53 +0100

Hi all,

I am trying to make work a very simple WebObjects app. I have a minimalist EOModel with only one entity for testing purposes.
The database connection dictionnary is as follows: 

Driver: org.sqlite.JDBC
URL: jdbc:sqlite:/<absolute path>/database.db
JDBC driver: sqlitejdbc-v054.jar

When I try to insert or update an existing object with editingContext.saveChanges() the connection
to the db is ok, but when executing the query, it throws an exception with the following stack:

A fatal exception occurred: EvaluateExpression failed: <com.webobjects.jdbcadaptor.JDBCExpression: "UPDATE pages SET description = ?, options = ? WHERE id = ?" withBindings: 1:"test"(description), 2:"test options"(options), 3:7103(id)>:
    Next exception:SQL State:null -- error code: 0 -- msg: no ResultSet available
[2009-01-17 14:59:04 CET] <main> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.JDBCExpression: "UPDATE pages SET description = ?, options = ? WHERE id = ?" withBindings: 1:"test"(description), 2:"test options"(options), 3:7103(id)>:
    Next exception:SQL State:null -- error code: 0 -- msg: no ResultSet available
at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4685)
at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6393)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:415)
at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3226)

Does anybody have a clue what am I doing wrong here ?

Many thanks

Josef

 _______________________________________________
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

  • Follow-Ups:
    • Re: SQLite INSERT errors with WO
      • From: Mike Schrag <email@hidden>
  • Prev by Date: Altering EOModel
  • Next by Date: Re: SQLite INSERT errors with WO
  • Previous by thread: Re: Altering EOModel
  • Next by thread: Re: SQLite INSERT errors with WO
  • Index(es):
    • Date
    • Thread