Strange Oracle CLOB problem with WO
Strange Oracle CLOB problem with WO
- Subject: Strange Oracle CLOB problem with WO
- From: Ralph Scheuer <email@hidden>
- Date: Thu, 22 Apr 2004 16:38:16 +0200
Hello everybody,
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
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.