[Seasar-user:7314] Re: [DBFlute]VIEW 生成について
[E-MAIL ADDRESS DELETED]
[E-MAIL ADDRESS DELETED]
2007年 4月 17日 (火) 11:48:56 JST
いつもお世話になっております。
米原です。
>取り急ぎ、例外のスタックトレースを頂けませんでしょうか？
>OracleでVIEWで自動生成した実績はあるので、
>ちょっと調べます。
以下スタックトレースです。
すみませんが、ご確認よろしくお願い致します。
「Processing table：」にてVIEWが指定されたときにエラーが発生しています。
その前（TABLEまで）は、うまくいっていたようです。
これより上のログも必要であれば、再度提示させて頂きます。
・・・・・・・
・（省略）・・
・・・・・・・
[torque-jdbc-transform] 2007-04-17 09:50:58,501 [main] INFO (TorqueJDBCTransformTask#generateXML():218) - $ /************************************************************
**************
[torque-jdbc-transform] 2007-04-17 09:50:58,511 [main] INFO (TorqueJDBCTransformTask#generateXML():219) - $
[torque-jdbc-transform] 2007-04-17 09:50:58,511 [main] INFO (TorqueJDBCTransformTask#generateXML():220) - $ dbMetaData.toString(): oracle.jdbc.driver.OracleDatabaseMetaD
[E-MAIL ADDRESS DELETED]
[torque-jdbc-transform] 2007-04-17 09:50:58,511 [main] INFO (TorqueJDBCTransformTask#generateXML():221) - $ dbMetaData.getMaxRowSize(): 2000
[torque-jdbc-transform] 2007-04-17 09:50:58,521 [main] INFO (TorqueJDBCTransformTask#generateXML():222) - $
[torque-jdbc-transform] 2007-04-17 09:50:58,521 [main] INFO (TorqueJDBCTransformTask#generateXML():223) - $ /------------------------------------ ...Getting table list
[torque-jdbc-transform] 2007-04-17 09:50:58,531 [main] INFO (DfTableNameHandler#logDatabaseTypes():113) - $ DatabaseTypes are 'TABLE - VIEW'
[torque-jdbc-transform] 2007-04-17 09:50:59,753 [main] INFO (TorqueJDBCTransformTask#generateXML():227) - $
[torque-jdbc-transform] 2007-04-17 09:50:59,753 [main] INFO (TorqueJDBCTransformTask#generateXML():228) - $ TableCount: 161
[torque-jdbc-transform] 2007-04-17 09:50:59,763 [main] INFO (TorqueJDBCTransformTask#generateXML():229) - $ ---------------------- /
[torque-jdbc-transform] 2007-04-17 09:50:59,763 [main] INFO (TorqueJDBCTransformTask#generateXML():230) - $
[torque-jdbc-transform] 2007-04-17 09:50:58,501 [main] INFO (TorqueJDBCTransformTask#generateXML():218) - $ /************************************************************
**************
[torque-jdbc-transform] 2007-04-17 09:51:02,927 [main] INFO (TorqueJDBCTransformTask#generateXML():242) - ...Processing table: AXXXXXX
・・・・・・・
・（省略）・・
・・・・・・・
[torque-jdbc-transform] 2007-04-17 09:52:31,254 [main] INFO (TorqueJDBCTransformTask#generateXML():242) - ...Processing table: V_AXXXXXX
[torque-jdbc-transform] 2007-04-17 09:52:31,434 [main] ERROR (TorqueJDBCTransformTask#doExecute():197) - JDBCToXMLSchema failed:
[torque-jdbc-transform] java.sql.SQLException: ORA-01702: ここではビューは指定できません。
[torque-jdbc-transform] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[torque-jdbc-transform] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
[torque-jdbc-transform] at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3485)
[torque-jdbc-transform] at org.seasar.dbflute.helper.jdbc.metadata.DfUniqueKeyHandler.getUniqueColumnNameList(DfUniqueKeyHandler.java:103)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.getUniqueColumnNameList(TorqueJDBCTransformTask.java:409)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.generateXML(TorqueJDBCTransformTask.java:338)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.doExecute(TorqueJDBCTransformTask.java:178)
[torque-jdbc-transform] at org.seasar.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:69)
[torque-jdbc-transform] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[torque-jdbc-transform] at org.apache.tools.ant.Task.perform(Task.java:364)
[torque-jdbc-transform] at org.apache.tools.ant.Target.execute(Target.java:341)
[torque-jdbc-transform] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[torque-jdbc-transform] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[torque-jdbc-transform] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[torque-jdbc-transform] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[torque-jdbc-transform] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[torque-jdbc-transform] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[torque-jdbc-transform] 2007-04-17 09:52:31,535 [main] ERROR (DfAbstractTask#execute():74) - execute() threw the exception!
[torque-jdbc-transform] java.sql.SQLException: ORA-01702: ここではビューは指定できません。
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.doExecute(TorqueJDBCTransformTask.java:198)
[torque-jdbc-transform] at org.seasar.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:69)
[torque-jdbc-transform] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[torque-jdbc-transform] at org.apache.tools.ant.Task.perform(Task.java:364)
[torque-jdbc-transform] at org.apache.tools.ant.Target.execute(Target.java:341)
[torque-jdbc-transform] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[torque-jdbc-transform] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[torque-jdbc-transform] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[torque-jdbc-transform] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[torque-jdbc-transform] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[torque-jdbc-transform] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[torque-jdbc-transform] Caused by: java.sql.SQLException: ORA-01702: ここではビューは指定できません。
[torque-jdbc-transform] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[torque-jdbc-transform] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
[torque-jdbc-transform] at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3485)
[torque-jdbc-transform] at org.seasar.dbflute.helper.jdbc.metadata.DfUniqueKeyHandler.getUniqueColumnNameList(DfUniqueKeyHandler.java:103)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.getUniqueColumnNameList(TorqueJDBCTransformTask.java:409)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.generateXML(TorqueJDBCTransformTask.java:338)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.doExecute(TorqueJDBCTransformTask.java:178)
[torque-jdbc-transform] ... 13 more
[torque-jdbc-transform] --- Nested Exception ---
[torque-jdbc-transform] java.sql.SQLException: ORA-01702: ここではビューは指定できません。
[torque-jdbc-transform] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[torque-jdbc-transform] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[torque-jdbc-transform] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
[torque-jdbc-transform] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
[torque-jdbc-transform] at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3485)
[torque-jdbc-transform] at org.seasar.dbflute.helper.jdbc.metadata.DfUniqueKeyHandler.getUniqueColumnNameList(DfUniqueKeyHandler.java:103)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.getUniqueColumnNameList(TorqueJDBCTransformTask.java:409)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.generateXML(TorqueJDBCTransformTask.java:338)
[torque-jdbc-transform] at org.apache.torque.task.TorqueJDBCTransformTask.doExecute(TorqueJDBCTransformTask.java:178)
[torque-jdbc-transform] at org.seasar.dbflute.task.bs.DfAbstractTask.execute(DfAbstractTask.java:69)
[torque-jdbc-transform] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[torque-jdbc-transform] at org.apache.tools.ant.Task.perform(Task.java:364)
[torque-jdbc-transform] at org.apache.tools.ant.Target.execute(Target.java:341)
[torque-jdbc-transform] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[torque-jdbc-transform] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[torque-jdbc-transform] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[torque-jdbc-transform] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[torque-jdbc-transform] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[torque-jdbc-transform] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
[torque-jdbc-transform] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
[torque-jdbc-transform] 2007-04-17 09:52:31,915 [main] INFO (DfAbstractTask#execute():78) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
[torque-jdbc-transform] 2007-04-17 09:52:31,925 [main] INFO (DfAbstractTask#execute():79) - [Task End: 01m35s307ms]
[torque-jdbc-transform] 2007-04-17 09:52:31,935 [main] INFO (DfAbstractTask#execute():80) - _/_/_/_/_/
BUILD FAILED
D:\ec\dbflute-0.4.5\build-torque.xml:324: java.sql.SQLException: ORA-01702: ここではビューは指定できません。
Seasar-user メーリングリストの案内