You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Phil Steitz (JIRA)" <ji...@apache.org> on 2010/02/15 02:51:27 UTC
[jira] Closed: (DBCP-308) ORA-01453: SET TRANSACTION must be first
command of transaction exception with SharedPoolDataSource
[ https://issues.apache.org/jira/browse/DBCP-308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phil Steitz closed DBCP-308.
----------------------------
> ORA-01453: SET TRANSACTION must be first command of transaction exception with SharedPoolDataSource
> ---------------------------------------------------------------------------------------------------
>
> Key: DBCP-308
> URL: https://issues.apache.org/jira/browse/DBCP-308
> Project: Commons Dbcp
> Issue Type: Bug
> Affects Versions: 1.2.2
> Environment: JDK 1.5
> Reporter: Ondrej Tisler
> Priority: Minor
> Fix For: 1.3, 1.4
>
>
> When using SharedPoolDataSource I get ORA-01453: SET TRANSACTION exception on con.setReadOnly(isDefaultReadOnly()); in setupDefaults method
> I correct it with code -
> protected void setupDefaults(Connection con, String username) throws SQLException {
> con.rollback();
> con.setReadOnly(isDefaultReadOnly());
> con.setAutoCommit(isDefaultAutoCommit());
> int defaultTransactionIsolation = getDefaultTransactionIsolation();
> if (defaultTransactionIsolation != UNKNOWN_TRANSACTIONISOLATION) {
> con.setTransactionIsolation(defaultTransactionIsolation);
> }
> }
> rollback is important, without it it ends on same exception ...
> I'm using 10.1.2.0.2 oracle driver
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.