[jboss-jira] [JBoss JIRA] Updated: (JBAS-3981) Statement caching in update query which return value

Statement caching in update query which return value ----------------------------------------------------- Key: JBAS-3981 URL: http://jira.jboss.com/jira/browse/JBAS-3981 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: JCA service Affects Versions: JBossAS-4.0.5.GA Environment: jboss 4.0.5 on windows xp / linux with database oracle 10.0.2 Reporter: erahamim Assigned To: Weston Price Priority: Minor When I set statements cache in oracle-xa-ds.xml: <prepared-statement-cache-size>100</prepared-statement-cache-size> For the following statement: BEGIN UPDATE table SET A=? WHERE ID=? AND TIME=? RETURNING TIME INTO ?; END con = DataSourceManager.getConnection(); statement = con.prepareCall( 'The above query'); statement.setInt(1,1); statement.setTimestamp(2, myTime); statement.registerOutParameter(3, Types.TIMESTAMP); statement.executeUpdate(); final Timestamp ts = statement.getTimestamp(lastIndex); In this scenario, I'm always getting back the time result even if the update didn't match any row in database. When I drop the statement cache I get the result only if there was a row that was updated by this statement. I can't use the return value from executeUpdate() since it always return 1.