Strange Oracle CLOB problem with WO

Hello everybody,

[sorry for the cross-post, but this is really urgent]

we are experiencing a strange problem with CLOBs in Oracle 9 with WO:

Executing a query on a table containing the CLOB (field name: 
"additionalDataForSearch" with:

longDescription caseinsensitivelike "*rad*"

works perfectly when executed from EOModeler but raises the following 
Exception when performed within an application (Stack Trace below...)

The whole thing worked perfectly until we added the CLOB to our model 
and our DB.

Has anybody experienced the same issue with Oracle and WO? Anything 
obvious I am missing?

Thanks in advance for any hints.

Ralph Scheuer


PS: we are using WO 5.2.3 on Mac OS 10.3.3 with Java 1.4.2.




com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression 
failed: :  Next exception:SQL State:99999 -- error code: 22275 -- msg: 
ORA-22275: invalid LOB locator specified

  EvaluateExpression failed: 
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "SELECT 
t0.a_cache_hasActiveArticlesInt, t0.a_cache_hasActiveProductsInt, 
t0.a_cacheHasProdsForManufInt, t0.a_cache_isActiveInt, t0.priceEURO, 
t0.priceEURONetto, t0.active, t0.activityMatrix, 
t0.adHocForumUserEmail, t0.adHocForumUserName, 
t0.additionalDataForSearch, t0.additionalDescription1, 
t0.additionalDescription2, t0.additionalDescription3, 
t0.additionalDescription4, t0.additionalDescription5, t0.addressRef, 
t0.adminRef, t0.annotation, t0.articleRef, t0.auxiliaryInfo01, 
t0.auxiliaryInfo02, t0.auxiliaryInfo03, t0.auxiliaryInfo04, 
t0.auxiliaryInfo05, t0.auxiliaryInfo06, t0.auxiliaryInfo07, 
t0.auxiliaryInfo08, t0.auxiliaryInfo09, t0.auxiliaryInfo10, 
t0.auxiliaryOption01, t0.auxiliaryOption02, t0.auxiliaryOption03, 
t0.auxiliaryOption04, t0.auxiliaryOption05, t0.auxiliaryOption06, 
t0.auxiliaryOption07, t0.auxiliaryOption08, t0.auxiliaryOption09, 
t0.auxiliaryOption10, t0.availability, t0.beginningDate, 
t0.bundleProduct, t0.buyable, t0.catchwords, t0.categoryTypeIndex, 
t0.clubref, t0.iiComment, t0.communityAdminRef1, t0.communityAdminRef2, 
t0.communityRef1, t0.communityRef2, t0.complete, t0.componentRef, 
t0.CONTENTLIABLEFORCOSTS, t0.contextIndex, t0.createDate, 
t0.currentCategoryTypes, t0.customFlag1, t0.customFlag2, 
t0.customFlag3, t0.customFlag4, t0.customFlag5, t0.customOptionRef, 
t0.customerRef, t0.deleted, t0.iiDirty, t0.endDate, 
t0.eventLocationRef, t0.expireDate, t0.externalDataTypeRef, 
t0.externalItemNumber1, t0.externalItemNumber2, t0.findable, t0.header, 
t0.headerFeature, t0.identifyer, t0.imageSubText, t0.imagepathFeature, 
t0.imagepathLarge, t0.imagepathSmall, t0.imagepathTitle, t0.importInfo, 
t0.infoItemDataTypeRef, t0.infoItemRef, t0.infoItemTypeRef, 
t0.infoLink, t0.isEventLocation, t0.hersteller, t0.itemDate, 
t0.itemKey, t0.itemNumber, t0.locationString, t0.longDescription, 
t0.manufacturer, t0.manufacturerComment, t0.mediaLink, 
t0.mediumDescription, t0.nameGerman, t0.orderHintRef, t0.pricegroup, 
t0.rabattable, t0.regionRef, t0.iiKey, t0.shopCategoryCode, 
t0.shopCategoryString, t0.shopRef, t0.shortDescription, 
t0.shortDescriptionFeature, t0.simpleURL, t0.iiSize, 
t0.size_horizontal, t0.size_vertical, t0.size2_horizontal, 
t0.size2_vertical, t0.size3_horizontal, t0.size3_vertical, t0.sortKey, 
t0.startDate, t0.string, t0.subheader, t0.occasionString, 
t0.topProduct, t0.updateDate, t0.url, t0.vat, t0.weight FROM 
DFIInfoItem t0 WHERE UPPER(t0.longDescription) LIKE UPPER(EMPTY_CLOB()) 
ESCAPE '\'">:  Next exception:SQL State:99999 -- error code: 22275 -- 
msg: ORA-22275: invalid LOB locator specified


JDBCContext.java
138
_jdbcErrorWithChannel
com.webobjects.jdbcadaptor

JDBCChannel.java
304
_evaluateExpression
com.webobjects.jdbcadaptor

JDBCChannel.java
255
evaluateExpression
com.webobjects.jdbcadaptor

JDBCChannel.java
185
selectAttributes
com.webobjects.jdbcadaptor

EODatabaseChannel.java
879
_selectWithFetchSpecificationEditingContext
com.webobjects.eoaccess

EODatabaseChannel.java
216
selectObjectsWithFetchSpecification
com.webobjects.eoaccess

EODatabaseContext.java
3178
_objectsWithFetchSpecificationEditingContext
com.webobjects.eoaccess

EODatabaseContext.java
3319
objectsWithFetchSpecification
com.webobjects.eoaccess

EOObjectStoreCoordinator.java
535
objectsWithFetchSpecification
com.webobjects.eocontrol

EOEditingContext.java
4036
objectsWithFetchSpecification
com.webobjects.eocontrol

EODatabaseDataSource.java
633
fetchObjects
com.webobjects.eoaccess

WODisplayGroup.java
2191
fetch
com.webobjects.appserver

D2WListPage.java
196
setDataSource
com.webobjects.directtoweb

D2WQueryAllEntitiesPage.java
88
queryAction
com.webobjects.directtoweb

NativeMethodAccessorImpl.java
NA
invoke0
sun.reflect

NativeMethodAccessorImpl.java
39
invoke
sun.reflect

DelegatingMethodAccessorImpl.java
25
invoke
sun.reflect

Method.java
324
invoke
java.lang.reflect

NSKeyValueCoding.java
684
methodValue
com.webobjects.foundation

NSKeyValueCoding.java
1160
valueInObject
com.webobjects.foundation

NSKeyValueCoding.java
1268
valueForKey
com.webobjects.foundation

WOComponent.java
1539
valueForKey
com.webobjects.appserver

NSKeyValueCoding.java
498
valueForKey
com.webobjects.foundation

NSKeyValueCodingAdditions.java
212
valueForKeyPath
com.webobjects.foundation

WOComponent.java
1600
valueForKeyPath
com.webobjects.appserver

WOKeyValueAssociation.java
46
valueInComponent
com.webobjects.appserver._private

WOActiveImage.java
255
invokeAction
com.webobjects.appserver._private

WODynamicGroup.java
101
invokeChildrenAction
com.webobjects.appserver._private

WODynamicGroup.java
110
invokeAction
com.webobjects.appserver._private

WOForm.java
82
invokeAction
com.webobjects.appserver._private

WODynamicGroup.java
101
invokeChildrenAction
com.webobjects.appserver._private

WODynamicGroup.java
110
invokeAction
com.webobjects.appserver._private

WORepetition.java
196
invokeAction
com.webobjects.appserver._private

WODynamicGroup.java
101
invokeChildrenAction
com.webobjects.appserver._private

WOGenericContainer.java
23
invokeAction
com.webobjects.appserver._private

WODynamicGroup.java
101
invokeChildrenAction
com.webobjects.appserver._private

WODynamicGroup.java
110
invokeAction
com.webobjects.appserver._private

WOComponentContent.java
31
invokeAction
com.webobjects.appserver._private

WODynamicGroup.java
101
invokeChildrenAction
com.webobjects.appserver._private

WODynamicGroup.java
110
invokeAction
com.webobjects.appserver._private

WOComponent.java
945
invokeAction
com.webobjects.appserver

WOComponentReference.java
104
invokeAction
com.webobjects.appserver._private

WOSwitchComponent.java
171
invokeAction
com.webobjects.appserver._private

WOComponent.java
945
invokeAction
com.webobjects.appserver

WOSession.java
1166
invokeAction
com.webobjects.appserver

WOApplication.java
1377
invokeAction
com.webobjects.appserver

WOComponentRequestHandler.java
196
_dispatchWithPreparedPage
com.webobjects.appserver._private

WOComponentRequestHandler.java
287
_dispatchWithPreparedSession
com.webobjects.appserver._private

WOComponentRequestHandler.java
322
_dispatchWithPreparedApplication
com.webobjects.appserver._private

WOComponentRequestHandler.java
358
_handleRequest
com.webobjects.appserver._private

WOComponentRequestHandler.java
432
handleRequest
com.webobjects.appserver._private

WOApplication.java
1308
dispatchRequest
com.webobjects.appserver

WOWorkerThread.java
173
runOnce
com.webobjects.appserver._private

WOWorkerThread.java
254
run
com.webobjects.appserver._private

Thread.java
552
run
java.lang

_______________________________________________
EOF mailing list
[email protected]
http://www.omnigroup.com/mailman/listinfo/eof