Re: CLOB and WO 5.4.3
Re: CLOB and WO 5.4.3
- Subject: Re: CLOB and WO 5.4.3
- From: Joe Little <email@hidden>
- Date: Wed, 22 Apr 2009 13:34:02 -0700
On Wed, Apr 22, 2009 at 1:31 PM, Mike Schrag <email@hidden> wrote:
> btw:
> dear oracle: put #@$ version numbers on your jar files. love, mike.
> ms
Say hello to your new Java overlords!
> On Apr 22, 2009, at 4:08 PM, Ricardo J. Parada wrote:
>
> Thanks... The newer driver resolved the problem.
> I downloaded the latest driver from:
> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
>
>
>
> On Apr 22, 2009, at 11:42 AM, Dov Rosenberg wrote:
>
> Update your driver to the latest version. The older classes14 and
> nlscharset14 have been replaced with ojdbc14.jar – that should resolve your
> problems
>
> Dov Rosenberg
>
>
> On 4/22/09 11:24 AM, "Ricardo J. Parada" <email@hidden> wrote:
>
> Hi All,
>
> We've been recently testing our application with WO 5.4.3. We use ORACLE.
> One problem we have encountered is that we have an entity with a CLOB as
> the external type and we're getting an unsupported feature exception thrown
> during the editing context saveChanges. In the stack trace I see that the
> OraclePlugIn's updateLOBs() method is getting called. This is then calling
> a setString() in the CLOB class which all it does is throw an exception:
>
> public int setString(long pos, String str)
> throws SQLException
> {
> 1198: DBError.throwUnsupportedFeatureSqlException();
> 1199: return -1;
> }
>
>
> The OraclePlugIn class in WO 5.3.3 does not seem to call this setString()
> method and so we don't get the exception with WO 5.3.3. We only get it with
> WO 5.4.3. I've attached the relevant part of the stack trace at the end of
> this message.
>
> Any advise on this? :-/
>
> Thanks in advance,
> Ricardo Parada
>
>
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
> at
> oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
> at oracle.sql.CLOB.setString(CLOB.java:1198)
> at com.webobjects.jdbcadaptor.OraclePlugIn.updateLOBs(OraclePlugIn.java:358)
> at com.webobjects.jdbcadaptor.JDBCChannel.insertRow(JDBCChannel.java:170)
> at
> com.webobjects.eoaccess.EOAdaptorChannel.performAdaptorOperation(EOAdaptorChannel.java:1178)
> at
> com.webobjects.eoaccess.EOAdaptorChannel.performAdaptorOperations(EOAdaptorChannel.java:1248)
> at
> com.webobjects.eoaccess.EODatabaseContext._performChangesWithAdaptorOps(EODatabaseContext.java:6098)
> at
> com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6198)
> at
> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376)
> at
> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
> at
> com.mpv.webapp.phynance.PhyClaimsStateManager.createPersistentClaimFilterRequest(PhyClaimsStateManager.java:472)
>
> ________________________________
> _______________________________________________
> 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
>
> _______________________________________________
> 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