Re: Database Exception occured: N/A
Re: Database Exception occured: N/A
- Subject: Re: Database Exception occured: N/A
- From: James Cicenia <email@hidden>
- Date: Fri, 21 Jun 2013 10:45:22 -0500
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@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
> --
> 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden