Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-59

Only holding cursors over commit is supported

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 1.1.3
        • Fix Version/s: None
        • Component/s: None
        • Environment:
          MariaDB 5.5.33 (32-bit), INNODB database engine, mariadb-java-client-1.1.3.jar JDBC driver, Windows 7 (64-bit)

          Description

          While attempting to use MariaDB and the associated JDBC driver with a Java application, an exception was encountered:

          [20130730-15:24:01][tStartDS] Only holding cursors over commit is supported
          java.sql.SQLFeatureNotSupportedException: Only holding cursors over commit is supported
          at org.mariadb.jdbc.internal.SQLExceptionMapper.getFeatureNotSupportedException(SQLExceptionMapper.java:165)

          How to remedy? Please advise, and thank you.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                wlad Vladislav Vaintroub added a comment - - edited

                it is your application, so you would know how the remedy best. What exactly do you expect from setHoldability() ? Why is ResultSet.CLOSE_CURSORS_AT_COMMIT important for your application? What happens if you ignore the java.sql.SQLFeatureNotSupportedException (this is what I would advice , but I have no clue about your app, and you do not tell much either)?

                Show
                wlad Vladislav Vaintroub added a comment - - edited it is your application, so you would know how the remedy best. What exactly do you expect from setHoldability() ? Why is ResultSet.CLOSE_CURSORS_AT_COMMIT important for your application? What happens if you ignore the java.sql.SQLFeatureNotSupportedException (this is what I would advice , but I have no clue about your app, and you do not tell much either)?

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    rehmke rehmke
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 hour
                      1h