Re: [Wonder-disc] JDBCAdapter / JDBCColumn exception

[Edgar K. <edg...@gm...>]

On 8-Dec-08, at 3:20 PM, Chuck Hill wrote:

>
> On Dec 8, 2008, at 1:07 PM, Edgar Klein wrote:
>
>> Hi Chuck,
>>
>> On 8-Dec-08, at 12:26 PM, Chuck Hill wrote:
>>
>>>
>>> On Dec 8, 2008, at 10:55 AM, Edgar Klein wrote:
>>>
>>>> Hi all,
>>>>
>>>> I have a very strange problem. Our application runs in developer  
>>>> mode
>>>> but it crashes in production (see stack trace below).
>>>>
>>>> My first assumption were that we have different properties in those
>>>> environments, so I used
>>>> ERXConfigurationManager.defaultManager().commandLineArguments() to
>>>> find out which properties are being used/set, however I couldn't  
>>>> find
>>>> the right settings or there are some which are not being displayed.
>>>>
>>>> - Is there another way to find out which bindings are being used /
>>>> set?
>>>> - How can I find out what are being set as database connection
>>>> properties?
>>>>
>>>> Any hints, tipps, or suggestions are very welcome :).
>>>>
>>>> cheers,
>>>> Edgar
>>>>
>>>> The system is:
>>>> Mac OS X 10.5.5
>>>> WebObjects 5.4.3
>>>> WOnder nightly
>>>>
>>>> N/AN/A
>>>
>>> What is N/AN/A?
>>
>> I have no idea?, but that's what it gives me ;).
>>
>>> It sounds like your prototypes are not getting loaded or the plugin
>>> is not getting loaded or there are driver differences or...
>>
>> I have also a local deployment and the same error occurs. What I
>> should have mentioned is that the whole app works, just one query
>> doesn't seem to be working ...
>>
>> ERXInQualifier productsIDQualifier = new
>> ERXInQualifier(Product.PRODUCT_ID, currentProductIDs);
>
> Any chance that currentProductIDs contains strings or EOs or  
> something other than a number?

Yes, it's an NSMutableArray<String>. Why?

Edgar

