Re: converting from openbase to oracle
Re: converting from openbase to oracle
- Subject: Re: converting from openbase to oracle
- From: Chuck Hill <email@hidden>
- Date: Thu, 16 Mar 2006 23:03:57 -0800
Hi Dave,
On Mar 16, 2006, at 10:06 PM, Dave Elsner wrote:
Hi,
In the process of migrating all the data from one of our Openbase 8
DB to Oracle 9.
To do this I cloned the original EOModel and changed the cloned
model to point to the new Oracle 9 DB, and changed all the column
data type to the appropriate kind. e.g. char > VARCHAR2 , text >
CLOB, etc
I then run my code
EOEnterpriseObject oldObject = (EOEnterpriseObject)
anEnumerator.nextElement();
EOEnterpriseObject newObject = EOUtilities.createAndInsertInstance
(anEditingContext, aNewEntityName);
newObject.takeValuesFromDictionary( (NSDictionary)
oldObject.valuesForKeys(oldObject.attributeKeys()) );
This works fine for all tables in the DB and all rows until it
reaches a CLOB item and I get the following error:
evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn
$OracleExpression: "INSERT INTO EXTERN_DTLS(personID,
currentPositions, biography, qualifications, awards,
professionalActivites, researchInterests) VALUES (?, EMPTY_CLOB(),
NULL, EMPTY_CLOB(), NULL, NULL, EMPTY_CLOB())" withBindings: 1:2020
(personID)>
<main> evaluateExpression:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "SELECT
t0.currentPositions, t0.qualifications, t0.researchInterests FROM
EXTERN_DTLS t0 WHERE t0.personID = ? FOR UPDATE" withBindings:
1:2020(personID)>
Select ... for update often means that some thing is wrong in the
model. Did you remove the jdbc2info key from the connection
dictionary when you cloned the model? Maybe search the archives for
select for update and see what else might trigger this.
<main> fetch canceled
main> 1 row(s) processed
<main> === Rollback Internal Transaction
EXCEPTION:
com.webobjects.foundation.NSKeyValueCoding$Null
That is a rather odd exception as well.
I have been stuck on this for a long time and am running out of
ideas? All columns in the table allow for null values apart from
personID that is set to 2020
I've tried changing the CLOB to BLOB and the java class to String
and NSData but still no luck?
Could it be a plug in problem? my java/extensions has
classes12.zip and ojdbc14.jar for oracle drivers
It might be a plugin bug, but I would suspect something in the model
first.
Chuck
--
Coming in 2006 - an introduction to web applications using WebObjects
and Xcode http://www.global-village.net/wointro
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems. http://www.global-village.net/products/practical_webobjects
_______________________________________________
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