[ http://jira.jboss.com/jira/browse/JBAS-1564?page=history ]
Adrian Brock reassigned JBAS-1564:
----------------------------------
Assign To: Adrian Brock
> Prepared Statement Cache does not take into account autocommit semantics
> ------------------------------------------------------------------------
>
> Key: JBAS-1564
> URL: http://jira.jboss.com/jira/browse/JBAS-1564
> Project: JBoss Application Server
> Type: Bug
> Components: JCA service
> Versions: JBossAS-4.0.1 SP1, JBossAS-4.0.1 Final, JBossAS-3.2.7 Final
> Reporter: Adrian Brock
> Assignee: Adrian Brock
> Fix For: JBossAS-4.0.2 Final
>
>
> The prepared statement cache (in particular CachedPreparedStatement)
> allows a prepared statement to be reused if the same query is requested twice.
> This does not work with auto-commit semantics:
> JDBC3.0 spec, section 10.1 (Transaction Boundaries and Auto-Commit)
> "For Select statements, the statement is complete when the associated result
> set is closed.
> The result set is closed as soon as one of the following occurs:
> all of the rows have been retrieved
> the associated Statement object is re-executed
> another Statement object is executed on the same connection"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
