On Aug 26, 2010, at 12:14 PM, William Hatch wrote: > I hope this is on topic enough; OB list seems to be dead. > > I've got a utility app using latest wo and wonder, openbase db, that performs > raw fetches to then bulk export data in csv. Basically a simple data > export/dumper thing. This had been working perfectly for a long time, but a > recent run resulted in the following exception, thrown during the call to > EOUtilities.rawRowsForSQL(...) : >
What exception happens here? >> at java.sql.Date.valueOf(Date.java:138) >> at com.openbase.jdbc.f.getDate(null:Unknown) >> at >> com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:288) >> at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384) >> at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) >> ... skipped 1 stack elements >> at com.webobjects.eoaccess.EOUtilities._rawRowsForSQL(EOUtilities.java:636) >> at com.webobjects.eoaccess.EOUtilities.rawRowsForSQL(EOUtilities.java:588) >> at com.imapp.eo.Judgement.rawRows(Judgement.java:53) >> at com.imapp.tasks.JudgementTask.performAction(JudgementTask.java:26) >> at >> er.extensions.ERXLongResponseTask$DefaultImplementation.run(ERXLongResponseTask.java:162) >> ... skipped 1 stack elements >> at >> er.extensions.ERXLongResponseTask$WorkerThread.run(ERXLongResponseTask.java:60) > > which to me, indicates a problem with a date column within the entity > referred to. I got around this particular problem by doing some raw queries > and identifying and deleting row with bad date values, and the problem > vanished. Then it came up again on another table, again with a date type, but > this time I'm unable to find any bad data via direct queries. I debugged > around my action by setting a breakpoint in the catch block, but that's not > helping much. I'm looking for some advice on how to determine and fix, or at > least work around the real issue. Anybody else seen this before? Thanks. Is there old jdbc2info in the model? Is the JDBC driver current? Has it changed? Are you using prototypes? How are dates defined? What is the column type in the model? Chuck -- Chuck Hill Senior Consultant / VP Development 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
