[Seasar-user:18149] Re: 【DBFlute】 Maven-DBFluteプラグインの複数DB設定について

kubo [E-MAIL ADDRESS DELETED]
2009年 8月 1日 (土) 14:24:00 JST 

久保(jflute)です。

> ・マルチDB対応(4DBあるので、プロファイルだとちょっと大変なので)
> ・jdbc,generate,sql2entityを一括で行うゴールの作成
> (4DB分のコマンド12発なので・・・)

そうですね、仕様のやり取りとかをする可能性がありますので、
別スレッドでお願いします。

2009/8/1 金子 雄一 <[E-MAIL ADDRESS DELETED]>:
> 金子です。
>
> 確認しました。
>
> 途中で止まることなく、
> 最後まで実行されました。
>
> ご対応ありがとうございました。
>
>
> ところで、2点ほど要望があるのですが、
> 別タイトルのスレッドで出せばよろしいでしょうか？
>
> ・マルチDB対応(4DBあるので、プロファイルだとちょっと大変なので)
> ・jdbc,generate,sql2entityを一括で行うゴールの作成
> (4DB分のコマンド12発なので・・・)
>
>
> 以上、よろしくお願いします。
>
>
> 金子 雄一 <[E-MAIL ADDRESS DELETED]>
>
>
> Shinsuke Sugaya さんは書きました:
>> 菅谷です。
>>
>> いろいろと確認していただきありがとうございました。
>> 修正したもの (0.2.0-SNAPSHOT) を M2 スナップショット
>> リポジトリに置きました。bat からの出力が多くても
>> 大丈夫かと思います。
>>
>> よろしくお願いいたします。
>>
>> shinsuke
>>
>>
>> 2009/07/31 13:41 に 金子 雄一<[E-MAIL ADDRESS DELETED]> さんは書きました:
>>> 金子です。
>>>
>>>> 試しに、SQLファイルを一つか二つくらいに減らして
>>>> 実行してみて頂けます？
>>> この場合は、うまく行きました。
>>>
>>>> (あと、SQLファイルが一個も無い状態でどうなるかとか)
>>> これも、特に問題ありません。
>>>
>>>
>>> 試した限りでは、
>>>
>>>>> [INFO] Building SMS-DBFlute
>>> この行から、数えて、500行を越えたあたりで、
>>> 止まっているような感じでした。
>>>
>>>
>>> 以上、よろしくお願いします。
>>>
>>>
>>> kubo さんは書きました:
>>>> 久保(jflute)です。
>>>>
>>>> 試しに、SQLファイルを一つか二つくらいに減らして
>>>> 実行してみて頂けます？
>>>> (あと、SQLファイルが一個も無い状態でどうなるかとか)
>>>>
>>>> 2009/7/30 金子 雄一 <[E-MAIL ADDRESS DELETED]>:
>>>>> 金子です。
>>>>>
>>>>>> bat で実行した場合に、何か入力待ちなったり
>>>>>> しているでしょうか? (たとえば、y や n を
>>>>>> 聞かれたりなど)
>>>>> 入力待ちには、なっておりません。
>>>>>
>>>>>> あと dbflute:sql2entity を実行して止まった付近の
>>>>>> メッセージをいただけないでしょうか? どこら辺で
>>>>>> 止まっているのか確認したいと考えています。
>>>>> コンソールをそのまま、コピーしました。
>>>>> かなり長いですが、ご容赦ください。
>>>>>
>>>>> E:\EclipseWorkSpace\SMS-DBFlute>mvn dbflute:sql2entity -P salondb
>>>>> [INFO] Scanning for projects...
>>>>> [INFO]
>>>>> ------------------------------------------------------------------------
>>>>> [INFO] Building SMS-DBFlute
>>>>> [INFO]    task-segment: [dbflute:sql2entity]
>>>>> [INFO]
>>>>> ------------------------------------------------------------------------
>>>>> [INFO] [dbflute:sql2entity {execution: default-cli}]
>>>>> [INFO] Running cmd.exe /c sql2entity.bat
>>>>> [INFO]         1 個のファイルをコピーしました。
>>>>> [INFO] Buildfile: ..\mydbflute\dbflute-0.9.5.2\build-torque.xml
>>>>> [INFO]   [taskdef] Could not load definitions from resource
>>>>> net/sf/antcontrib/antcontrib.properties. It could not be found.
>>>>> [INFO]
>>>>> [INFO] sql2entity:
>>>>> [INFO]      [echo] +-----------------------------------------------+
>>>>> [INFO]      [echo] |                                               |
>>>>> [INFO]      [echo] | Sql 2 Entity !                                |
>>>>> [INFO]      [echo] |                                               |
>>>>> [INFO]      [echo] +-----------------------------------------------+
>>>>> [INFO] [torque-sql2entity] Using contextProperties file:
>>>>>
>>>>> E:\EclipseWorkSpace\SMS-DBFlute\mydbflute\dbflute-0.9.5.2\build.properties
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,598 INFO  - Using
>>>>> contextProperties file:
>>>>>
>>>>> E:\EclipseWorkSpace\SMS-DBFlute\mydbflute\dbflute-0.9.5.2\build.properties
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,598 INFO  - [Properties]:
>>>>> size=1
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,598 INFO  -
>>>>> torque.project = SALONDB
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,629 INFO  - ...create()
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,645 INFO  - * * * * * * *
>>>>> * *
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,645 INFO  - * Process Java
>>>>>  *
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,645 INFO  - * * * * * * *
>>>>> * *
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,645 INFO  - ...Using Java
>>>>> control: om/ControlSql2EntityJava.vm
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:19,676 INFO  - Resolver:
>>>>> used database.dtd from 'org.apache.torque.engine.database.transform'
>>>>> package
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,067 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\PriceFilBhv_GET_PRICE_PRD_SEARCH.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,223 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- #GetPricePrdSearch#
>>>>> [INFO] [torque-sql2entity] -- !GetPricePrdSearchPmb extends SPB!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdCdCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdNameCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdKbnCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long makerIdCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long brandIdCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long categoryId1Condition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long categoryId2Condition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date minApplCtlCdate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long>
>>>>> comSauthHdrComIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> comSauthGrpIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long>
>>>>> comSauthOpeComIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long>
>>>>> comShopSettingShpIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Boolean showCtg1Flg!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] -- ELSE select count(*) from(
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     product.prd_id,
>>>>> [INFO] [torque-sql2entity]     price.prc_id,
>>>>> [INFO] [torque-sql2entity]     product.prd_cd,
>>>>> [INFO] [torque-sql2entity]     code.ref_name,
>>>>> [INFO] [torque-sql2entity]     product.prd_name,
>>>>> [INFO] [torque-sql2entity]     price.prc_sel_prc_itx,
>>>>> [INFO] [torque-sql2entity]     shop.shp_name,
>>>>> [INFO] [torque-sql2entity]     shop.shp_id
>>>>> [INFO] [torque-sql2entity]  from
>>>>> [INFO] [torque-sql2entity]      price_fil price
>>>>> [INFO] [torque-sql2entity]      left outer join product_mst product
>>>>> [INFO] [torque-sql2entity]        on price.prc_prd_id = product.prd_id
>>>>> [INFO] [torque-sql2entity]      left outer join code_ref_fil code
>>>>> [INFO] [torque-sql2entity]        on product.prd_sh_kbn = code.ref_no
>>>>> [INFO] [torque-sql2entity]      left outer join shop_mst shop
>>>>> [INFO] [torque-sql2entity]        on price.prc_shp_id = shop.shp_id
>>>>> [INFO] [torque-sql2entity]      left outer join stock_mst stock
>>>>> [INFO] [torque-sql2entity]        on product.prd_id = stock.stc_prd_id
>>>>> [INFO] [torque-sql2entity]        and shop.shp_id = stock.stc_shp_id
>>>>> [INFO] [torque-sql2entity]  where
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.prdCdCondition != null*/
>>>>> [INFO] [torque-sql2entity]          product.prd_cd like '%' ||
>>>>> /*pmb.prdCdCondition*/'' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.prdNameCondition != null*/
>>>>> [INFO] [torque-sql2entity]          product.prd_name like '%' ||
>>>>> /*pmb.prdNameCondition*/'' || '%' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.prdKbnCondition != null*/
>>>>> [INFO] [torque-sql2entity]          product.prd_sh_kbn =
>>>>> /*pmb.prdKbnCondition*/'1' and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.makerIdCondition != null*/
>>>>> [INFO] [torque-sql2entity]          product.prd_mkr_id =
>>>>> /*pmb.makerIdCondition*/'1' and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.brandIdCondition != null*/
>>>>> [INFO] [torque-sql2entity]           product.prd_bnd_id =
>>>>> /*pmb.brandIdCondition*/'1' and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     product.prd_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     product.prd_avl_date_to >=
>>>>> /*pmb.minApplCtlCdate*/'2009/04/21' and
>>>>> [INFO] [torque-sql2entity]     product.prd_hdr_com_id in
>>>>> /*pmb.comSauthHdrComIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     product.prd_grp_id in
>>>>> /*pmb.comSauthGrpIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.showCtg1Flg &&
>>>>> pmb.categoryId1Condition != null */
>>>>> [INFO] [torque-sql2entity]     exists (select opeCategory.opc_prd_id
>>>>> [INFO] [torque-sql2entity]                  from ope_category_mst
>>>>> opeCategory
>>>>> [INFO] [torque-sql2entity]                 where opeCategory.opc_prd_id
>>>>> = product.prd_id and
>>>>> [INFO] [torque-sql2entity]                  /*IF
>>>>> pmb.categoryId1Condition != null*/
>>>>> [INFO] [torque-sql2entity]                   opeCategory.opc_ctg1_id =
>>>>> /*pmb.categoryId1Condition*/('1') and
>>>>> [INFO] [torque-sql2entity]                 /*END*/
>>>>> [INFO] [torque-sql2entity]                  /*IF
>>>>> pmb.categoryId2Condition != null*/
>>>>> [INFO] [torque-sql2entity]                   opeCategory.opc_ctg2_id =
>>>>> /*pmb.categoryId2Condition*/('1') and
>>>>> [INFO] [torque-sql2entity]                 /*END*/
>>>>> [INFO] [torque-sql2entity]                 opeCategory.opc_ope_com_id in
>>>>> /*pmb.comSauthOpeComIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]                 opeCategory.opc_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]        ) and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     exists (select appl.appl_ctl_id
>>>>> [INFO] [torque-sql2entity]                  from appl_ctl_mst appl
>>>>> [INFO] [torque-sql2entity]                 where appl.shp_id =
>>>>> shop.shp_id and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_date >=
>>>>> product.prd_avl_date_fr and
>>>>> [INFO] [torque-sql2entity]
>>>>> appl.appl_ctl_date >= stock.stc_avl_date_fr and
>>>>> [INFO] [torque-sql2entity]
>>>>> appl.appl_ctl_date >= price.prc_avl_date_fr and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_date <=
>>>>> product.prd_avl_date_to and
>>>>> [INFO] [torque-sql2entity]
>>>>> appl.appl_ctl_date <= stock.stc_avl_date_to and
>>>>> [INFO] [torque-sql2entity]
>>>>> appl.appl_ctl_date <= price.prc_avl_date_to and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]        ) and
>>>>> [INFO] [torque-sql2entity]     stock.stc_shp_id in
>>>>> /*pmb.comShopSettingShpIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     stock.stc_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     stock.stc_avl_date_to >=
>>>>> /*pmb.minApplCtlCdate*/'2009/04/21' and
>>>>> [INFO] [torque-sql2entity]     price.prc_shp_id in
>>>>> /*pmb.comShopSettingShpIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     price.prc_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     price.prc_avl_date_to >=
>>>>> /*pmb.minApplCtlCdate*/'2009/04/21' and
>>>>> [INFO] [torque-sql2entity]     code.ref_del_flg = '0'
>>>>> [INFO] [torque-sql2entity] order by
>>>>> [INFO] [torque-sql2entity]     product.prd_sh_kbn asc, product.prd_cd asc
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] -- ELSE ) as table1
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,270 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,270 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ProductMstBhv_GET_GRP_MIN_AND_MAX_APP_DATE.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,285 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # GetGrpMinAndMaxAppDate #
>>>>> [INFO] [torque-sql2entity] -- !GetGrpMinAndMaxAppDatePmb!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date systemDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long prd_id!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     MIN(a.appl_ctl_date) as min_appl_ctl_date,
>>>>> [INFO] [torque-sql2entity]     MAX(a.appl_ctl_date) as max_appl_ctl_date
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]     product_mst p
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     shop_mst s
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     p.prd_hdr_com_id = s.shp_hdr_com_id and
>>>>> [INFO] [torque-sql2entity]     p.prd_grp_id = s.shp_grp_id
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     appl_ctl_mst a
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     s.shp_id = a.shp_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]     p.prd_id = /*pmb.prd_id*/('1')
>>>>> [INFO] [torque-sql2entity]     and p.prd_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and s.shp_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and s.shp_avl_date_fr <=
>>>>> /*pmb.systemDate*/'2009-04-21'
>>>>> [INFO] [torque-sql2entity]     and s.shp_avl_date_to >=
>>>>> /*pmb.systemDate*/'2009-04-21'
>>>>> [INFO] [torque-sql2entity]     and a.appl_ctl_del_flg = '0'
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,285 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,285 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ProductMstBhv_GET_STOCK_PRD_ONE.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,301 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # GetStockPrdOne #
>>>>> [INFO] [torque-sql2entity] -- !GetStockPrdOnePmb!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long prdId!!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date appDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long hdrComId!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long grpId!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long shpId!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     product.prd_id,
>>>>> [INFO] [torque-sql2entity]     product.prd_cd,
>>>>> [INFO] [torque-sql2entity]     product.prd_sh_kbn,
>>>>> [INFO] [torque-sql2entity]     product.prd_name,
>>>>> [INFO] [torque-sql2entity]     product.prd_mkr_id,
>>>>> [INFO] [torque-sql2entity]     product.prd_bnd_id,
>>>>> [INFO] [torque-sql2entity]     price.prc_ctlg_prc_itx,
>>>>> [INFO] [torque-sql2entity]     price.prc_sel_prc_itx,
>>>>> [INFO] [torque-sql2entity]     stock.stc_inv_qnty
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]     product_mst product
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     price_fil price
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     product.prd_id = price.prc_prd_id
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     stock_mst stock
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     product.prd_id = stock.stc_prd_id
>>>>> [INFO] [torque-sql2entity]     and price.prc_shp_id = stock.stc_shp_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]     product.prd_id = /*pmb.prdId*/('1') and
>>>>> [INFO] [torque-sql2entity]     product.prd_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     product.prd_avl_date_fr <=
>>>>> /*pmb.appDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     product.prd_avl_date_to >=
>>>>> /*pmb.appDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     product.prd_hdr_com_id =
>>>>> /*pmb.hdrComId*/('1') and
>>>>> [INFO] [torque-sql2entity]     product.prd_grp_id = /*pmb.grpId*/('1')
>>>>> and
>>>>> [INFO] [torque-sql2entity]     stock.stc_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     stock.stc_avl_date_fr <=
>>>>> /*pmb.appDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     stock.stc_avl_date_to >=
>>>>> /*pmb.appDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     stock.stc_id is not null and
>>>>> [INFO] [torque-sql2entity]     stock.stc_shp_id = /*pmb.shpId*/('1') and
>>>>> [INFO] [torque-sql2entity]     price.prc_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     price.prc_avl_date_fr <=
>>>>> /*pmb.appDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     price.prc_avl_date_to >=
>>>>> /*pmb.appDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     price.prc_shp_id = /*pmb.shpId*/('1')
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,301 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,301 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ProductMstBhv_GET_STOCK_PRD_SEARCH.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,317 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # GetStockPrdSearch #
>>>>> [INFO] [torque-sql2entity] -- !GetStockPrdSearchPmb extends SPB!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdCd!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdName!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long mkrId!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long bndId!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdShKbn!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<String> prdShKbnList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date minDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> hdrComIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> grpIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> shpIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date sysDate!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] -- ELSE select count(*) from(
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     product.prd_id,
>>>>> [INFO] [torque-sql2entity]     product.prd_cd,
>>>>> [INFO] [torque-sql2entity]     maker.mkr_name,
>>>>> [INFO] [torque-sql2entity]     brand.bnd_name,
>>>>> [INFO] [torque-sql2entity]     product.prd_name,
>>>>> [INFO] [torque-sql2entity]     price.prc_ctlg_prc_itx,
>>>>> [INFO] [torque-sql2entity]     price.prc_sel_prc_itx,
>>>>> [INFO] [torque-sql2entity]     stock.stc_id,
>>>>> [INFO] [torque-sql2entity]     stock.stc_inv_qnty,
>>>>> [INFO] [torque-sql2entity]     shop.shp_name,
>>>>> [INFO] [torque-sql2entity]     shop.shp_id
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]     product_mst product
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     price_fil price
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     product.prd_id = price.prc_prd_id
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     stock_mst stock
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     product.prd_id = stock.stc_prd_id
>>>>> [INFO] [torque-sql2entity]     and price.prc_shp_id = stock.stc_shp_id
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     brand_mst brand
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     product.prd_bnd_id = brand.bnd_id and
>>>>> [INFO] [torque-sql2entity]     brand.bnd_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     brand.bnd_avl_date_fr <=
>>>>> /*pmb.sysDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     brand.bnd_avl_date_to >=
>>>>> /*pmb.sysDate*/'2009-05-12'
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     maker_mst maker
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     product.prd_mkr_id = maker.mkr_id and
>>>>> [INFO] [torque-sql2entity]     maker.mkr_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     maker.mkr_avl_date_fr <=
>>>>> /*pmb.sysDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     maker.mkr_avl_date_to >=
>>>>> /*pmb.sysDate*/'2009-05-12'
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     shop_mst shop
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     stock.stc_shp_id = shop.shp_id
>>>>> [INFO] [torque-sql2entity]     and price.prc_shp_id = shop.shp_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]     /*IF pmb.prdCd != null*/
>>>>> [INFO] [torque-sql2entity]         product.prd_cd like '%' ||
>>>>> /*pmb.prdCd*/('1') and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     /*IF pmb.prdName != null*/
>>>>> [INFO] [torque-sql2entity]         product.prd_name like '%' ||
>>>>> /*pmb.prdName*/('1') || '%' and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     /*IF pmb.mkrId != null*/
>>>>> [INFO] [torque-sql2entity]         maker.mkr_id = /*pmb.mkrId*/('1') and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     /*IF pmb.bndId != null*/
>>>>> [INFO] [torque-sql2entity]         brand.bnd_id = /*pmb.bndId*/('1') and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     /*IF pmb.prdShKbn != null*/
>>>>> [INFO] [torque-sql2entity]         product.prd_sh_kbn =
>>>>> /*pmb.prdShKbn*/('1') and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     /*IF pmb.prdShKbn == null*/
>>>>> [INFO] [torque-sql2entity]         product.prd_sh_kbn in
>>>>> /*pmb.prdShKbnList*/('1') and
>>>>> [INFO] [torque-sql2entity]     /*END*/
>>>>> [INFO] [torque-sql2entity]     product.prd_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     product.prd_hdr_com_id in
>>>>> /*pmb.hdrComIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     product.prd_grp_id in
>>>>> /*pmb.grpIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     stock.stc_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     stock.stc_id is not null and
>>>>> [INFO] [torque-sql2entity]     stock.stc_shp_id in
>>>>> /*pmb.shpIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     price.prc_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     price.prc_shp_id in
>>>>> /*pmb.shpIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     exists (select appl.appl_ctl_id
>>>>> [INFO] [torque-sql2entity]                  from appl_ctl_mst appl
>>>>> [INFO] [torque-sql2entity]                 where appl.shp_id =
>>>>> shop.shp_id and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_date >=
>>>>> product.prd_avl_date_fr and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_date <=
>>>>> product.prd_avl_date_to and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_date >=
>>>>> price.prc_avl_date_fr and
>>>>> [INFO] [torque-sql2entity]                            appl.appl_ctl_date
>>>>> <= price.prc_avl_date_to and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_date >=
>>>>> stock.stc_avl_date_fr and
>>>>> [INFO] [torque-sql2entity]                            appl.appl_ctl_date
>>>>> <= stock.stc_avl_date_to and
>>>>> [INFO] [torque-sql2entity]                   appl.appl_ctl_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]        ) and
>>>>> [INFO] [torque-sql2entity]     shop.shp_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     shop.shp_avl_date_fr <=
>>>>> /*pmb.sysDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     shop.shp_avl_date_to >=
>>>>> /*pmb.sysDate*/'2009-05-12' and
>>>>> [INFO] [torque-sql2entity]     shop.shp_id in /*pmb.shpIdList*/('1')
>>>>> [INFO] [torque-sql2entity] order by
>>>>> [INFO] [torque-sql2entity]     shop.shp_name_kn,
>>>>> [INFO] [torque-sql2entity]     stock.stc_sort,
>>>>> [INFO] [torque-sql2entity]     maker.mkr_name_kn,
>>>>> [INFO] [torque-sql2entity]     brand.bnd_name_kn,
>>>>> [INFO] [torque-sql2entity]     stock.stc_inv_qnty
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] -- ELSE ) as table1
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,348 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,348 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ProductMstBhv_ISEXIST_APPOINT.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,348 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # IsExistAppiont #
>>>>> [INFO] [torque-sql2entity] -- !IsExistAppiontPmb!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date appDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long shp_id!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long prd_id!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     count(p.prd_id) as cnt
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]     product_mst p
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     stock_mst s
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     p.prd_id = s.stc_prd_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]     p.prd_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and p.prd_avl_date_to >=
>>>>> /*pmb.appDate*/'2009-07-17'
>>>>> [INFO] [torque-sql2entity]     and s.stc_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and s.stc_avl_date_to >=
>>>>> /*pmb.appDate*/'2009-07-17'
>>>>> [INFO] [torque-sql2entity]     and s.stc_shp_id = /*pmb.shp_id*/('1')
>>>>> [INFO] [torque-sql2entity]     and s.stc_prd_id = /*pmb.prd_id*/('1')
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,348 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,348 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ProductMstBhv_MAINTENANCE_PRD_SETTING_SEARCH.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,364 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- #MaintenancePrdSettingSearch#
>>>>> [INFO] [torque-sql2entity] -- !MaintenancePrdSettingSearchPmb extends
>>>>> SPB!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdCdCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdNameCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.String prdKbnCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long makerIdCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long brandIdCondition!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.Date minAppDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> shp_id_list!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> grp_id_list!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long>
>>>>> grp_hdr_com_id_list!!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date systemDate!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] -- ELSE select count(*) from(
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_id,
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_cd,
>>>>> [INFO] [torque-sql2entity]     codefil.ref_name,
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_name,
>>>>> [INFO] [torque-sql2entity]     stmst.stc_id,
>>>>> [INFO] [torque-sql2entity]     shpmst.shp_id,
>>>>> [INFO] [torque-sql2entity]     shpmst.shp_name,
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_sh_kbn,
>>>>> [INFO] [torque-sql2entity]      stmst.stc_avl_date_fr as stc_avl_date_fr,
>>>>> [INFO] [torque-sql2entity]     appl.appl_ctl_date
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]     product_mst prdmst
>>>>> [INFO] [torque-sql2entity]   inner join shop_mst shpmst
>>>>> [INFO] [torque-sql2entity]     on prdmst.prd_grp_id = shpmst.shp_grp_id
>>>>> [INFO] [torque-sql2entity]     and shpmst.shp_id IN
>>>>> /*pmb.shp_id_list*/('1','3','5')
>>>>> [INFO] [torque-sql2entity]     and shpmst.shp_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and shpmst.shp_avl_date_fr <=
>>>>> /*pmb.systemDate*/'2009/04/21'
>>>>> [INFO] [torque-sql2entity]     and shpmst.shp_avl_date_to >=
>>>>> /*pmb.systemDate*/'2009/04/21'
>>>>> [INFO] [torque-sql2entity]   inner join code_ref_fil codefil
>>>>> [INFO] [torque-sql2entity]     on prdmst.prd_sh_kbn = codefil.ref_no
>>>>> [INFO] [torque-sql2entity]   left outer join stock_mst stmst
>>>>> [INFO] [torque-sql2entity]     on prdmst.prd_id = stmst.stc_prd_id
>>>>> [INFO] [torque-sql2entity]     and stmst.stc_shp_id = shpmst.shp_id
>>>>> [INFO] [torque-sql2entity]     and stmst.stc_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and stmst.stc_avl_date_to >=
>>>>> /*pmb.minAppDate*/'2009/04/21'
>>>>> [INFO] [torque-sql2entity]   left outer join price_fil prefil
>>>>> [INFO] [torque-sql2entity]     on prdmst.prd_id = prefil.prc_prd_id
>>>>> [INFO] [torque-sql2entity]     and prefil.prc_shp_id = shpmst.shp_id
>>>>> [INFO] [torque-sql2entity]     and prefil.prc_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and prefil.prc_avl_date_to >=
>>>>> /*pmb.minAppDate*/'2009/04/21'
>>>>> [INFO] [torque-sql2entity]   left outer join appl_ctl_mst appl
>>>>> [INFO] [torque-sql2entity]     on shpmst.shp_id = appl.shp_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.prdCdCondition != null*/
>>>>> [INFO] [torque-sql2entity]      prdmst.prd_cd like '%' ||
>>>>> /*pmb.prdCdCondition*/'' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.prdNameCondition != null*/
>>>>> [INFO] [torque-sql2entity]      prdmst.prd_name like '%' ||
>>>>> /*pmb.prdNameCondition*/'' || '%' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.prdKbnCondition != null*/
>>>>> [INFO] [torque-sql2entity]      prdmst.prd_sh_kbn =
>>>>> /*pmb.prdKbnCondition*/'1' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.makerIdCondition != null*/
>>>>> [INFO] [torque-sql2entity]      prdmst.prd_mkr_id =
>>>>> /*pmb.makerIdCondition*/'1' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]      /*IF pmb.brandIdCondition != null*/
>>>>> [INFO] [torque-sql2entity]      prdmst.prd_bnd_id =
>>>>> /*pmb.brandIdCondition*/'1' and
>>>>> [INFO] [torque-sql2entity]      /*END*/
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and prdmst.prd_hdr_com_id IN
>>>>> /*pmb.grp_hdr_com_id_list*/('1','3','5')
>>>>> [INFO] [torque-sql2entity]     and prdmst.prd_grp_id IN
>>>>> /*pmb.grp_id_list*/('1','3','5')
>>>>> [INFO] [torque-sql2entity]     and codefil.ref_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and codefil.ref_no <> '14999'
>>>>> [INFO] [torque-sql2entity]     and prdmst.prd_avl_date_to >=
>>>>> appl.appl_ctl_date
>>>>> [INFO] [torque-sql2entity]      and prdmst.prd_avl_date_fr <=
>>>>> appl.appl_ctl_date
>>>>> [INFO] [torque-sql2entity]     and
>>>>> [INFO] [torque-sql2entity]     (stmst.stc_id is null OR
>>>>> stmst.stc_avl_date_fr <= appl.appl_ctl_date)
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] order by
>>>>> [INFO] [torque-sql2entity]     shpmst.shp_id,
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_sh_kbn,
>>>>> [INFO] [torque-sql2entity]     prdmst.prd_cd
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] /*IF pmb.isPaging() */
>>>>> [INFO] [torque-sql2entity] limit /*$pmb.fetchSize*/20 offset
>>>>> /*$pmb.pageStartIndex*/80
>>>>> [INFO] [torque-sql2entity] -- ELSE ) as table1
>>>>> [INFO] [torque-sql2entity] /*END*/
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,379 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,379 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ShopMstBhv_GET_GROUP_APP_MIN_AND_MAX_DATE.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,379 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # GetAppCtrlMinMaxDate #
>>>>> [INFO] [torque-sql2entity] -- !GetAppCtrlMinMaxDatePmb!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date systemDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> grp_id_list!!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long>
>>>>> grp_hdr_com_id_list!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]      MIN(a.appl_ctl_date) as
>>>>> min_appl_ctl_date,
>>>>> [INFO] [torque-sql2entity]      MAX(a.appl_ctl_date) as max_appl_ctl_date
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]      shop_mst s
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]      appl_ctl_mst a
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]      s.shp_id = a.shp_id
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     group_mst g
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     s.shp_grp_id = g.grp_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]     g.grp_id in /*pmb.grp_id_list*/('1')
>>>>> [INFO] [torque-sql2entity]     and g.grp_hdr_com_id in
>>>>> /*pmb.grp_hdr_com_id_list*/('1')
>>>>> [INFO] [torque-sql2entity]     and g.grp_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and g.grp_avl_date_fr <=
>>>>> /*pmb.systemDate*/'2009-04-21'
>>>>> [INFO] [torque-sql2entity]     and g.grp_avl_date_to >=
>>>>> /*pmb.systemDate*/'2009-04-21'
>>>>> [INFO] [torque-sql2entity]     and s.shp_del_flg = '0'
>>>>> [INFO] [torque-sql2entity]     and s.shp_avl_date_fr <=
>>>>> /*pmb.systemDate*/'2009-04-21'
>>>>> [INFO] [torque-sql2entity]     and s.shp_avl_date_to >=
>>>>> /*pmb.systemDate*/'2009-04-21'
>>>>> [INFO] [torque-sql2entity]     and a.appl_ctl_del_flg = '0'
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,395 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,395 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ShopMstBhv_GET_GROUP_ID_AND_GROUP_NAME.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,395 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # GetGroupIdAndGroupName #
>>>>> [INFO] [torque-sql2entity] -- !GetGroupIdAndGroupNamePmb!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date systemDate!!
>>>>> [INFO] [torque-sql2entity] -- !!java.lang.Long shpOpeComId!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] SELECT
>>>>> [INFO] [torque-sql2entity] DISTINCT
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_ID ,
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_NAME ,
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_NAME_KN
>>>>> [INFO] [torque-sql2entity] FROM
>>>>> [INFO] [torque-sql2entity]         SHOP_MST SHOP LEFT OUTER JOIN
>>>>> GROUP_MST GRP
>>>>> [INFO] [torque-sql2entity]         ON SHOP.SHP_GRP_ID = GRP.GRP_ID
>>>>> [INFO] [torque-sql2entity] WHERE
>>>>> [INFO] [torque-sql2entity]         SHOP.SHP_DEL_FLG = '0' AND
>>>>> [INFO] [torque-sql2entity]         /*IF pmb.shpOpeComId != null*/
>>>>> [INFO] [torque-sql2entity]          SHOP.SHP_OPE_COM_ID =
>>>>> /*pmb.shpOpeComId*/4 AND
>>>>> [INFO] [torque-sql2entity]         /*END*/
>>>>> [INFO] [torque-sql2entity]         SHOP.SHP_AVL_DATE_FR <=
>>>>> /*pmb.systemDate*/'2009-06-12' AND
>>>>> [INFO] [torque-sql2entity]         SHOP.SHP_AVL_DATE_TO >=
>>>>> /*pmb.systemDate*/'2009-06-12' AND
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_DEL_FLG = '0' AND
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_AVL_DATE_FR <=
>>>>> /*pmb.systemDate*/'2009-06-12' AND
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_AVL_DATE_TO >=
>>>>> /*pmb.systemDate*/'2009-06-12'
>>>>> [INFO] [torque-sql2entity] ORDER BY
>>>>> [INFO] [torque-sql2entity]         GRP.GRP_NAME_KN ASC
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,395 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,395 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ShopMstBhv_GET_OPE_COM_MIN_AND_MAX_APP_DATE.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,395 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # GetOpeComMinAndMaxAppDate #
>>>>> [INFO] [torque-sql2entity] -- !GetOpeComMinAndMaxAppDatePmb!
>>>>> [INFO] [torque-sql2entity] -- !!java.util.List<Long> opeComIdList!!
>>>>> [INFO] [torque-sql2entity] -- !!java.sql.Date sysDate!!
>>>>> [INFO] [torque-sql2entity]
>>>>> [INFO] [torque-sql2entity] select
>>>>> [INFO] [torque-sql2entity]     MIN(a.appl_ctl_date) as min_appl_ctl_date,
>>>>> [INFO] [torque-sql2entity]     MAX(a.appl_ctl_date) as max_appl_ctl_date
>>>>> [INFO] [torque-sql2entity] from
>>>>> [INFO] [torque-sql2entity]     shop_mst s
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     company_mst c
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     s.shp_ope_com_id = c.com_id
>>>>> [INFO] [torque-sql2entity] left outer join
>>>>> [INFO] [torque-sql2entity]     appl_ctl_mst a
>>>>> [INFO] [torque-sql2entity] on
>>>>> [INFO] [torque-sql2entity]     s.shp_id = a.shp_id
>>>>> [INFO] [torque-sql2entity] where
>>>>> [INFO] [torque-sql2entity]     c.com_id in /*pmb.opeComIdList*/('1') and
>>>>> [INFO] [torque-sql2entity]     c.com_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     s.shp_avl_date_fr <=
>>>>> /*pmb.sysDate*/('2009-05-27') and
>>>>> [INFO] [torque-sql2entity]     s.shp_avl_date_to >=
>>>>> /*pmb.sysDate*/('2009-05-27') and
>>>>> [INFO] [torque-sql2entity]     s.shp_del_flg = '0' and
>>>>> [INFO] [torque-sql2entity]     a.appl_ctl_del_flg = '0'
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,410 INFO  -   -->
>>>>> success=1 failure=0
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,410 INFO  - {SQL File}:
>>>>>
>>>>> ..\src\main\resources\jp\co\plussum\dbflute\salondb\exbhv\emainte\ShopMstBhv_GET_SHOP_APPLICATION_DATE.sql
>>>>> [INFO] [torque-sql2entity] 2009-07-30 06:10:20,410 INFO  - {SQL}
>>>>> [INFO] [torque-sql2entity] -- # ShopMstEntity #
>>>>>
>>>>>
>>>>> 毎回、この時点で、必ず止まります。
>>>>>
>>>>>
>>>>> 以上、よろしくお願いします。
>>>>>
>>>>>
>>>>>
>>>>> Shinsuke Sugaya さんは書きました:
>>>>>> 菅谷です。
>>>>>>
>>>>>>> なお、sql2entity.batの実行であれば、20秒足らずで完了します。
>>>>>> bat で実行した場合に、何か入力待ちなったり
>>>>>> しているでしょうか? (たとえば、y や n を
>>>>>> 聞かれたりなど)
>>>>>>
>>>>>> あと dbflute:sql2entity を実行して止まった付近の
>>>>>> メッセージをいただけないでしょうか? どこら辺で
>>>>>> 止まっているのか確認したいと考えています。
>>>>>>
>>>>>> shinsuke
>>>>>>
>>>>>>
>>>>>> 2009/07/30 5:24 に 金子 雄一<[E-MAIL ADDRESS DELETED]> さんは書きました:
>>>>>>> 金子です。
>>>>>>>
>>>>>>>> バージョンについてですが 0.1.0 では
>>>>>>>> いかがでしょうか?
>>>>>>> 試してみましたが、結果は同じでした。
>>>>>>> やはり、途中で止まってしまいます。
>>>>>>> (2分程度、放置してみましたが、プロンプトが戻ってきません。)
>>>>>>>
>>>>>>> なお、sql2entity.batの実行であれば、20秒足らずで完了します。
>>>>>>>
>>>>>>>
>>>>>>> 以上、よろしくお願いします。
>>>>>>>
>>>>>>>
>>>>>>> Shinsuke Sugaya さんは書きました:
>>>>>>>> 菅谷です。
>>>>>>>>
>>>>>>>> バージョンについてですが 0.1.0 では
>>>>>>>> いかがでしょうか? (サイトが 0.1.0-SNAPSHOT
>>>>>>>> と古い情報になっているので、あとで修正して
>>>>>>>> おきます)
>>>>>>>>
>>>>>>>> shinsuke
>>>>>>>>
>>>>>>>>
>>>>>>>> 2009/07/30 0:22 に 金子 雄一<[E-MAIL ADDRESS DELETED]> さんは書きました:
>>>>>>>>> 金子です。
>>>>>>>>>
>>>>>>>>> 通常のsql2Entity.batについては、問題なく動作します。
>>>>>>>>> また、他のタスク(dbflute:jdbc,dbdlute:generate,dbflute:doc)については、
>>>>>>>>> 問題なく動作しています。
>>>>>>>>>
>>>>>>>>> 以上、よろしくお願いします。
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> kubo さんは書きました:
>>>>>>>>>> 久保(jflute)です。
>>>>>>>>>>
>>>>>>>>>>> dbflute:sql2entity タスクが途中で必ず止まってしまいます。
>>>>>>>>>>> エラーログも出ないので、何がおきているか分からないのですが、
>>>>>>>>>>> 同じところで、必ず止まってしまいます。
>>>>>>>>>> 状況確認です。
>>>>>>>>>> 普通に.batや.shからSql2Entityを実行したときは正常に動作します？
>>>>>>>>>> また、他のタスクは正常に動作します？
>>>>>>>>>>
>>>>>>>>>> 2009/7/30 金子 雄一 <[E-MAIL ADDRESS DELETED]>:
>>>>>>>>>>> 金子です。
>>>>>>>>>>>
>>>>>>>>>>>>> configuration の値は ${～} みたいな感じにして
>>>>>>>>>>>>> プロファイルを定義して切り替えるとかな
>>>>>>>>>>>>> 気がします(mvn -P db1みたいなイメージ)。
>>>>>>>>>>> この方法で、できました。
>>>>>>>>>>>
>>>>>>>>>>> なお、別件なのですが、
>>>>>>>>>>> dbflute:sql2entity タスクが途中で必ず止まってしまいます。
>>>>>>>>>>> エラーログも出ないので、何がおきているか分からないのですが、
>>>>>>>>>>> 同じところで、必ず止まってしまいます。
>>>>>>>>>>>
>>>>>>>>>>> 何か、お心当たりがある方がいらっしゃいましたら、
>>>>>>>>>>> 回避策をご教示いただけたらと存じます。
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> 以上、よろしくお願いいたします。
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> 金子 雄一 さんは書きました:
>>>>>>>>>>>> 金子です。
>>>>>>>>>>>>
>>>>>>>>>>>> 菅谷さん、ご回答ありがとうございます。
>>>>>>>>>>>> ソースを拝見させていただいたので、
>>>>>>>>>>>> なんとなく、そんな気がしないでもなかったのですが・・・。
>>>>>>>>>>>>
>>>>>>>>>>>> まずは、プロファイルでやってみる事にします。
>>>>>>>>>>>> のちのち、ご対応いただけると、非常にありがたいです。
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> 以上、よろしくお願いいたします。
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Shinsuke Sugaya さんは書きました:
>>>>>>>>>>>>> 菅谷です。
>>>>>>>>>>>>>
>>>>>>>>>>>>> 現状の実装では、そのように 1 つの pom で
>>>>>>>>>>>>> 複数の定義を書けません。やるとしたら、
>>>>>>>>>>>>> configuration の値は ${～} みたいな感じにして
>>>>>>>>>>>>> プロファイルを定義して切り替えるとかな
>>>>>>>>>>>>> 気がします(mvn -P db1みたいなイメージ)。
>>>>>>>>>>>>> それでできるかどうかは試していませんが...。
>>>>>>>>>>>>>
>>>>>>>>>>>>> shinsuke
>>>>>>>>>>>>>
>>>>>>>>>>>>> 2009/07/29 22:49 に 金子 雄一<[E-MAIL ADDRESS DELETED]> さんは書きました:
>>>>>>>>>>>>>> お世話になります。
>>>>>>>>>>>>>> 金子と申します。
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Maven-DBFluteプラグインを使用して、
>>>>>>>>>>>>>> 複数DBの設定を行いたいと考えています。
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> その際に、pom.xmlには、どのような設定をすればよろしいでしょうか？
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 現在、以下のような設定を記載して試してみましたが、
>>>>>>>>>>>>>> 一番最後の設定のみが有効になります。
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> -------------------------------------------------------------------------------------
>>>>>>>>>>>>>> <plugin>
>>>>>>>>>>>>>>      <groupId>org.seasar.dbflute</groupId>
>>>>>>>>>>>>>>      <artifactId>maven-dbflute-plugin</artifactId>
>>>>>>>>>>>>>>      <version>0.1.0-SNAPSHOT</version>
>>>>>>>>>>>>>>      <configuration>
>>>>>>>>>>>>>>              <dbfluteVersion>0.9.5.2</dbfluteVersion>
>>>>>>>>>>>>>>              <database>postgres</database>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>  <databaseDriver>org.postgresql.Driver</databaseDriver>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> <databaseUrl>jdbc:postgresql://<ホストのIP>/<DB名></databaseUrl>
>>>>>>>>>>>>>>              <databaseUser>postgres</databaseUser>
>>>>>>>>>>>>>>              <databasePassword>postgres</databasePassword>
>>>>>>>>>>>>>>              <rootPackage>jp.co.plussum</rootPackage>
>>>>>>>>>>>>>>              <dbPackage>jp.co.plussum.reportdb</dbPackage>
>>>>>>>>>>>>>>              <schemaName><スキーマ名></schemaName>
>>>>>>>>>>>>>>              <schemaFile><ファイル名></schemaFile>
>>>>>>>>>>>>>>      </configuration>
>>>>>>>>>>>>>> </plugin>
>>>>>>>>>>>>>> <plugin>
>>>>>>>>>>>>>>      <groupId>org.seasar.dbflute</groupId>
>>>>>>>>>>>>>>      <artifactId>maven-dbflute-plugin</artifactId>
>>>>>>>>>>>>>>      <version>0.1.0-SNAPSHOT</version>
>>>>>>>>>>>>>>      <configuration>
>>>>>>>>>>>>>>              <dbfluteVersion>0.9.5.2</dbfluteVersion>
>>>>>>>>>>>>>>              <database>postgres</database>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>  <databaseDriver>org.postgresql.Driver</databaseDriver>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> <databaseUrl>jdbc:postgresql://<ホストのIP>/<DB名></databaseUrl>
>>>>>>>>>>>>>>              <databaseUser>postgres</databaseUser>
>>>>>>>>>>>>>>              <databasePassword>postgres</databasePassword>
>>>>>>>>>>>>>>              <rootPackage>jp.co.plussum</rootPackage>
>>>>>>>>>>>>>>              <dbPackage>jp.co.plussum.reportdb</dbPackage>
>>>>>>>>>>>>>>              <schemaName><スキーマ名></schemaName>
>>>>>>>>>>>>>>              <schemaFile><ファイル名></schemaFile>
>>>>>>>>>>>>>>      </configuration>
>>>>>>>>>>>>>> </plugin>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> -------------------------------------------------------------------------------------
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> どなた様か、ご教示いただけたらと思います。
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> ご不明な点がありましたら、ご連絡ください。
>>>>>>>>>>>>>> 以上、よろしくお願いいたします。
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 金子 雄一 <[E-MAIL ADDRESS DELETED]>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>>> Seasar-user mailing list
>>>>>>>>>>>>>> [E-MAIL ADDRESS DELETED]
>>>>>>>>>>>>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>>>>>>>>>>>>
>>>>>>>>>>> 金子 雄一 <[E-MAIL ADDRESS DELETED]>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> Seasar-user mailing list
>>>>>>>>>>> [E-MAIL ADDRESS DELETED]
>>>>>>>>>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>>>>>>>>>
>>>>>>>>> 金子 雄一 <[E-MAIL ADDRESS DELETED]>
>>>>>>>>> _______________________________________________
>>>>>>>>> Seasar-user mailing list
>>>>>>>>> [E-MAIL ADDRESS DELETED]
>>>>>>>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>>>>>>>
>>>>>>> 金子 雄一 <[E-MAIL ADDRESS DELETED]>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Seasar-user mailing list
>>>>>>> [E-MAIL ADDRESS DELETED]
>>>>>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>>>>>
>>>
>>> 金子 雄一 <[E-MAIL ADDRESS DELETED]>
>>> _______________________________________________
>>> Seasar-user mailing list
>>> [E-MAIL ADDRESS DELETED]
>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>>
>>
>>
>
>
> --
> ◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆
> 株式会社プラスサム
> 金子　雄一  Yuichi Kaneko
> ■本社：〒330-0074
> 埼玉県さいたま市浦和区北浦和3-5-16-4F
> Tel: 048-830-0077　Fax: 048-830-0076
> ■開発本部：〒330-0802
> 埼玉県さいたま市大宮区宮町1-71-5F
> Tel: 048-793-7317　Fax: 048-793-7317
> E-mail : [E-MAIL ADDRESS DELETED]
> http://www.plus-sum.co.jp/
> ◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>

Seasar-user メーリングリストの案内