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

2008年 7月 17日 (木) 16:14:03 JST

お世話になっております。西山と申します。

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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++