Re: Any thing wrong with this..

Subject: Re: Any thing wrong with this..

From: Robert Walker <email@hidden>

Date: Mon, 30 Oct 2006 14:13:54 -0500

Delivered-to: email@hidden

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@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden

Robert Walker

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: http://lists.apple.com/mailman/options/webobjects-dev/email@hidden This email sent to email@hidden

References:

>Any thing wrong with this.. (From: Gino Pacitti <email@hidden>)