Uploaded image for project: 'S2Container'
  1. S2Container
  2. CONTAINER-434

コメント入りのSQLファイルでストアドプロシージャを呼び出すとNullPointerException

XMLWordPrintable

    • Type: Icon: Bug Bug
    • Resolution: Won't Fix
    • Priority: Icon: Minor Minor
    • None
    • Affects Version/s: 2.4.43
    • Component/s: S2JDBC
    • None
    • Environment:
      Oracle9i

      NullPointerExceptionが発生するSQLファイルの内容例
      ----------
      /* SQLコメント */

      {call myproc}
      ----------

      正常に発行される例
      ----------
      /* SQLコメント */{call myproc}

      ----------

      →{}の前に改行があると駄目っぽいです。

      Oracle9iでの実行時エラーStackTrace:
      java.lang.NullPointerException
      at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:300)
      at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:270)
      at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1924)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      at org.seasar.framework.util.PreparedStatementUtil.execute(PreparedStatementUtil.java:84)
      at org.seasar.extension.jdbc.query.AbstractFunctionCall.getSingleResultInternal(AbstractFunctionCall.java:114)
      at org.seasar.extension.jdbc.query.AbstractFunctionCall.getSingleResult(AbstractFunctionCall.java:88)

            Assignee:
            higa higa
            Reporter:
            yotsuba yotsuba
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: