[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - prepared-statement-cache-size RETURNING INTO

razshaar do-not-reply at jboss.com
Mon Jan 15 12:50:15 EST 2007

I'm facing a problem caching the following UPDATE callable statement: BEGIN UPDATE TABLE_NAME SET COLUMN_1 RETURNING UPDATE_TIME INTO NEW_UPDATE_TIME; END;

In the datasource xml: <prepared-statement-cache-size>5</prepared-statement-cache-size>

During statement execution, the returned value (NEW_UPDATE_TIME) is never updated and always returned the value from the first execution...

CallableStatement statement = null;
final Timestamp ts = statement.getTimestamp(1);

jboss-4.0.5.GA, Oracle 10g, JDK 1.5.0_09


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4001854#4001854

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4001854

More information about the jboss-user mailing list