Uploaded image for project: 'Spring.NET'
  1. Spring.NET
  2. SPRNET-1513

HibernateTransactionManager DoBegin fails with Oracle 8i

    Details

      Description

      There's an issue with HibernateTransactionManager with some versions of Oracle (8i, 10g, maybe others), relating to the fact that the IsolationLevel of DefaultTransactionDefinition is hard-coded to ReadCommitted.

      Oracle will throw the error ORA-01453 SET TRANSACTION must be first statement of transaction.

      Ideally, it would be desirable to be able to change de IsolationLevel of DefaultTransactionDefinition through configuration.

      As a workaround, I've created a subclass of HibernateTransactionManager and overriden the DoBegin method. However, this required a change in Spring.NET, as the protection of HibernateTransactionManager.HibernateTransactionObject is currently private. Would be nice to get this patch incorporated into the code base to allow others to subclass HibernateTransactionManager.

        Attachments

          Activity

            People

            • Assignee:
              sbohlen Steve Bohlen
              Reporter:
              tcrossland Tom Crossland
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: