• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Writing Oracle Blobs under WO 5.4 - WO fails
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Writing Oracle Blobs under WO 5.4 - WO fails


  • Subject: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • From: Dov Rosenberg <email@hidden>
  • Date: Mon, 25 Feb 2008 19:44:52 -0500

Our app makes extensive use of CLOBS with no problems under 5.4.

Dov

Sent from my iPhone

On Feb 25, 2008, at 7:25 PM, Peter Vandoros <email@hidden> wrote:

Hi Michael,

It sounds like the Oracle JDBC plugin has changes and is generating a different SQL query in WO 5.4.

I would enable SQL debugging in WO 5.3 and WO 5.4 and compare the differences in SQL queries generated.

If you find the WO 5.4 query is different, then i would file a bug report with Apple.

Regards

Peter

Michael Scott wrote:
Thanks Dov – that’s an tricky problem to look out for. Unfortunately my problem is with blobs, not with dates.

I did try the compatibility flag though, but no luck. I also tried the old Oracle 8i driver, but no luck either. The code works fine under WO5.3 with the same drivers, so I’m not surprised.

Is there anyone out there who has successfully written Oracle blobs with WO5.4?

Cheers all
Michael Scott


On 25/2/08 8:14 PM, "Dov Rosenberg" <email@hidden> wrote:

   We had that same error. I don’t think it is your BLOB that is
   causing the problem but how Oracle changed its default behavior on
   the driver and DB regarding the Timestamp and Date data types. The
   ojdbc14.jar drivers have a compatibility mode you can use to get
   around the problem, pass in the following as a JVM parameter.

   -Doracle.jdbc.V8compatible=true


On 2/25/08 12:24 AM, "Michael Scott" <email@hidden> wrote:


       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 c ode
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 p_erformChanges
_com.webobjects.eoaccess
EOObjectStoreCoordinator.java 376 s_aveChangesInEditingContext
_com.webobjects.eocontrol
EOEditingContext.java 3176 s_aveChanges _com.webobjects.eocontrol
Main.java 50 s_aveBlob _Default Package
NativeMethodAccessorImpl.java NA invoke0 sun.reflect
NativeMethodAccessorImpl.java 39 i_nvoke _sun.reflect
DelegatingMethodAccessorImpl.java 25 i_nvoke _sun.reflect
Method.java 585 i_nvoke _java.lang.reflect
KeyValueCodingProtectedAccessor.java 60 m_ethodValue _Default
Package
NSKeyValueCoding.java 1134 v_alueInObject
_com.webobjects.foundation
NSKeyValueCoding.java 1293 v_alueForKey _com.webobjects.foundation
WOComponent.java 1686 v_alueForKey _com.webobjects.appserver
NSKeyValueCoding.java 447 v_alueForKey _com.webobjects.foundation
NSKeyValueCodingAdditions.java 212 v_alueForKeyPath
_com.webobjects.foundation
WOComponent.java 1754 v_alueForKeyPath _com.webobjects.appserver
WOKeyValueAssociation.java 50 v_alueInComponent
_com.webobjects.appserver._private
WOSubmitButton.java 81 i_nvokeAction
_com.webobjects.appserver._private
WODynamicGroup.java 105 i_nvokeChildrenAction
_com.webobjects.appserver._private
WODynamicGroup.java 115 i_nvokeAction
_com.webobjects.appserver._private
WOForm.java 141 i_nvokeAction _com.webobjects.appserver._private
WODynamicGroup.java 105 i_nvokeChildrenAction
_com.webobjects.appserver._private
WODynamicGroup.java 115 i_nvokeAction
_com.webobjects.appserver._private
WOComponent.java 1078 i_nvokeAction _com.webobjects.appserver
WOSession.java 1357 i_nvokeAction _com.webobjects.appserver
WOApplication.java 1736 i_nvokeAction _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 h_andleRequest
_com.webobjects.appserver._private
WOApplication.java 1678 d_ispatchRequest _com.webobjects.appserver
WOWorkerThread.java 144 r_unOnce
_com.webobjects.appserver._private
WOWorkerThread.java 226 r_un _com.webobjects.appserv


--- ---------------------------------------------------------------------
_______________________________________________
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




--
This message has been scanned for viruses and
dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
believed to be clean.
--- ---------------------------------------------------------------------


_______________________________________________
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

-- Peter Vandoros Software Engineer Etech Group Pty Ltd Level 3/21 Victoria St Melbourne VIC 3000 Australia

Ph: +61 3 9639 9677
Fax: +61 3 9639 9577
----------------------------------
IMPORTANT: This e-mail message and any attachments are confidential and may be privileged. If received in error, please reply to this message and destroy all copies and any attachments. You should check this message and any attachments for viruses or defects. Our liability is limited to resupplying any affected message or attachments. For more information about Etech Group, please visit us at http://www.etechgroup.com.au.
_______________________________________________
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
_______________________________________________
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


References: 
 >Re: Writing Oracle Blobs under WO 5.4 - WO fails (From: Michael Scott <email@hidden>)
 >Re: Writing Oracle Blobs under WO 5.4 - WO fails (From: Peter Vandoros <email@hidden>)

  • Prev by Date: Re: Re: creating my EOQualifier in code
  • Next by Date: Re: creating my EOQualifier in code
  • Previous by thread: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • Next by thread: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • Index(es):
    • Date
    • Thread