Why do I receive 'Error:Commit/Rollback Problems' when I try to execute a lengthy query with the Database Toolbox 2.2 (R12.1)?

The properties of the connection are:

 conn =

        Instance: 'ocmsql'

        UserName: 'mbothwell'

          Driver: []

             URL: []

     Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]

         Message: []

          Handle: [1x1 sun.jdbc.odbc.JdbcOdbcConnection]

         TimeOut: 0

      AutoCommit: 'on'

            Type: 'Database Object'

The cursor obtained by running the lengthy query is:

 curs =

         Attributes: []

               Data: 0

     DatabaseObject: [1x1 database]

           RowLimit: 0

           SQLQuery: [1x87 char]

            Message: 'Error:Commit/Rollback Problems'

               Type: 'Database Cursor Object'

          ResultSet: 0

             Cursor: 0

          Statement: 0

              Fetch: 0

After this, even the QUERYTIMEOUT on the cursor fails with the following error message:

 ??? Undefined function or variable 'getQueryTimeout'.

 Error in ==> c:\matlab6p1\toolbox\database\database\@cursor\querytimeout.m

 On line 25  ==> timeOut = getQueryTimeout(cursor.Statement);

Answer 1

[MathWorks Support Team]

There is a bug in the Database Toolbox 2.2 (R12.1) related to executing lengthy queries.

This bug has been resolved in the Database Toolbox 2.2.1 (R13).