[ http://jira.jboss.com/jira/browse/JBAS-1564?page=history ]
Adrian Brock closed JBAS-1564:
------------------------------
Resolution: Done
The prepared statement is not reused when autocommit is on.
Reuse is defined as asking for the same prepared statement twice in the same
transaction without closing the first request statement.
Since this behaviour is not in the spec, I've also disabled reuse for
autocommit==false
However if your database supports it, you can re-enable it with
<share-prepared-statements>true</share-prepared-statements>
in your -ds.xml
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-development
