Hi All

Has anyone had any success writing blobs to an Oracle DB under WO 5.4?

I have a large project that makes extensive use of blobs and works fine
under WO 5.3 but throws the following error when writing a blob under WO
5.4:

com.webobjects.eoaccess.EOGeneralAdaptorException: Unsupported feature
(See full dump below.)

The code can read existing blobs from an Oracle DB without any problems.
It¹s just writing that causes exceptions.

To eliminate other factors, I created a test project with a simple version
of the offending code.  It uses a table ­ BlobTable ­ with just a primary
key and a blob field.  The code attempting the write is below.  It gets text
data from a form via a key called Œnotes¹.  (The BlobTable already contains
one record.)

  NSArray blobs = 
EOUtilities.objectsForEntityNamed(session().defaultEditingContext(),
"BlobTable");
 if ((blobs != null) && (blobs.count() > 0)) {
   BlobTable  blob = (BlobTable)blobs.objectAtIndex(0);
    NSData blobData = new NSData(notes(), "UTF8");
   blob.setBlobData(blobData);
   session().defaultEditingContext().saveChanges();
 }

The problem is occurring on an OS X Leopard box in either Xcode or Eclipse
(not that that should matter).  The JDBC driver is for Oracle 9i 9.2.0.8 ­
it¹s a file called ojdbc14.jar.

If anyone has Oracle blobs working under 10.4, that would be great news ­
I¹d would then know to dig deeper rather than file a bug report.

Better still ­ how did you do it?

Thanks

Michael Scott
Murdoch University



Application: Cafe
 com.webobjects.eoaccess.EOGeneralAdaptorException: Unsupported feature

File                                  Line#    Method    Package
EODatabaseContext.java                4500
_exceptionWithDatabaseContextInformationAdded    com.webobjects.eoaccess
EODatabaseContext.java                6212  performChanges
com.webobjects.eoaccess
EOObjectStoreCoordinator.java         376   saveChangesInEditingContext
com.webobjects.eocontrol
EOEditingContext.java                 3176  saveChanges
com.webobjects.eocontrol
Main.java                             50    saveBlob    Default Package
NativeMethodAccessorImpl.java         NA    invoke0    sun.reflect
NativeMethodAccessorImpl.java         39    invoke    sun.reflect
DelegatingMethodAccessorImpl.java     25    invoke    sun.reflect
Method.java                           585   invoke    java.lang.reflect
KeyValueCodingProtectedAccessor.java  60    methodValue    Default Package
NSKeyValueCoding.java                 1134  valueInObject
com.webobjects.foundation
NSKeyValueCoding.java                 1293  valueForKey
com.webobjects.foundation
WOComponent.java                      1686  valueForKey
com.webobjects.appserver
NSKeyValueCoding.java                 447   valueForKey
com.webobjects.foundation
NSKeyValueCodingAdditions.java        212   valueForKeyPath
com.webobjects.foundation
WOComponent.java                      1754  valueForKeyPath
com.webobjects.appserver
WOKeyValueAssociation.java            50    valueInComponent
com.webobjects.appserver._private
WOSubmitButton.java                   81    invokeAction
com.webobjects.appserver._private
WODynamicGroup.java                   105   invokeChildrenAction
com.webobjects.appserver._private
WODynamicGroup.java                   115   invokeAction
com.webobjects.appserver._private
WOForm.java                           141   invokeAction
com.webobjects.appserver._private
WODynamicGroup.java                   105   invokeChildrenAction
com.webobjects.appserver._private
WODynamicGroup.java                   115   invokeAction
com.webobjects.appserver._private
WOComponent.java                      1078  invokeAction
com.webobjects.appserver
WOSession.java                        1357  invokeAction
com.webobjects.appserver
WOApplication.java                    1736  invokeAction
com.webobjects.appserver
WOComponentRequestHandler.java        206   _dispatchWithPreparedPage
com.webobjects.appserver._private
WOComponentRequestHandler.java        298   _dispatchWithPreparedSession
com.webobjects.appserver._private
WOComponentRequestHandler.java        332   _dispatchWithPreparedApplication
com.webobjects.appserver._private
WOComponentRequestHandler.java        369   _handleRequest
com.webobjects.appserver._private
WOComponentRequestHandler.java        445   handleRequest
com.webobjects.appserver._private
WOApplication.java                    1678  dispatchRequest
com.webobjects.appserver
WOWorkerThread.java                   144   runOnce
com.webobjects.appserver._private
WOWorkerThread.java                   226   run    com.webobjects.appserv

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to