[Seasar-user:18140] Re: 【DBFlute】 Maven-DBFluteプラグインの複数DB設定について
金子 雄一
[E-MAIL ADDRESS DELETED]
2009年 7月 31日 (金) 13:41:58 JST
金子です。
> 試しに、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 メーリングリストの案内