DBFlute二度目のチャレンジ(1)
先日のエントリーのコメント欄に書いた通り、以前DBFluteの導入に挫折しています。
が、とにかく便利そうであるのは確かで、とっても魅力的です。また、当時と違って、ブログ等を通してサポートを頂ける環境も実感できて来ましたので、ここで再チャレンジといこうと思います。
まずはsetup!
オフィシャルサイトのドキュメントHow to Setupを参考に、まずはsetupを。
前提条件は以下の通り。
- プロジェクト名は "cepoc"
- ルートパッケージは "jp.xet.cepoc"
- 使用するデータベースは PostgreSQL
SunのPageよりJRE-5.0(以上)をDownloadし、Installして下さい。{必須}
Ant-1.5(以上)を以下のSiteよりDownloadし、Installして下さい。{必須}
環境変数として{ANT_HOME}を追加します。
環境変数{Path}に%ANT_HOME%\binを追加します。
ここまでは済んでおりましたので、スルー。
DBFlute本体は、d:\develop\dbflute-0.4.3 に展開したので、それをセット。
%DBFLUTE_HOME%/etc/client_directory-templateのDirectoryに、実行Directory(Client-Directory)のTemplateがあります。任意のTemplateをCopyし、LocalPCの任意の場所に配置して下さい。
eclipseのプロジェクト(Doltengで作成したプロジェクト)のルートにdbfluteフォルダを作成し、%DBFLUTE_HOME%/etc/client_directory-template/minimumPropertiesの内容をごっそりコピー。
_project.batの「MY_PROJECT_NAME」変数の値を任意のProject名に変更して下さい。
build-ldb.propertiesのFile名をbuild-[xxx].properties(xxxは任意のProject名)に変更して下さい。
Project名は "cepoc" で。build-cepoc.properties ですね。
各Propertyの詳細は%DBFLUTE_HOME%/etc/client_directory-template/fullPropertiesのbuild-ldb.properties内に記述されている各PropertyのCommentを参考にして下さい。
続いてbuild-cepoc.propertiesの内容を設定していきます。変更したもののみ、以下に示します。(よくわからないものはスルーしましたw)
torque.database = postgresql torque.packageBase = jp.xet.cepoc torque.database.driver = org.postgresql.Driver torque.database.url = jdbc:postgresql://localhost/cepoc torque.database.schema = public torque.database.user = cepoc torque.database.password = ****
j2ee.diconの設定にて、Component定義を以下のように差し替えてください。
component class="org.seasar.extension.jdbc.impl.BasicStatementFactory"
component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"
↓↓↓
component class="xxx.allcommon.s2dao.S2DaoStatementFactory"
component class="xxx.allcommon.s2dao.FetchNarrowingResultSetFactory"
んと…、jdbc.diconでいいんですよね。jp.xet.cepoc.allcommon.s2dao.〜 に書き換えました。抜粋で以下の通り。
<component class="jp.xet.cepoc.allcommon.s2dao.FetchNarrowingResultSetFactory"/> <component class="org.seasar.extension.jdbc.impl.ConfigurableStatementFactory"> <arg> <component class="jp.xet.cepoc.allcommon.s2dao.S2DaoStatementFactory"/> </arg> <property name="fetchSize">100</property> <!-- <property name="maxRows">100</property> --> </component>
リバースエンジニアリング!
jdbc.batを実行します。
ドキドキの瞬間!
1 個のファイルをコピーしました。 Buildfile: D:\develop\dbflute-0.4.3\build-torque.xml jdbc: [echo] +-----------------------------------------------+ [echo] | | [echo] | Generating XML from JDBC connection ! | [echo] | | [echo] +-----------------------------------------------+ [echo] [echo] +-------------------------------------------------------------------------------+ [echo] contextProperties = build.properties [echo] dbDriver = org.postgresql.Driver [echo] dbPassword = **** [echo] dbSchema = public [echo] dbUrl = jdbc:postgresql://localhost/cepoc [echo] dbUser = cepoc [echo] outputFile = ./schema/project-schema-cepoc.xml [echo] sameJavaName = ${torque.sameJavaName} [echo] +-----------------+ [torque-jdbc-transform] 2007-03-24 01:43:50,664 [main] DEBUG (DfAntTaskUtil#getBuildProperties():62) - Using contextProperties file: D:\develop\dbflute-0.4.3\build.properties [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():87) - [Properties]: size=19 [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.statementResultSetConcurrency = ResultSet.CONCUR_READ_ONLY [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.driver = org.postgresql.Driver [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.project = cepoc [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeConditionQueryNumericArgumentLong = false [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.schema = public [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeDeprecated = false [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.packageBase = jp.xet.cepoc [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.statementResultSetType = ResultSet.TYPE_SCROLL_INSENSITIVE [torque-jdbc-transform] 2007-03-24 01:43:50,680 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.user = cepoc [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.invokeSqlDirectoryDefinitionMap = map:{ isAutoCommit = false ; isRollbackOnly = true ; isErrorContinue = false ; sqlDirectory = ./playsql } [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.url = jdbc:postgresql://localhost/cepoc [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.password = **** [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.targetLanguage = java [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeConditionQueryEqualEmptyString = false [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeBehaviorForUpdate = false [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isAvailableBehaviorGeneration = true [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.invokeReplaceSchemaDefinitionMap = map:{ isAutoCommit = false ; isRollbackOnly = false ; isErrorContinue = true ; sqlFile = ./playsql/replace-schema.sql } [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.java.dir = ../src/main/java [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database = postgresql [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] INFO (TorqueJDBCTransformTask#doExecute():205) - ------------------------------------------------------- [Torque - JDBCToXMLSchema] Start! [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] INFO (TorqueJDBCTransformTask#doExecute():206) - Your DB settings are: [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] INFO (TorqueJDBCTransformTask#doExecute():207) - driver : org.postgresql.Driver [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] INFO (TorqueJDBCTransformTask#doExecute():208) - URL : jdbc:postgresql://localhost/cepoc [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] INFO (TorqueJDBCTransformTask#doExecute():209) - user : cepoc [torque-jdbc-transform] 2007-03-24 01:43:50,695 [main] INFO (TorqueJDBCTransformTask#doExecute():210) - schema : public [torque-jdbc-transform] 2007-03-24 01:43:50,726 [main] INFO (TorqueJDBCTransformTask#generateXML():248) - ...Instantiate DB-driver [torque-jdbc-transform] 2007-03-24 01:43:50,726 [main] INFO (TorqueJDBCTransformTask#generateXML():251) - ...Getting DB-connection [torque-jdbc-transform] 2007-03-24 01:43:50,851 [main] INFO (TorqueJDBCTransformTask#generateXML():254) - ...Getting DB-meta-data [torque-jdbc-transform] 2007-03-24 01:43:50,867 [main] INFO (TorqueJDBCTransformTask#generateXML():257) - $ /************************************************************************** [torque-jdbc-transform] 2007-03-24 01:43:50,867 [main] INFO (TorqueJDBCTransformTask#generateXML():258) - $ [torque-jdbc-transform] 2007-03-24 01:43:50,867 [main] INFO (TorqueJDBCTransformTask#generateXML():259) - $ dbMetaData.toString(): org.postgresql.jdbc3.Jdbc3DatabaseMetaData@12a0f6c [torque-jdbc-transform] 2007-03-24 01:43:50,867 [main] INFO (TorqueJDBCTransformTask#generateXML():260) - $ dbMetaData.getMaxRowSize(): 1073741824 [torque-jdbc-transform] 2007-03-24 01:43:50,867 [main] INFO (TorqueJDBCTransformTask#generateXML():261) - $ [torque-jdbc-transform] 2007-03-24 01:43:50,867 [main] INFO (TorqueJDBCTransformTask#generateXML():262) - $ /------------------------------------ ...Getting table list [torque-jdbc-transform] 2007-03-24 01:43:50,883 [main] INFO (DfTableNameHandler#logDatabaseTypes():113) - $ DatabaseTypes are 'TABLE - VIEW' [torque-jdbc-transform] 2007-03-24 01:43:50,930 [main] INFO (TorqueJDBCTransformTask#generateXML():266) - $ [torque-jdbc-transform] 2007-03-24 01:43:50,930 [main] INFO (TorqueJDBCTransformTask#generateXML():267) - $ TableCount: 28 [torque-jdbc-transform] 2007-03-24 01:43:50,930 [main] INFO (TorqueJDBCTransformTask#generateXML():268) - $ ---------------------- / [torque-jdbc-transform] 2007-03-24 01:43:50,930 [main] INFO (TorqueJDBCTransformTask#generateXML():269) - $ [torque-jdbc-transform] 2007-03-24 01:43:50,930 [main] INFO (TorqueJDBCTransformTask#generateXML():270) - $ *************************************/ [torque-jdbc-transform] 2007-03-24 01:43:51,086 [main] INFO (TorqueJDBCTransformTask#generateXML():281) - ...Processing table: テーブル名1 [torque-jdbc-transform] 2007-03-24 01:43:51,164 [main] INFO (TorqueJDBCTransformTask#generateXML():281) - ...Processing table: テーブル名2 (中略) [torque-jdbc-transform] 2007-03-24 01:43:52,461 [main] INFO (TorqueJDBCTransformTask#generateXML():281) - ...Processing table: テーブル名27 [torque-jdbc-transform] 2007-03-24 01:43:52,508 [main] INFO (TorqueJDBCTransformTask#generateXML():281) - ...Processing table: テーブル名28 [torque-jdbc-transform] 2007-03-24 01:43:52,555 [main] INFO (TorqueJDBCTransformTask#doExecute():219) - $ [torque-jdbc-transform] 2007-03-24 01:43:52,555 [main] INFO (TorqueJDBCTransformTask#doExecute():220) - $ [torque-jdbc-transform] 2007-03-24 01:43:52,555 [main] INFO (TorqueJDBCTransformTask#doExecute():221) - $ /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * [torque-jdbc-transform] 2007-03-24 01:43:52,570 [main] INFO (TorqueJDBCTransformTask#doExecute():222) - $ ...Serializing XML: ./schema/project-schema-cepoc.xml [torque-jdbc-transform] 2007-03-24 01:43:52,617 [main] INFO (TorqueJDBCTransformTask#doExecute():232) - $ * * * * * * * * */ [torque-jdbc-transform] 2007-03-24 01:43:52,617 [main] INFO (TorqueJDBCTransformTask#doExecute():233) - $ [torque-jdbc-transform] 2007-03-24 01:43:52,617 [main] INFO (TorqueJDBCTransformTask#doExecute():239) - ------------------------------------------------------- [Torque - JDBCToXMLSchema] Finish! BUILD SUCCESSFUL Total time: 4 seconds 1 個のファイルをコピーしました。 続行するには何かキーを押してください . . .
./schema以下にproject-schema-xxx.xmlが作成されていたら成功です。
まぁ、ファイルがproject-schema-cepoc.xmlが出来ているので成功ですかね。中をのぞいてみて、それっぽいのが書かれています。ああ、のっけから28テーブルのデータベースをネタにしてしまった…。もっと簡単なのから試せよな〜、自分。しかも、データベースは設計し直す気満々なのに(笑)
ソース生成!
generate.batを実行します。
押忍。
1 個のファイルをコピーしました。 Buildfile: D:\develop\dbflute-0.4.3\build-torque.xml check-use-classpath: check-run-only-on-schema-change: om-check: om: [echo] +------------------------------------------+ [echo] | | [echo] | Generating Peer-based Object Model for | [echo] | YOUR Torque project! | [echo] | | [echo] +------------------------------------------+ om-classpath: om-template: [torque-data-model] Using contextProperties file: D:\develop\dbflute-0.4.3\build.properties [torque-data-model] 2007-03-24 01:51:36,273 [main] DEBUG (DfAntTaskUtil#getBuildProperties():62) - Using contextProperties file: D:\develop\dbflute-0.4.3\build.properties [torque-data-model] 2007-03-24 01:51:36,289 [main] DEBUG (DfAntTaskUtil#getBuildProperties():87) - [Properties]: size=19 [torque-data-model] 2007-03-24 01:51:36,289 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.statementResultSetConcurrency = ResultSet.CONCUR_READ_ONLY [torque-data-model] 2007-03-24 01:51:36,305 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.driver = org.postgresql.Driver [torque-data-model] 2007-03-24 01:51:36,305 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.project = cepoc [torque-data-model] 2007-03-24 01:51:36,305 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeConditionQueryNumericArgumentLong = false [torque-data-model] 2007-03-24 01:51:36,305 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.schema = public [torque-data-model] 2007-03-24 01:51:36,305 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeDeprecated = false [torque-data-model] 2007-03-24 01:51:36,320 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.packageBase = jp.xet.cepoc [torque-data-model] 2007-03-24 01:51:36,320 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.statementResultSetType = ResultSet.TYPE_SCROLL_INSENSITIVE [torque-data-model] 2007-03-24 01:51:36,320 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.user = cepoc [torque-data-model] 2007-03-24 01:51:36,320 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.invokeSqlDirectoryDefinitionMap = map:{ isAutoCommit = false ; isRollbackOnly = true ; isErrorContinue = false ; sqlDirectory = ./playsql } [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.url = jdbc:postgresql://localhost/cepoc [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database.password = **** [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.targetLanguage = java [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeConditionQueryEqualEmptyString = false [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isMakeBehaviorForUpdate = false [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.isAvailableBehaviorGeneration = true [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.invokeReplaceSchemaDefinitionMap = map:{ isAutoCommit = false ; isRollbackOnly = false ; isErrorContinue = true ; sqlFile = ./playsql/replace-schema.sql } [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.java.dir = ../src/main/java [torque-data-model] 2007-03-24 01:51:36,351 [main] DEBUG (DfAntTaskUtil#getBuildProperties():91) - torque.database = postgresql [torque-data-model] Generating to file D:\develop\src\main\java\report.cepoc.om.generation [torque-data-model] 2007-03-24 01:51:36,726 [main] INFO (DTDResolver#resolveEntity():117) - Resolver: used database.dtd from 'org.apache.torque.engine.database.transform' package [torque-data-model] 2007-03-24 01:51:37,273 [main] DEBUG (Database#initializeCustomizeDao():544) - /============================= [torque-data-model] 2007-03-24 01:51:37,273 [main] DEBUG (Database#initializeCustomizeDao():545) - ...Initializing customize dao. [torque-data-model] 2007-03-24 01:51:37,273 [main] DEBUG (Database#initializeCustomizeDao():575) - ========/ [torque-data-model] 2007-03-24 01:51:37,289 [main] DEBUG (DfAdditionalForeignKeyInitializer#initializeAdditionalForeignKey():56) - /====================================== [torque-data-model] 2007-03-24 01:51:37,289 [main] DEBUG (DfAdditionalForeignKeyInitializer#initializeAdditionalForeignKey():57) - ...Initializing additional foreign key. [torque-data-model] 2007-03-24 01:51:37,523 [main] DEBUG (DfAdditionalForeignKeyInitializer#initializeAdditionalForeignKey():128) - ========/ [torque-data-model] 2007-03-24 01:51:37,523 [main] DEBUG (Database#initializeIncludeQuery():599) - /============================= [torque-data-model] 2007-03-24 01:51:37,539 [main] DEBUG (Database#initializeIncludeQuery():600) - ...Initializing customize dao. [torque-data-model] 2007-03-24 01:51:37,539 [main] DEBUG (Database#initializeIncludeQuery():632) - ========/ [torque-data-model] 2007-03-24 01:51:37,555 [main] DEBUG (Database#debug():1450) - public void parseAnnotation) { [torque-data-model] 2007-03-24 01:51:37,555 [main] DEBUG (Database#debug():1450) - parseOutsideSql(); [torque-data-model] 2007-03-24 01:51:37,555 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:37,555 [main] DEBUG (Database#debug():1450) - [behavior-interface & abstract] [torque-data-model] 2007-03-24 01:51:37,555 [main] DEBUG (Database#debug():1450) - ...Parsing BehaviorReadable [torque-data-model] 2007-03-24 01:51:37,570 [main] DEBUG (Database#debug():1450) - ...Parsing BehaviorWritable [torque-data-model] 2007-03-24 01:51:37,586 [main] DEBUG (Database#debug():1450) - ...Parsing AbstractBehaviorReadable [torque-data-model] 2007-03-24 01:51:37,601 [main] DEBUG (Database#debug():1450) - ...Parsing AbstractBehaviorWritable [torque-data-model] 2007-03-24 01:51:37,601 [main] DEBUG (Database#debug():1450) - ...Parsing dao-interface [torque-data-model] 2007-03-24 01:51:37,617 [main] DEBUG (Database#debug():1450) - public void parseEntityInterface() { [torque-data-model] 2007-03-24 01:51:37,617 [main] DEBUG (Database#debug():1450) - parseEntity(); [torque-data-model] 2007-03-24 01:51:37,617 [main] DEBUG (Database#debug():1450) - parseEntityDefinedCommonColumn(); [torque-data-model] 2007-03-24 01:51:37,633 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:37,633 [main] DEBUG (Database#debug():1450) - public void parseConditionBeanFramework() { [torque-data-model] 2007-03-24 01:51:37,633 [main] DEBUG (Database#debug():1450) - ...Parsing FetchNarrowingBeanContext [torque-data-model] 2007-03-24 01:51:37,664 [main] DEBUG (Database#debug():1450) - ...Parsing FetchNarrowingBean [torque-data-model] 2007-03-24 01:51:37,664 [main] DEBUG (Database#debug():1450) - ...Parsing SimpleOrderByBean [torque-data-model] 2007-03-24 01:51:37,664 [main] DEBUG (Database#debug():1450) - ...Parsing SimplePagingBean [torque-data-model] 2007-03-24 01:51:38,101 [main] DEBUG (Database#debug():1450) - ...Parsing PagingResultBean [torque-data-model] 2007-03-24 01:51:38,101 [main] DEBUG (Database#debug():1450) - ...Parsing ListResultBean [torque-data-model] 2007-03-24 01:51:38,117 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionBeanContext [torque-data-model] 2007-03-24 01:51:38,117 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionBean [torque-data-model] 2007-03-24 01:51:38,164 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionQuery [torque-data-model] 2007-03-24 01:51:38,164 [main] DEBUG (Database#debug():1450) - ...Parsing PagingBean [torque-data-model] 2007-03-24 01:51:38,164 [main] DEBUG (Database#debug():1450) - ...Parsing OrderByBean [torque-data-model] 2007-03-24 01:51:38,164 [main] DEBUG (Database#debug():1450) - ...Parsing SelectResource [torque-data-model] 2007-03-24 01:51:38,164 [main] DEBUG (Database#debug():1450) - ...Parsing AbstractConditionBean [torque-data-model] 2007-03-24 01:51:38,180 [main] DEBUG (Database#debug():1450) - ...Parsing AbstractConditionQuery [torque-data-model] 2007-03-24 01:51:38,180 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey [torque-data-model] 2007-03-24 01:51:38,195 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_equal [torque-data-model] 2007-03-24 01:51:38,195 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_notEqual [torque-data-model] 2007-03-24 01:51:38,195 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_greaterThan [torque-data-model] 2007-03-24 01:51:38,211 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_lessThan [torque-data-model] 2007-03-24 01:51:38,211 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_greaterEqual [torque-data-model] 2007-03-24 01:51:38,211 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_lessEqual [torque-data-model] 2007-03-24 01:51:38,211 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_prefixSearch [torque-data-model] 2007-03-24 01:51:38,226 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_likeSearch [torque-data-model] 2007-03-24 01:51:38,226 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_inScope [torque-data-model] 2007-03-24 01:51:38,226 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_notInScope [torque-data-model] 2007-03-24 01:51:38,242 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_isNull [torque-data-model] 2007-03-24 01:51:38,242 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionKey_isNotNull [torque-data-model] 2007-03-24 01:51:38,242 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionOption [torque-data-model] 2007-03-24 01:51:38,258 [main] DEBUG (Database#debug():1450) - ...Parsing SimpleStringOption [torque-data-model] 2007-03-24 01:51:38,258 [main] DEBUG (Database#debug():1450) - ...Parsing LikeSearchOption [torque-data-model] 2007-03-24 01:51:38,258 [main] DEBUG (Database#debug():1450) - ...Parsing InScopeOption [torque-data-model] 2007-03-24 01:51:38,273 [main] DEBUG (Database#debug():1450) - ...Parsing SplitOptionParts [torque-data-model] 2007-03-24 01:51:38,273 [main] DEBUG (Database#debug():1450) - ...Parsing ToUpperLowerCaseOptionParts [torque-data-model] 2007-03-24 01:51:38,273 [main] DEBUG (Database#debug():1450) - ...Parsing ToSingleByteOptionParts [torque-data-model] 2007-03-24 01:51:38,273 [main] DEBUG (Database#debug():1450) - ...Parsing JapaneseOptionPartsAgent [torque-data-model] 2007-03-24 01:51:38,273 [main] DEBUG (Database#debug():1450) - ...Parsing ConditionValue [torque-data-model] 2007-03-24 01:51:38,320 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause [torque-data-model] 2007-03-24 01:51:38,320 [main] DEBUG (Database#debug():1450) - ...Parsing AbstractSqlClause [torque-data-model] 2007-03-24 01:51:38,336 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_derby [torque-data-model] 2007-03-24 01:51:38,336 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_oracle [torque-data-model] 2007-03-24 01:51:38,336 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_firebird [torque-data-model] 2007-03-24 01:51:38,351 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_mysql [torque-data-model] 2007-03-24 01:51:38,351 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_postgresql [torque-data-model] 2007-03-24 01:51:38,351 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_mssql [torque-data-model] 2007-03-24 01:51:38,351 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_db2 [torque-data-model] 2007-03-24 01:51:38,367 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_interbase [torque-data-model] 2007-03-24 01:51:38,367 [main] DEBUG (Database#debug():1450) - ...Parsing SqlClause_default [torque-data-model] 2007-03-24 01:51:38,367 [main] DEBUG (Database#debug():1450) - ...Parsing OrderByClause [torque-data-model] 2007-03-24 01:51:38,367 [main] DEBUG (Database#debug():1450) - ...Parsing OrderByElement [torque-data-model] 2007-03-24 01:51:38,367 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:38,383 [main] DEBUG (Database#debug():1450) - public void parseDBMetaClass() { [torque-data-model] 2007-03-24 01:51:38,383 [main] DEBUG (Database#debug():1450) - parseDBMeta(); [torque-data-model] 2007-03-24 01:51:38,383 [main] DEBUG (Database#debug():1450) - parseAbstractDBMeta(); [torque-data-model] 2007-03-24 01:51:38,383 [main] DEBUG (Database#debug():1450) - parseDBMetaInstanceHandler(); [torque-data-model] 2007-03-24 01:51:38,398 [main] DEBUG (Database#debug():1450) - public void parseExceptionClass() { [torque-data-model] 2007-03-24 01:51:38,398 [main] DEBUG (Database#debug():1450) - parseRecordHasAlreadyBeenDeletedException(); [torque-data-model] 2007-03-24 01:51:38,398 [main] DEBUG (Database#debug():1450) - parseRecordHasOverlappedException(); [torque-data-model] 2007-03-24 01:51:38,398 [main] DEBUG (Database#debug():1450) - parseSelectedCountExceedMaxCountException(); [torque-data-model] 2007-03-24 01:51:38,414 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:38,414 [main] DEBUG (Database#debug():1450) - public void parseHelperClass() { [torque-data-model] 2007-03-24 01:51:38,414 [main] DEBUG (Database#debug():1450) - parseMapListString(); [torque-data-model] 2007-03-24 01:51:38,414 [main] DEBUG (Database#debug():1450) - parseMapListStringImpl(); [torque-data-model] 2007-03-24 01:51:38,414 [main] DEBUG (Database#debug():1450) - parseMapStringBuilder(); [torque-data-model] 2007-03-24 01:51:38,430 [main] DEBUG (Database#debug():1450) - parseMapStringBuilderImpl(); [torque-data-model] 2007-03-24 01:51:38,445 [main] DEBUG (Database#debug():1450) - parseGeneralCharacter(); [torque-data-model] 2007-03-24 01:51:38,445 [main] DEBUG (Database#debug():1450) - parseGeneralCharacterImpl(); [torque-data-model] 2007-03-24 01:51:38,476 [main] DEBUG (Database#debug():1450) - parseJapaneseCharacter(); [torque-data-model] 2007-03-24 01:51:38,476 [main] DEBUG (Database#debug():1450) - parseJapaneseCharacterImpl(); [torque-data-model] 2007-03-24 01:51:38,476 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:38,476 [main] DEBUG (Database#debug():1450) - parseDaoDicon() { [torque-data-model] 2007-03-24 01:51:38,476 [main] DEBUG (Database#debug():1450) - /dbflute.dicon [torque-data-model] 2007-03-24 01:51:38,492 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:38,492 [main] DEBUG (Database#debug():1450) - public void parseDaoSelector() { [torque-data-model] 2007-03-24 01:51:38,492 [main] DEBUG (Database#debug():1450) - parseDaoSelector(); [torque-data-model] 2007-03-24 01:51:38,492 [main] DEBUG (Database#debug():1450) - parseCacheDaoSelector(); [torque-data-model] 2007-03-24 01:51:38,508 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:38,508 [main] DEBUG (Database#debug():1450) - parseGenMetaData(); [torque-data-model] 2007-03-24 01:51:38,508 [main] DEBUG (Database#debug():1450) - public void parseInterceptorClass() { [torque-data-model] 2007-03-24 01:51:38,523 [main] DEBUG (Database#debug():1450) - parseCommonColumnSetupAbstractInterceptor(); [torque-data-model] 2007-03-24 01:51:38,523 [main] DEBUG (Database#debug():1450) - parseCommonColumnSetupBeforeInsertInterceptor(); [torque-data-model] 2007-03-24 01:51:38,523 [main] DEBUG (Database#debug():1450) - parseCommonColumnSetupBeforeUpdateInterceptor(); [torque-data-model] 2007-03-24 01:51:38,523 [main] DEBUG (Database#debug():1450) - parseCommonColumnSetupBeforeDeleteInterceptor(); [torque-data-model] 2007-03-24 01:51:38,539 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:38,570 [main] DEBUG (Database#debug():1450) - public void parseTableList() { [torque-data-model] 2007-03-24 01:51:38,570 [main] DEBUG (Database#debug():1450) - final List<Table> tableList = getTableList(); [torque-data-model] 2007-03-24 01:51:38,570 [main] DEBUG (Database#debug():1450) - for (Table tbl : tableList) { [torque-data-model] 2007-03-24 01:51:38,570 [main] DEBUG (Database#debug():1450) - parseTable(tbl); // テーブル名1 : テーブル名1 (中略) [torque-data-model] 2007-03-24 01:51:43,023 [main] DEBUG (Database#debug():1450) - parseTable(tbl); // テーブル名28 : テーブル名28 [torque-data-model] 2007-03-24 01:51:43,148 [main] DEBUG (Database#debug():1450) - } [torque-data-model] 2007-03-24 01:51:43,148 [main] DEBUG (Database#debug():1450) - } BUILD SUCCESSFUL Total time: 14 seconds 続行するには何かキーを押してください . . .
Propertyにて指定した出力DirectoryにSourceが作成されていたら成功です。
ソース生成されていました。
確認のために生成されたSourceをCompileしてみて下さい。
確認のためにCompileされたDaoでSelectしてみて下さい。
んーーーと。これらのテーブル、データが全然入ってません。というわけで、データ用意しなきゃですね。ちょっと手間かかるので、明日にでも。
以上で、初期セットアップはOKですかね。
本日のまとめ、というか気づいたこと。
- %DBFLUTE_HOME%からtorque.java.dir(../src/main/java)を辿ったところにreport.cepoc.om.generationっていうファイルが…。こんな所にファイル作られても…。
- ルートパッケージを、Doltengで指定したものと同一にしてしまったが、Teedaのパッケージと混在してしまうので、jp.xet.cepoc.dbflute等にしておいた方が良いのかな?と思いました。
- Teeda上で使う場合、src/main/java に生成された dbflute.dicon は src/main/resources に移動した方がいいですかね。あ、でも繰り返し生成する時に混乱するかな?
というわけで、本日はここまで!