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;
statement.executeUpdate();
final Timestamp ts = statement.getTimestamp(1);
Configuration:
jboss-4.0.5.GA, Oracle 10g, JDK 1.5.0_09
Thanks
R
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4001854#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...