Uploaded image for project: 'Spring Framework'
  1. Spring Framework
  2. SPR-11017

Unecessary logging about setNull with Oracle driver

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Complete
    • Affects Version/s: 3.2.4
    • Fix Version/s: 3.2.5, 4.0 RC1
    • Component/s: Data:JDBC
    • Labels:
    • Last commented by a User:
      true

      Description

      This logging output shown more than any words:

      14:40:48.525 DEBUG org.hibernate.SQL
        Caller+0	 at org.hibernate.engine.jdbc.spi.SqlStatementLogger.logStatement(SqlStatementLogger.java:104)
        => 
          update
              DATA_24 
          set
              ...
          where
              ROWID = ?
      .....
      14:40:48.545 TRACE org.springframework.jdbc.core.StatementCreatorUtils
        Caller+0	 at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:206)
        => Setting SQL statement parameter value: column index 7, parameter value [null], value class [null], SQL type unknown
      14:40:48.606 DEBUG org.springframework.jdbc.core.StatementCreatorUtils
        Caller+0	 at org.springframework.jdbc.core.StatementCreatorUtils.setNull(StatementCreatorUtils.java:234)
        => JDBC 3.0 getParameterType call not supportedjava.sql.SQLException: Unsupported feature
      	at oracle.jdbc.driver.OracleParameterMetaData.getParameterType(OracleParameterMetaData.java:166) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0]
      	at org.springframework.jdbc.core.StatementCreatorUtils.setNull(StatementCreatorUtils.java:231) [spring-jdbc-3.2.4.RELEASE.jar:3.2.4.RELEASE]
      ....
      

      Related bugs:

      SPR-10185
      SPR-10385
      SPR-6000

      fixed but dumping a long trace from OracleParameterMetaData.getParameterType is unnecessary because of stupid logging logic of StatementCreatorUtils.setNull

      My logback logging settings:

          <logger level="trace" name="org.springframework.jdbc.core"/>
          <logger level="trace" name="org.hibernate.type"/>
          <logger level="trace" name="org.springframework.jdbc.core"/>
      

        Attachments

          Activity

            People

            • Assignee:
              juergen.hoeller Juergen Hoeller
              Reporter:
              gavenkoa Oleksandr Gavenko
              Last updater:
              Spring Issuemaster
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                47 weeks ago