Hi list,
I am stuck using Wonder (again, the learning curve is steep ;). Trying to fetch data from a postgresql database. The data looks like this:
creationDate (timestamptz) | description varchar(255) | id | tagID | title varchar(50) | url varchar(50) | 2015-12-29 13:46:19 +0100 | This is a new description added from EOF | 1 | 4 | New title | http://example.com |
Fetching the data does not work as soon as I add the field creationDate in the database. The same database and data works well with an App written in WebObjects 5.3. It is a simple component to display the data using a repetion. Similar code is use in the Wonder App and the WebObjects app.
Using Wonder 6.0:
Dec 29 16:05:02 book1[39244] ERROR er.extensions.appserver.ERXApplication - Exception caught: java.lang.NoSuchMethodError: com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object; "CurrentPage" = "your.app.components.Main"; "Bundles" = { "ERExtensions" = "6.2-SNAPSHOT"; "JavaWebObjects" = "5.4.3"; "WOOgnl" = "6.0"; "ERJars" = "6.0"; "PostgresqlPlugIn" = "7.0"; "JavaJDBCAdaptor" = "5.4.3"; "JavaXML" = "5.4.2"; "JavaEOAccess" = "5.4.3"; "JavaEOControl" = "5.4.2"; "JavaFoundation" = "5.4.3"; "ERAttributeExtension" = "6.0"; "book1" = ""; "JavaWOExtensions" = "6.0"; "ERPrototypes" = "6.0"; }; "URL" = "/cgi-bin/WebObjects/book1.woa"; }
The attributes for the creationDate are:
{ attributes = ( { columnName = creationdate; externalType = timestamptz; name = creationDate; prototypeName = dateTime; serverTimeZone = "Europe/Amsterdam"; },
Is there something obviously wrong here? How can I debug this problem? (log4j.logger.er=DEBUG is already used)
Thanks in advance, Bart
Dec 29 16:05:01 book1[39244] DEBUG NSLog - connecting with dictionary: {plugin = "Postgresql"; username = "username"; driver = "org.postgresql.Driver"; password = "<password deleted for log>"; URL = ""; } Dec 29 16:05:01 book1[39244] DEBUG NSLog - connecting with dictionary: {plugin = "Postgresql"; username = "username"; driver = "org.postgresql.Driver"; password = "<password deleted for log>"; URL = ""; } Dec 29 16:05:02 book1[39244] DEBUG NSLog - connection disconnected. Dec 29 16:05:02 book1[39244] DEBUG NSLog - === Begin Internal Transaction Dec 29 16:05:02 book1[39244] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.creationdate, t0.description, t0.id, t0.tagID, t0.title, t0.url, t0.url_icon FROM public.bookmark t0" withBindings: > Dec 29 16:05:02 book1[39244] DEBUG NSLog - fetch canceled Dec 29 16:05:02 book1[39244] DEBUG NSLog - 0 row(s) processed Dec 29 16:05:02 book1[39244] DEBUG NSLog - === Commit Internal Transaction Dec 29 16:05:02 book1[39244] INFO er.transaction.adaptor.Exceptions - Database Exception occured: com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodError] com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object;:java.lang.NoSuchMethodError: com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object; Dec 29 16:05:02 book1[39244] WARN NSLog - <com.webobjects.appserver._private.WOComponentRequestHandler>: Exception occurred while handling request: com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodError] com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object;:java.lang.NoSuchMethodError: com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object; [2015-12-29 16:5:2 CET] <WorkerThread15> com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodError] com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object;:java.lang.NoSuchMethodError: com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object; at com.webobjects.foundation.NSForwardException._runtimeExceptionForThrowable(NSForwardException.java:41) at com.webobjects.eoaccess.EODatabaseChannel._fetchObject(EODatabaseChannel.java:456) at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3071) at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195) at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069) at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1308) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444) at your.app.components.Main.appendToResponse(Main.java:26) at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1385) at er.extensions.appserver.ERXSession.appendToResponse(ERXSession.java:571) at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1794) at er.extensions.appserver.ERXApplication.appendToResponse(ERXApplication.java:2056) at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:242) at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:298) at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:332) at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:369) at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:445) at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1687) at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:2160) at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:2125) at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:144) at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:226) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NoSuchMethodError: com.webobjects.eoaccess.EOAttribute.newValueForDate(Ljava/lang/Object;)Ljava/lang/Object; at com.webobjects.jdbcadaptor.DateJDBCColumn._fetchValue(DateJDBCColumn.java:60) at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372) at com.webobjects.jdbcadaptor.ERXJDBCColumn.fetchValue(ERXJDBCColumn.java:21) at com.webobjects.jdbcadaptor.JDBCChannel.fetchRow(JDBCChannel.java:1462) at com.webobjects.eoaccess.EODatabaseChannel._fetchObject(EODatabaseChannel.java:321)
|