Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Any thing wrong with this..

Maybe try something more like:

EOModel model = entity.model();
EODatabaseContext dbCtxt = databaseContextForModelNamed(ec, model.name());
try {
dbCtxt.lock()
EOSQLExpressionFactory expressionFactory = new EOSQLExpressionFactory(EOAdaptor.adaptorWithModel(model));

EOAdaptorChannel channel = (dbCtxt.availableChannel ()).adaptorChannel();
EOAdaptorContext adaptorContext = channel.adaptorContext();

        adaptorContext.beginTransaction();

EOSQLExpression getUniqueExpression = expressionFactory.expressionForString("INSERT INTO photos (album,section,sequence,caption,pic) VALUES (1,1,1,'some text',87);");
Number initialValue = (Number) EOAdaptorChannelAdditions.resultOfEvaluatingSQLExpression(channel, getUniqueExpression);

EOSQLExpression insert = expressionFactory.expressionForString("SET UNIQUE = " + (initialValue.intValue() + numberOfPKsToCache) + " FOR \"" + entity.externalName() + "\"");
channel.evaluateExpression(insert);
adaptorContext.commitTransaction();
}
finally {
dbCtxt.unlock();
}

I just did that in Mail, so watch for typing errors!  :-)

Chuck


On Oct 30, 2006, at 9:41 AM, 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/chill% 40global-village.net

This email sent to email@hidden


--

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:
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>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.