Re: Any thing wrong with this..

Mon, 30 Oct 2006 11:14:25 -0800

Gino,

Sorry for the immediate followup, but you are aware that EOF will have no knowledge of this happening so you may end up with some weird behavior with things like primary key generation, any cached snapshots and the like.

If you are relying on EOF then I would suggest doing the insert using EOF, which is, actually, what I generally do unless there is some compelling reason to do the work in raw SQL.

On Oct 30, 2006, at 12:41 PM, Gino Pacitti wrote:

Hi All

I have this code:

        EOEntity anEntity = EOModelGroup.defaultGroup().entityNamed("Photos");
            EOModel aModel = anEntity.model();

            EOAdaptorChannel myAdaptorChannel = this.adaptorChannelForModel(aModel, ec);
            myAdaptorChannel.openChannel();
            StringBuffer sbValue = new StringBuffer();
            sbValue.append("INSERT INTO photos (album,section,sequence,caption,pic) VALUES ("1,1,1,'some text',87);");
            String SQLString = sbValue.toString();
            EOSQLExpressionFactory expressionFactory = new EOSQLExpressionFactory(EOAdaptor.adaptorWithModel(aModel));
            myAdaptorChannel.evaluateExpression(expressionFactory.expressionForString(SQLString));
            myAdaptorChannel.closeChannel();


Can anyone see anything obvious why this will not commit to the database?

Gino
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]

--
Robert Walker


 

 _______________________________________________
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