Yep,,, I missed a stray "Double" again. Ramsey is correct. Doubles are Evil as they never seem to give the same exception twice.
> I'd guess a problem converting a database value into Java. Check your model > and / or prototypes for mistakes. > > Chuck > > On 2013-06-21, at 7:50 AM, James Cicenia wrote: > >> Here is another database error. mySQL: >> >> Database Exception occured: N/A >> >> INFO (ERXDatabaseContextDelegate.java:185) - Database Exception occured: N/A >> N/A >> at >> com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue(JDBCColumn.java:621) >> at >> com.webobjects.jdbcadaptor.ERXJDBCColumn.takeInputValue(ERXJDBCColumn.java:39) >> at >> com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:260) >> at >> com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337) >> at >> com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296) >> at >> er.extensions.jdbc.ERXJDBCAdaptor$Channel.evaluateExpression(ERXJDBCAdaptor.java:286) >> at >> com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220) >> at >> er.extensions.jdbc.ERXJDBCAdaptor$Channel.selectAttributes(ERXJDBCAdaptor.java:203) >> at >> com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897) >> at >> com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234) >> at >> com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055) >> 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 >> er.extensions.eof.ERXEOControlUtilities.objectWithPrimaryKeyValue(ERXEOControlUtilities.java:593) >> at >> er.extensions.eof.ERXEOControlUtilities.objectWithPrimaryKeyValue(ERXEOControlUtilities.java:542) >> at >> er.extensions.eof.ERXEOControlUtilities.objectWithPrimaryKeyValue(ERXEOControlUtilities.java:520) >> at >> er.extensions.eof.EOEnterpriseObjectClazz.objectWithPrimaryKeyValue(EOEnterpriseObjectClazz.java:322) >> at com.pp.notification.NotificationJob.execute(NotificationJob.java:71) >> at org.quartz.core.JobRunShell.run(JobRunShell.java:213) >> at >> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) >> >> DEBUG (ERXNSLogLog4jBridge.java:47) - evaluateExpression: >> <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "SELECT >> RTRIM(t0.alertString), t0.appConfigAndroidID, t0.appConfigBBID, >> t0.appConfigIOSID, t0.appConfigWinID, t0.appConfigWinPhoneID, t0.appID, >> t0.badge, RTRIM(t0.cronExpression), t0.dateCompleted, t0.dateCreated, >> t0.dateToEndPush, t0.dateToPush, t0.duration, >> RTRIM(t0.encryptedAppContentID), RTRIM(t0.externalShortURL), t0.id, >> t0.isSimple, t0.latitude, t0.longitude, RTRIM(t0.message), >> t0.notificationAlertAppleID, RTRIM(t0.osType), t0.radius, RTRIM(t0.sound), >> t0.status, t0.timesToRepeat, RTRIM(t0.title) FROM Notification t0 WHERE >> ((t0.osType = ? OR t0.osType = ? OR t0.osType = ? OR t0.osType = ? OR >> t0.osType = ? OR t0.osType = ?) AND t0.id = ?)" withBindings: >> 1:"ALL"(osType), 2:"IOS"(osType), 3:"BB"(osType), 4:"ANDROID"(osType), >> 5:"WIN8PHONE"(osType), 6:"WINDOWS"(osType), 7:"1"(id)> >> >> I ran the above sql without a problem. Any thoughts on what N/A means? >> thanks >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >> >> This email sent to [email protected] > > -- > Chuck Hill > Executive Managing Partner, VP Development and Technical Services > > 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/gvc/practical_webobjects > > Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing > Companies in B.C! > > Global Village Consulting ranks 44th in 25th annual PROFIT 500 ranking of > Canada’s Fastest-Growing Companies by PROFIT Magazine! > > > > > > > > > > > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
