PicketBox
  1. PicketBox
  2. SECURITY-738

XACML DatabaseResourceAttributeLocator fails when used with Oracle 11g Driver

    Details

    • Type: Bug Bug
    • Status: Resolved Resolved (View Workflow)
    • Priority: Major Major
    • Resolution: Done
    • Affects Version/s: picketbox_xacml_2.0.8.Final
    • Component/s: JBossXACML
    • Security Level: Public (Everyone can see)
    • Labels:
      None
    • Environment:
      EAP 6.0.1
    • Similar Issues:
      Show 10 results 

      Description

      We are using the DatabaseResourceAttributeLocator in jboss-xacml 2.0.8.Final for fetching a policy attribute from an Oracle 11g database. The Oracle JDBC driver is ojdbc6 11.2.0.x. However, the locator fails with an SQLException. The complete stacktrace is attached, but the interesting part is the following:

      Caused by: java.sql.SQLException: error occurred during batching: batch must be either executed or cleared
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3435)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
              at org.jboss.security.xacml.locators.attrib.DatabaseAttributeLocator.getColumnValue(DatabaseAttributeLocator.java:215)
              ... 48 more
      

        Activity

        Hide
        Anil Saldhana
        added a comment -

        Please feel free to fork https://github.com/picketbox/security-xacml and submit a pull request.

        Show
        Anil Saldhana
        added a comment - Please feel free to fork https://github.com/picketbox/security-xacml and submit a pull request.
        Hide
        Anil Saldhana
        added a comment -

        v2.0.9.Final to be released within next 2 weeks.

        Show
        Anil Saldhana
        added a comment - v2.0.9.Final to be released within next 2 weeks.

          People

          • Assignee:
            Anil Saldhana
            Reporter:
            Hisanobu Okuda
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: