[Seasar-user:4850] Re: DBFlute-0.1.06 リリース
Masanobu Shimura
[E-MAIL ADDRESS DELETED]
2006年 10月 22日 (日) 10:41:54 JST
久保さま
志村です。
SQL SERVER ２００５に繋いでみたのですが、
下記 ERRORとなってしまいます。
どこか設定が間違っていますか？
急ぎませんので、よろしくお願いします。
−−−−−−−
jdbc:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from JDBC connection ! |
[echo] | |
[echo] +-----------------------------------------------+
[echo]
[echo] +-------------------------------------------------------------------------------+
[echo] contextProperties = build.properties
[echo] dbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
[echo] dbPassword = mike0516
[echo] dbSchema = dbo
[echo] dbUrl =
jdbc:sqlserver://localhost\SQLEXPRESS;database=MARIE
[echo] dbUser = sa
[echo] outputFile =
./schema/project-schema-ldb_minimumProperties.xml
[echo] sameJavaName = ${torque.sameJavaName}
[echo] +-----------------+
[torque-jdbc-transform] 2006-10-22 10:36:07,792 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():46) - Using contextProperties
file: F:\wk\dbflute-0.1.06\build.properties
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():71) - [Properties]: size=17
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.database.driver
= com.microsoft.sqlserver.jdbc.SQLServerDriver
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.database.password = xxxx
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.java.location.for.gen = /dbflute_ldb_gen/src/main/java
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.database.url =
jdbc:sqlserver://localhost\SQLEXPRESS;database=XXXX
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.packageBase =
com.s2click.example.ldb
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.java.dir = ../..
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.java.location.for.main = /dbflute_ldb/src/main/java
[torque-jdbc-transform] 2006-10-22 10:36:07,131 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.database.schema
= dbo
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.targetLanguage =
java
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.invokeReplaceSchemaDefinitionMap = map:{ isAutoCommit = false ;
isRollbackOnly = false ; isErrorContinue = true ; sqlFile =
./playsql/replace-schema.sql }
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.project =
ldb_minimumProperties
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.database.user =
xxxx
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) - torque.database = mssql
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.isAvailableBehaviorGeneration = true
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.statementResultSetConcurrency = ResultSet.CONCUR_READ_ONLY
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.statementResultSetType = ResultSet.TYPE_SCROLL_INSENSITIVE
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] DEBUG
(TorqueTaskUtil#getBuildProperties():75) -
torque.invokeSqlDirectoryDefinitionMap = map:{ isAutoCommit = false ;
isRollbackOnly = true ; isErrorContinue = false ; sqlDirectory =
./playsql }
[torque-jdbc-transform] 2006-10-22 10:36:07,146 [main] INFO
(TorqueJDBCTransformTask#execute():221) -
------------------------------------------------------- [Torque -
JDBCToXMLSchema] Start!
[torque-jdbc-transform] 2006-10-22 10:36:07,162 [main] INFO
(TorqueJDBCTransformTask#execute():222) - Your DB settings are:
[torque-jdbc-transform] 2006-10-22 10:36:07,162 [main] INFO
(TorqueJDBCTransformTask#execute():223) - driver :
com.microsoft.sqlserver.jdbc.SQLServerDriver
[torque-jdbc-transform] 2006-10-22 10:36:07,162 [main] INFO
(TorqueJDBCTransformTask#execute():224) - URL :
jdbc:sqlserver://localhost\SQLEXPRESS;database=XXXX
[torque-jdbc-transform] 2006-10-22 10:36:07,162 [main] INFO
(TorqueJDBCTransformTask#execute():225) - user : XX
[torque-jdbc-transform] 2006-10-22 10:36:07,162 [main] INFO
(TorqueJDBCTransformTask#execute():226) - schema : dbo
[torque-jdbc-transform] 2006-10-22 10:36:07,193 [main] INFO
(TorqueJDBCTransformTask#generateXML():264) - ...Instantiate DB-driver
[torque-jdbc-transform] 2006-10-22 10:36:07,225 [main] INFO
(TorqueJDBCTransformTask#generateXML():267) - ...Getting DB-connection
[torque-jdbc-transform] 2006-10-22 10:36:07,459 [main] INFO
(TorqueJDBCTransformTask#generateXML():270) - ...Getting DB-meta-data
[torque-jdbc-transform] 2006-10-22 10:36:07,475 [main] INFO
(TorqueJDBCTransformTask#generateXML():273) - $
/**************************************************************************
[torque-jdbc-transform] 2006-10-22 10:36:07,475 [main] INFO
(TorqueJDBCTransformTask#generateXML():274) - $
[torque-jdbc-transform] 2006-10-22 10:36:07,475 [main] INFO
(TorqueJDBCTransformTask#generateXML():275) - $ dbMetaData.toString():
[E-MAIL ADDRESS DELETED]
[torque-jdbc-transform] 2006-10-22 10:36:07,475 [main] INFO
(TorqueJDBCTransformTask#generateXML():276) - $
dbMetaData.getMaxRowSize(): 8060
[torque-jdbc-transform] 2006-10-22 10:36:07,475 [main] INFO
(TorqueJDBCTransformTask#generateXML():277) - $
[torque-jdbc-transform] 2006-10-22 10:36:07,475 [main] INFO
(TorqueJDBCTransformTask#generateXML():278) - $
/------------------------------------ ...Getting table list
[torque-jdbc-transform] 2006-10-22 10:36:07,490 [main] INFO
(TorqueJDBCTransformTask#logDatabaseTypes():680) - $ DatabaseTypes are
'TABLE - VIEW'
[torque-jdbc-transform] 2006-10-22 10:36:07,818 [main] DEBUG
(TorqueJDBCTransformTask#getTableNames():636) - $
isTableExcept(dtproperties) == true
[torque-jdbc-transform] 2006-10-22 10:36:07,818 [main] INFO
(TorqueJDBCTransformTask#generateXML():282) - $
[torque-jdbc-transform] 2006-10-22 10:36:07,818 [main] INFO
(TorqueJDBCTransformTask#generateXML():283) - $ TableCount: 19
[torque-jdbc-transform] 2006-10-22 10:36:07,818 [main] INFO
(TorqueJDBCTransformTask#generateXML():284) - $ ----------------------
/
[torque-jdbc-transform] 2006-10-22 10:36:07,818 [main] INFO
(TorqueJDBCTransformTask#generateXML():285) - $
[torque-jdbc-transform] 2006-10-22 10:36:07,818 [main] INFO
(TorqueJDBCTransformTask#generateXML():286) - $
*************************************/
[torque-jdbc-transform] 2006-10-22 10:36:08,193 [main] INFO
(TorqueJDBCTransformTask#generateXML():297) - ...Processing table:
HR_DETAIL
[torque-jdbc-transform] 2006-10-22 10:36:08,803 [main] ERROR
(TorqueJDBCTransformTask#execute():252) - JDBCToXMLSchema failed:
[torque-jdbc-transform] java.lang.NumberFormatException: null
[torque-jdbc-transform] at java.lang.Integer.parseInt(Integer.java:415)
[torque-jdbc-transform] at java.lang.Integer.parseInt(Integer.java:497)
[torque-jdbc-transform] at
org.apache.torque.task.TorqueJDBCTransformTask.getUniqueColumnNameList(TorqueJDBCTransformTask.java:492)
[torque-jdbc-transform] at
org.apache.torque.task.TorqueJDBCTransformTask.generateXML(TorqueJDBCTransformTask.java:393)
[torque-jdbc-transform] at
org.apache.torque.task.TorqueJDBCTransformTask.execute(TorqueJDBCTransformTask.java:233)
[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)
Seasar-user メーリングリストの案内