>> EOQualifier qualifier = ERXQ.and(orgQualifier, productsIDQualifier);
>> NSArray myProducts =
>> ERXEOControlUtilities.objectsWithQualifier(this.editingContext(),
>> Product.ENTITY_NAME, qualifier, null, false);
>>
>> I'm not doing anything fancy :/.
>>
>> I also exchanged the ERXInQualifier with EOOrQualifier(s) but I get
>> the same error.
>>
>> cheers,
>> Edgar
>>
>>>> 	at
>>>> com 
>>>> .webobjects.jdbcadaptor.JDBCColumn.takeInputValue(JDBCColumn.java:
>>>> 621)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .jdbcadaptor.ERXJDBCColumn.takeInputValue(ERXJDBCColumn.java:54)
>>>> 	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
>>>> com
>>>> .webobjects
>>>> .jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:
>>>> 220)
>>>> 	at er.extensions.jdbc.ERXJDBCAdaptor
>>>> $Channel.selectAttributes(ERXJDBCAdaptor.java:150)
>>>> 	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:
>>>> 1114)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .eocontrol
>>>> .EOEditingContext
>>>> .objectsWithFetchSpecification(EOEditingContext.java:
>>>> 4444)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .eof
>>>> .ERXEOControlUtilities
>>>> .objectsWithQualifier(ERXEOControlUtilities.java:
>>>> 1297)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .eof
>>>> .ERXEOControlUtilities
>>>> .objectsWithQualifier(ERXEOControlUtilities.java:
>>>> 1248)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .eof
>>>> .ERXEOControlUtilities
>>>> .objectsWithQualifier(ERXEOControlUtilities.java:
>>>> 1224)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .eof
>>>> .ERXEOControlUtilities
>>>> .objectsWithQualifier(ERXEOControlUtilities.java:
>>>> 1220)
>>>> 	at
>>>> com
>>>> .driveitshop
>>>> .admin
>>>> .components
>>>> .EmbeddedProductList
>>>> .myProductsInShopToItBatch(EmbeddedProductList.java:1377)
>>>> 	at
>>>> com
>>>> .driveitshop
>>>> .admin
>>>> .components
>>>> .EmbeddedProductList.shopToItProducts(EmbeddedProductList.java: 
>>>> 1428)
>>>> 	at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
>>>> 	at
>>>> sun
>>>> .reflect
>>>> .DelegatingMethodAccessorImpl
>>>> .invoke(DelegatingMethodAccessorImpl.java:
>>>> 25)
>>>> 	at java.lang.reflect.Method.invoke(Method.java:585)
>>>> 	at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor
>>>> $1.methodValue(NSKeyValueCoding.java:636)
>>>> 	at com.webobjects.foundation.NSKeyValueCoding
>>>> $_MethodBinding.valueInObject(NSKeyValueCoding.java:1134)
>>>> 	at com.webobjects.foundation.NSKeyValueCoding
>>>> $DefaultImplementation.valueForKey(NSKeyValueCoding.java:1324)
>>>> 	at
>>>> com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:
>>>> 1736)
>>>> 	at
>>>> com
>>>> .driveitshop
>>>> .extensions.DSLiteComponent.valueForKey(DSLiteComponent.java:286)
>>>> 	at com.webobjects.foundation.NSKeyValueCoding
>>>> $Utility.valueForKey(NSKeyValueCoding.java:447)
>>>> 	at com.webobjects.foundation.NSKeyValueCodingAdditions
>>>> $
>>>> DefaultImplementation 
>>>> .valueForKeyPath(NSKeyValueCodingAdditions.java:
>>>> 216)
>>>> 	at
>>>> com
>>>> .webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:
>>>> 1804)
>>>> 	at
>>>> com
>>>> .driveitshop
>>>> .extensions.DSLiteComponent.valueForKeyPath(DSLiteComponent.java: 
>>>> 231)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private
>>>> .WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:
>>>> 50)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> .WOAssociation.booleanValueInComponent(WOAssociation.java:
>>>> 276)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals
>>>> .ERXWOConditional.conditionInComponent(ERXWOConditional.java:45)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals
>>>> .ERXWOConditional.meetsConditionInComponent(ERXWOConditional.java: 
>>>> 50)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:
>>>> 101)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components._private.ERXWOForm.invokeAction(ERXWOForm.java:
>>>> 180)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WOComponentContent.invokeAction(WOComponentContent.java: 
>>>> 38)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at  
>>>> er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:
>>>> 98)
>>>> 	at
>>>> er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:
>>>> 62)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:
>>>> 1079)
>>>> 	at
>>>> er
>>>> .extensions.components.ERXComponent.invokeAction(ERXComponent.java:
>>>> 93)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private
>>>> .WOComponentReference.invokeAction(WOComponentReference.java:
>>>> 127)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at  
>>>> er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:
>>>> 98)
>>>> 	at
>>>> er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:
>>>> 62)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals
>>>> .ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:111)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:
>>>> 102)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at  
>>>> er.ajax.AjaxDynamicElement.invokeAction(AjaxDynamicElement.java:
>>>> 98)
>>>> 	at
>>>> er.ajax.AjaxUpdateContainer.invokeAction(AjaxUpdateContainer.java:
>>>> 62)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:
>>>> 1079)
>>>> 	at
>>>> er
>>>> .extensions.components.ERXComponent.invokeAction(ERXComponent.java:
>>>> 93)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private
>>>> .WOComponentReference.invokeAction(WOComponentReference.java:
>>>> 127)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WOComponentContent.invokeAction(WOComponentContent.java: 
>>>> 38)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals
>>>> .ERXWOConditional.invokeChildrenAction(ERXWOConditional.java:111)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .components
>>>> .conditionals.ERXWOConditional.invokeAction(ERXWOConditional.java:
>>>> 102)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WOGenericContainer.invokeAction(WOGenericContainer.java: 
>>>> 29)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:
>>>> 1079)
>>>> 	at
>>>> er
>>>> .extensions.components.ERXComponent.invokeAction(ERXComponent.java:
>>>> 93)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private
>>>> .WOComponentReference.invokeAction(WOComponentReference.java:
>>>> 127)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private.WODynamicGroup.invokeChildrenAction(WODynamicGroup.java:
>>>> 105)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver 
>>>> ._private.WODynamicGroup.invokeAction(WODynamicGroup.java:
>>>> 115)
>>>> 	at
>>>> com.webobjects.appserver.WOComponent.invokeAction(WOComponent.java:
>>>> 1079)
>>>> 	at
>>>> er
>>>> .extensions.components.ERXComponent.invokeAction(ERXComponent.java:
>>>> 93)
>>>> 	at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:
>>>> 1357)
>>>> 	at
>>>> com
>>>> .clickspace.driveit.dicommon.DISession.invokeAction(DISession.java:
>>>> 198)
>>>> 	at
>>>> com
>>>> .webobjects 
>>>> .appserver.WOApplication.invokeAction(WOApplication.java:
>>>> 1745)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .appserver
>>>> .ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:49)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .appserver.ERXApplication.invokeAction(ERXApplication.java:
>>>> 1539)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver
>>>> ._private
>>>> .WOComponentRequestHandler
>>>> ._dispatchWithPreparedPage(WOComponentRequestHandler.java:206)
>>>> 	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
>>>> er.ajax.AjaxRequestHandler.handleRequest(AjaxRequestHandler.java: 
>>>> 17)
>>>> 	at
>>>> com
>>>> .webobjects
>>>> .appserver.WOApplication.dispatchRequest(WOApplication.java:
>>>> 1687)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .appserver
>>>> .ERXApplication.dispatchRequestImmediately(ERXApplication.java: 
>>>> 1656)
>>>> 	at
>>>> er
>>>> .extensions
>>>> .appserver.ERXApplication.dispatchRequest(ERXApplication.java:1620)
>>>> 	at
>>>> com
>>>> .clickspace
>>>> .driveit.dicommon.DIApplication.dispatchRequest(DIApplication.java:
>>>> 575)
>>>> 	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:613)
>>>>
>>>> ------------------------------------------------------------------------------
>>>> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,
>>>> Nevada.
>>>> The future of the web can't happen without you.  Join us at MIX09
>>>> to help
>>>> pave the way to the Next Web now. Learn more and register at
>>>> http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
>>>> _______________________________________________
>>>> Wonder-disc mailing list
>>>> Won...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/wonder-disc
>>>>
>>>
>>> -- 
>>> 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
>>>
>>>
>>>
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas,  
>> Nevada.
>> The future of the web can't happen without you.  Join us at MIX09  
>> to help
>> pave the way to the Next Web now. Learn more and register at
>> http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
>> _______________________________________________
>> Wonder-disc mailing list
>> Won...@li...
>> https://lists.sourceforge.net/lists/listinfo/wonder-disc
>>
>
> -- 
> 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
>
>
>
>
>