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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%
40global-village.net
This email sent to [EMAIL PROTECTED]
--
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
