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

Question

MathWorks Support Team 2009-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/98379-why-do-i-receive-error-commit-rollback-problems-when-i-try-to-execute-a-lengthy-query-with-the-dat

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);