[Seasar-user:8269] [dbflute-0.5.0] sql2entity.bat 実行時に「QUERY が見つかりません」エラー
[E-MAIL ADDRESS DELETED]
[E-MAIL ADDRESS DELETED]
2007年 6月 13日 (水) 14:48:50 JST
いつもお世話になっております。
丸岡です。
dbflute-0.5.0で 外部SQLからEntityを生成しようとしたところ、以下のエラーが発生してしまい、
Entityが生成されずに困っています。
何か原因がわかる方、いらっしゃいますでしょうか？
よろしくお願い致します。
■SQLファイル
--#Test#
SELECT
id,
name
FROM
test
■ログ
2007-06-13 14:42:26,183 [main] DEBUG (DfAntTaskUtil#getBuildProperties():62) - Using contextProperties file: C:\dbflute-0.5.0\build.properties
2007-06-13 14:42:26,314 [main] DEBUG (DfAntTaskUtil#getBuildProperties():90) - [Properties]: size=46
2007-06-13 14:42:26,314 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.updateDateExceptTableList = list:{ prefix:LB_ }
2007-06-13 14:42:26,324 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isAvailableBehaviorRequiresNewTx = true
2007-06-13 14:42:26,324 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isAvailableToLowerInGeneratorUnderscoreMethod = true
2007-06-13 14:42:26,334 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.database.type.list = list:{TABLE;VIEW}
2007-06-13 14:42:26,344 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isMakeDeprecated = false
2007-06-13 14:42:26,354 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isAvailableBehaviorRequiredTx = true
2007-06-13 14:42:26,354 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.requiresNewTxComponentName = requiresNewTx
2007-06-13 14:42:26,364 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.extractAcceptEndBrace = @}
2007-06-13 14:42:26,374 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.javaNativeBinaryList = list:{}
2007-06-13 14:42:26,384 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.dbfluteDiconBeforeJ2eeIncludeDefinitionMap = map:{}
2007-06-13 14:42:26,404 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.java.dir = ./java
2007-06-13 14:42:26,414 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.commonColumnSetupBeforeUpdateInterceptorLogicMap = map:{ ; U_USER = dbflute.ldb.allcommon.LdAccessContext.getAccessUserOnThread() ; U_MODULE = dbflute.ldb.allcommon.LdAccessContext.getAccessModuleOnThread() }
2007-06-13 14:42:26,414 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.sequenceDefinitionMap = map:{ author = AUTHOR_AUTHOR_ID_INC ; BOOK = BOOK_BOOK_ID_INC ; LbUser = LB_USER_ID_INC }
2007-06-13 14:42:26,424 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.project = TST
2007-06-13 14:42:26,434 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.database = db2
2007-06-13 14:42:26,434 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isMakeBehaviorForUpdate = false
2007-06-13 14:42:26,444 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.javaNativeDateList = list:{}
2007-06-13 14:42:26,454 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.requiredTxComponentName = requiredTx
2007-06-13 14:42:26,464 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.originalBehaviorAspectMap = map:{}
2007-06-13 14:42:26,464 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isAvailableNonPrimaryKeyWritable = true
2007-06-13 14:42:26,474 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.statementResultSetConcurrency = ResultSet.CONCUR_READ_ONLY
2007-06-13 14:42:26,484 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.jdbcToJavaNativeMap = map:{}
2007-06-13 14:42:26,484 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.extractAcceptDelimiter = @;
2007-06-13 14:42:26,494 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.originalDBFluteComponentMap = map:{ ; *libraryDetailDao = map:{ className=dbflute.ldb.nongenerate.dao.LibraryDetailDao } ; blackListHandler = map:{ className=dbflute.ldb.nongenerate.handler.BlackListHandlerImpl } }
2007-06-13 14:42:26,504 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isMakeConditionQueryNumericArgumentLong = false
2007-06-13 14:42:26,514 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isAvailableDaoMethodLazyInitializing = true
2007-06-13 14:42:26,524 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.javaNativeStringList = list:{}
2007-06-13 14:42:26,534 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.dbfluteDiconOtherIncludeDefinitionMap = map:{}
2007-06-13 14:42:26,544 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.targetLanguage = java
2007-06-13 14:42:26,544 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.packageBase = test
2007-06-13 14:42:26,564 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.commonColumnSetupBeforeInsertInterceptorLogicMap = map:{ ; R_USER = dbflute.ldb.allcommon.LdAccessContext.getAccessUserOnThread() ; R_MODULE = dbflute.ldb.allcommon.LdAccessContext.getAccessModuleOnThread() ; R_TIMESTAMP = dbflute.ldb.allcommon.LdAccessContext.getAccessTimestampOnThread() ; U_USER = entity.getRUser() ; U_MODULE = entity.getRUser() }
2007-06-13 14:42:26,564 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.extractAcceptStartBrace = @{
2007-06-13 14:42:26,574 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.commonColumnMap = map:{ ; R_USER=VARCHAR; R_MODULE=VARCHAR; R_TIMESTAMP=TIMESTAMP ; U_USER=VARCHAR; U_MODULE=VARCHAR; U_TIMESTAMP=TIMESTAMP }
2007-06-13 14:42:26,584 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.statementResultSetType = ResultSet.TYPE_SCROLL_INSENSITIVE
2007-06-13 14:42:26,584 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.javaNativeBooleanList = list:{}
2007-06-13 14:42:26,594 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.multipleFKPropertyMap = map:{ ; NEXT_LIBRARY = map:{ ; LIBRARY_ID = map:{columnAliasName = baseId} ; NEXT_LIBRARY_ID = map:{columnAliasName = nextId} } }
2007-06-13 14:42:26,604 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.commonColumnSetupBeforeDeleteInterceptorLogicMap = map:{}
2007-06-13 14:42:26,634 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isAvailableOtherConnectionDaoInitialization = true
2007-06-13 14:42:26,664 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.extractAcceptEqual = @=
2007-06-13 14:42:26,674 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.updateDateFieldName = U_TIMESTAMP
2007-06-13 14:42:26,674 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.javaNativeNumberList = list:{}
2007-06-13 14:42:26,684 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.dbfluteDiconNamespace = dbflute
2007-06-13 14:42:26,694 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.isMakeConditionQueryEqualEmptyString = false
2007-06-13 14:42:26,694 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.s2daoVersion = 1.0.43
2007-06-13 14:42:26,714 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.commonColumnSetupInterceptorAspectPoint = behavior
2007-06-13 14:42:26,714 [main] DEBUG (DfAntTaskUtil#getBuildProperties():94) - torque.j2eeDiconResourceName = j2ee-ldb.dicon
2007-06-13 14:42:26,954 [main] INFO (DfSimpleDataSourceCreator#create():101) - ...create()
2007-06-13 14:42:27,265 [main] DEBUG (DfSqlFileFireMan#execute():23) - /************************************************************************************
2007-06-13 14:42:27,285 [main] DEBUG (DfSqlFileFireMan#execute():35) -
2007-06-13 14:42:27,295 [main] DEBUG (DfSqlFileFireMan#execute():36) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
2007-06-13 14:42:27,295 [main] DEBUG (DfSqlFileFireMan#execute():37) - sqlFile: .\java\test\exdao\test001Dao_findCarInfo2.sql
2007-06-13 14:42:27,305 [main] DEBUG (DfSqlFileFireMan#execute():38) - _/_/_/_/
2007-06-13 14:42:30,830 [main] DEBUG (DfSqlFileRunnerBase#newDelimterChanger():255) - The database has no delimiter changer: databaseName=db2 className=org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileRunnerBase$DelimiterChanger_db2 ignore=org.seasar.framework.exception.ClassNotFoundRuntimeException: [ESSR0044]java.lang.ClassNotFoundException: org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileRunnerBase$DelimiterChanger_db2
2007-06-13 14:42:31,291 [main] INFO (DfSql2EntityTask$1#traceSql():260) - {SQL}
--#Test#
SELECT id, name FROM test
2007-06-13 14:42:31,341 [main] WARN (DfSqlFileFireMan#execute():48) - org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileFireMan#execute() threw the exception!
org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileRunnerExecute$SQLRuntimeException: Failed to execute: --#Test#
SELECT id, name FROM test
at org.seasar.dbflute.task.DfSql2EntityTask$1.execSQL(DfSql2EntityTask.java:188)
at org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileRunnerBase.runTransaction(DfSqlFileRunnerBase.java:76)
at org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileFireMan.execute(DfSqlFileFireMan.java:41)
at org.seasar.dbflute.task.DfSql2EntityTask.doExecute(DfSql2EntityTask.java:83)
at org.seasar.dbflute.task.bs.DfAbstractTexenTask.execute(DfAbstractTexenTask.java:90)
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:585)
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)
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY が見つかりません。
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throwInvalidQueryError(Unknown Source)
at COM.ibm.db2.jdbc.net.DB2Statement.executeQuery(Unknown Source)
at org.seasar.dbflute.task.DfSql2EntityTask$1.execSQL(DfSql2EntityTask.java:156)
... 20 more
2007-06-13 14:42:31,431 [main] ERROR (DfAbstractTexenTask#execute():95) - execute() threw the exception!
org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileRunnerExecute$SQLRuntimeException: Failed to execute: --#Test#
SELECT id, name FROM test
at org.seasar.dbflute.task.DfSql2EntityTask$1.execSQL(DfSql2EntityTask.java:188)
at org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileRunnerBase.runTransaction(DfSqlFileRunnerBase.java:76)
at org.seasar.dbflute.helper.jdbc.sqlfile.DfSqlFileFireMan.execute(DfSqlFileFireMan.java:41)
at org.seasar.dbflute.task.DfSql2EntityTask.doExecute(DfSql2EntityTask.java:83)
at org.seasar.dbflute.task.bs.DfAbstractTexenTask.execute(DfAbstractTexenTask.java:90)
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:585)
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)
Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY が見つかりません。
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throwInvalidQueryError(Unknown Source)
at COM.ibm.db2.jdbc.net.DB2Statement.executeQuery(Unknown Source)
at org.seasar.dbflute.task.DfSql2EntityTask$1.execSQL(DfSql2EntityTask.java:156)
... 20 more
2007-06-13 14:42:31,521 [main] INFO (DfAbstractTexenTask#execute():99) - _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
2007-06-13 14:42:31,531 [main] INFO (DfAbstractTexenTask#execute():100) - [Task End: 00m04s797ms]
2007-06-13 14:42:31,531 [main] INFO (DfAbstractTexenTask#execute():101) - _/_/_/_/_/
Seasar-user メーリングリストの案内