Re: SOLVED Re: converting from openbase to oracle
Re: SOLVED Re: converting from openbase to oracle
- Subject: Re: SOLVED Re: converting from openbase to oracle
- From: Chuck Hill <email@hidden>
- Date: Sun, 19 Mar 2006 20:14:09 -0800
On Mar 19, 2006, at 7:09 PM, Dave Elsner wrote:
Update FYI:
I solved this problem it was to do with the model ( Chuck was right
once again ). I fixed it by turning off propagates primary key and
owns destination for all relationships. Thanks to all that helped.
I don't see how this caused the exception below, but if you have
propagates primary key set on to-one, EOF will create the related
object for you when the main object is created. If you then create
the related object (again!) in code, an empty object will be left
floating in the editing context. This will cause exceptions when
saveChanges is called, but I've not see the one you report below.
And that does not explain why the same code worked with Openbase.
Curious...
Chuck
On 17/03/2006, at 5: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)>
<main> fetch canceled
main> 1 row(s) processed
<main> === Rollback Internal Transaction
EXCEPTION:
com.webobjects.foundation.NSKeyValueCoding$Null
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
Thanks
Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40uow.edu.au
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:
40global-village.net
This email sent to email@hidden
--
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