[Seasar-user:15071] Re: [DBFlute] Oracle9i(9.2.0.1.0)でバッチファイルのエラー

2008年 7月 17日 (木) 16:27:11 JST

久保(jflute)です。

西山さん、こんにちは

取り急ぎのコメントです。

> replace-schema.bat
こちら、「ORA-01861: リテラルが書式文字列と一致しません」
が発生していて、自分はOracle10gXEを利用しているのですが、
もしかしたらリテラルフォーマットの設定がOracle9iと
違うかもしれません。

> jdbc.bat
DB接続時のスキーマ名ですが、
大文字にされていますでしょうか？
ログに
> (TorqueJDBCTransformTask#doExecute():155) -   schema : artap
とあったので確認です。
Oracleの場合、schemaは大文字でなければなりません。
http://dbflute.sandbox.seasar.org/contents/dbvendor/oracle.html


2008/7/17 西山　はじめ <[E-MAIL ADDRESS DELETED]>:
> お世話になっております。西山と申します。
>
> Oracle9iに対し、replace-schema.batとjdbc.batがエラーとなります。
> 試したのは、dbflute-oracle-example（SVN最新）です。
>
> URL,SCHEMA,USER,PASSWORDは、他のDB接続ツール（DBViewer）で接
> 続確認できた設定そのままを使用しております。
>
> ・replace-schema.bat
> 初期データインポート時にエラーとなります。
>
> ・jdbc.bat
> Not Found Tablesと出てしまいます。
>
> 環境
> DBFlute:0.7.6
> Oracle:9i(9.2.0.1.0)
>
> それぞれ詳細の例外は以下のとおりです。
>
> 原因・回避手段等ありましたら教えてください。
>
> 以上よろしくお願いいたします。
>
> ////////////////////////////////////////////////////////////
> ・replace-schema.bat
>
> 2008-07-17 15:06:31,155 [main] INFO
> (DfXlsDataHandlerImpl#writeSeveralData():96) - /= = = = = =
> = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 2008-07-17 15:06:31,155 [main] INFO
> (DfXlsDataHandlerImpl#writeSeveralData():97) -
> writeData(.\playsql\data\ut\xls\20-member.xls)
> 2008-07-17 15:06:31,155 [main] INFO
> (DfXlsDataHandlerImpl#writeSeveralData():98) - = = = = = = =/
> 2008-07-17 15:06:31,311 [main] INFO
> (DfXlsDataHandlerImpl#writeSeveralData():146) - MEMBER:{1,
> Stoikovic, Pixy, FML, 2007/12/01 11:01:10, 1965/03/03,
> 2008-07-17 15:06:31.264, replace-schema, replace-schema,
> 2008-07-17 15:06:31.264, replace-schema, replace-schema, 1}
> （略）
> 2008-07-17 15:06:31,483 [main] WARN
> (DfXlsDataHandlerImpl#writeSeveralData():202) -
> 2008-07-17 15:06:31,483 [main] WARN
> (DfXlsDataHandlerImpl#writeSeveralData():203) - /* * * * * *
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> 2008-07-17 15:06:31,483 [main] WARN
> (DfXlsDataHandlerImpl#writeSeveralData():204) - SQLException
> was thrown! getNextException()=class java.sql.SQLException
> java.sql.SQLException: ORA-01861: リテラルがフォーマット文字
> 列と一致しません
>
>        at
> oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
>        at
> oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
>        at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
>        at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
>        at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
>        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
>        at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
>        at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
>        at
> oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9256)
>        at
> oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)
>        at
> org.seasar.dbflute.helper.datahandler.impl.DfXlsDataHandlerImpl.writeSeveralData(DfXlsDataHandlerImpl.java:198)
>        at
> org.seasar.dbflute.task.DfReplaceSchemaTask.writeDbFromXls(DfReplaceSchemaTask.java:397)
>        at
> org.seasar.dbflute.task.DfReplaceSchemaTask.writeDbFromXlsAsAdditionalData(DfReplaceSchemaTask.java:384)
>        at
> org.seasar.dbflute.task.DfReplaceSchemaTask.doExecute(DfReplaceSchemaTask.java:90)
>        at
> org.seasar.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:72)
>        at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
>        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
>        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>        at java.lang.reflect.Method.invoke(Method.java:597)
>        at
> org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
>        at org.apache.tools.ant.Task.perform(Task.java:348)
>        at org.apache.tools.ant.Target.execute(Target.java:357)
>        at org.apache.tools.ant.Target.performTasks(Target.java:385)
>        at
> org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
>        at
> org.apache.tools.ant.Project.executeTarget(Project.java:1298)
>        at
> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
>        at
> org.apache.tools.ant.Project.executeTargets(Project.java:1181)
>        at org.apache.tools.ant.Main.runBuild(Main.java:698)
>        at org.apache.tools.ant.Main.startAnt(Main.java:199)
>        at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
>        at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
>
> ////////////////////////////////////////////////////////////
> ・jdbc.bat
> 2008-07-17 16:05:53,256 [main] INFO
> (TorqueJDBCTransformTask#doExecute():151) - Your DB settings
> are:
> 2008-07-17 16:05:53,256 [main] INFO
> (TorqueJDBCTransformTask#doExecute():152) -   driver :
> oracle.jdbc.OracleDriver
> 2008-07-17 16:05:53,256 [main] INFO
> (TorqueJDBCTransformTask#doExecute():153) -   URL    :
> jdbc:oracle:thin:@vnet92:1521:artap
> 2008-07-17 16:05:53,256 [main] INFO
> (TorqueJDBCTransformTask#doExecute():154) -   user   : artap
> 2008-07-17 16:05:53,271 [main] INFO
> (TorqueJDBCTransformTask#doExecute():155) -   schema : artap
> 2008-07-17 16:05:53,303 [main] INFO
> (TorqueJDBCTransformTask#generateXML():193) - ...Instantiate
> DB-driver
> 2008-07-17 16:05:53,365 [main] INFO
> (TorqueJDBCTransformTask#generateXML():196) - ...Getting
> DB-connection
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():199) - ...Getting
> DB-meta-data
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():202) - $
> /**************************************************************************
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():203) - $
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():204) - $
> dbMetaData.toString():
> [E-MAIL ADDRESS DELETED]
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():205) - $
> dbMetaData.getMaxRowSize(): 0
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():206) - $
> 2008-07-17 16:05:53,646 [main] INFO
> (TorqueJDBCTransformTask#generateXML():207) - $
> /------------------------------------ ...Getting table list
> 2008-07-17 16:05:53,646 [main] INFO
> (DfTableHandler#logDatabaseTypes():142) - $ DatabaseTypes
> are 'TABLE - VIEW'
> 2008-07-17 16:05:53,849 [main] INFO
> (TorqueJDBCTransformTask#generateXML():211) - $
> 2008-07-17 16:05:53,849 [main] INFO
> (TorqueJDBCTransformTask#generateXML():212) - $ TableCount: 0
> 2008-07-17 16:05:53,849 [main] INFO
> (TorqueJDBCTransformTask#generateXML():213) - $
> ---------------------- /
> 2008-07-17 16:05:53,849 [main] INFO
> (TorqueJDBCTransformTask#generateXML():214) - $
> 2008-07-17 16:05:53,849 [main] INFO
> (TorqueJDBCTransformTask#generateXML():215) - $
> *************************************/
> 2008-07-17 16:05:53,849 [main] ERROR
> (TorqueJDBCTransformTask#doExecute():181) - JDBCToXMLSchema
> failed:
> java.lang.IllegalStateException: Not found tables:
> url=jdbc:oracle:thin:@vnet92:1521:artap schema=artap
>        at
> org.apache.torque.task.TorqueJDBCTransformTask.generateXML(TorqueJDBCTransformTask.java:219)
>        at
> org.apache.torque.task.TorqueJDBCTransformTask.doExecute(TorqueJDBCTransformTask.java:162)
>        at
> org.seasar.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:72)
>        at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
>        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
>        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>        at java.lang.reflect.Method.invoke(Method.java:597)
>        at
> org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
>        at org.apache.tools.ant.Task.perform(Task.java:348)
>        at org.apache.tools.ant.Target.execute(Target.java:357)
>        at org.apache.tools.ant.Target.performTasks(Target.java:385)
>        at
> org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
>        at
> org.apache.tools.ant.Project.executeTarget(Project.java:1298)
>        at
> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
>        at
> org.apache.tools.ant.Project.executeTargets(Project.java:1181)
>        at org.apache.tools.ant.Main.runBuild(Main.java:698)
>        at org.apache.tools.ant.Main.startAnt(Main.java:199)
>        at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
>        at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
>
>
> --
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> 株式会社フジミック　システム開発センター　ソフト開発2部
> 西山　創
> [E-mail]：[E-MAIL ADDRESS DELETED]
>
> 〒140-0002　品川区東品川3-32-42　フジテレビ別館７Ｆ
> [TEL]：03-5495-1060
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>