Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2906

bind variables and sql appear when exception thrown

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.7, 8.4.2
    • 8.4
    • JDBC Connector
    • None

      When a query causes an exception, bind variables and sql are written in teiid-command.log and are sent to a client.

      teiid-command.log:-

      19:36:19,942 WARN  [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue29) TEIID30020 Processing exception for request 6jFRdyvDG5bU.0
       'TEIID30504 New_MySQL: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAM
      E`, g_0.`PASSWORD`, g_0.`USERROLE` FROM `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]'. Originally TeiidProcessingException 'Can
       not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.' MysqlIO.java:3039.
       Enable more detailed logging to see the entire stacktrace.
      

      printStackTrace() at client side:-

      org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 New_MySQL: 0 TEIID11008:TEI
      ID11004 Error executing statement(s): [Prepared Values: ['hokuda'] SQL: SELECT g_0.`USERNAME`, g_0.`PASSWORD`, g_0.`USERROLE` FROM 
      `LOGIN`.`USERS` AS g_0 WHERE g_0.`USERNAME` = ?]                                                                                  
              at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
              at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
      

        1. PreparedStatementTest.java
          4 kB
          Hisanobu Okuda
        2. test.vdb
          11 kB
          Hisanobu Okuda

              rhn-engineering-shawkins Steven Hawkins
              rhn-support-hokuda Hisanobu Okuda
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: