You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by jayakeerthi s <ma...@gmail.com> on 2009/06/10 01:25:16 UTC
Problem using db-data-config.xml
Hi All,
I am facing an issue while fetching the records from database by providing
the value" '${prod.prod_cd}' " in this type at db-data-config.xml.
It is working fine If I provide the exact value of the product code ie
'302437-413'
Here is the db-data-config.xm I am using
<dataConfig>
<dataSource type="JdbcDataSource" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@*********:1521:****" user="lslsls"
password="*******"/>
<document name="products">
<entity name="prod" pk="prod_id" query="SELECT p.prod_id,
p.prod_cd,
ps.styl_cd,
p.colr_disp_cd,
p.colr_comb_desc,
p.div_id,
p.po_grid_desc,
p.silo_id,
p.silh_id,
psa.sport_acty_desc,
pga.gndr_age_desc,
psh.silh_desc,
pso.silo_desc,
od.org_lgcy_div_cd,
greatest (
nvl(p.last_mod_dt,sysdate-9999),
nvl(ps.last_mod_dt,sysdate-9999),
nvl(od.last_mod_dt,sysdate-9999),
nvl(psa.last_mod_dt,sysdate-9999),
nvl(pga.last_mod_dt,sysdate-9999),
nvl(psh.last_mod_dt,sysdate-9999),
nvl(pso.last_mod_dt,sysdate-9999)
) last_mod_dt
FROM prod p
INNER JOIN prod_styl ps ON p.prod_styl_id = ps.prod_styl_id
INNER JOIN org_div od ON p.div_id = od.div_id
LEFT OUTER JOIN prod_sport_acty psa ON p.sport_acty_id =
psa.sport_acty_id
LEFT OUTER JOIN prod_gndr_age pga ON p.gndr_age_id = pga.gndr_age_id
LEFT OUTER JOIN prod_silh psh ON p.silh_id = psh.silh_id
LEFT OUTER JOIN prod_silo pso ON p.silo_id = pso.silo_id
WHERE nvl(od.stat,'A') = 'A'
AND nvl(psa.stat,'A') = 'A'
AND nvl(pga.stat,'A') = 'A'
AND nvl(psh.stat,'A') = 'A'
AND nvl(pso.stat,'A') = 'A'">
AND p.prod_cd = '302437-413'">
<field column="prod_id" name="prod_id"/>
<field column="prod_cd" name="prod_cd"/>
<field column="styl_cd" name="styl_cd"/>
<field column="colr_disp_cd" name="colr_disp_cd"/>
<field column="colr_comb_desc" name="colr_comb_desc"/>
<field column="div_id" name="div_id"/>
<field column="po_grid_desc" name="po_grid_desc"/>
<field column="silo_id" name="silo_id"/>
<field column="sport_acty_desc" name="sport_acty_desc"/>
<field column="silh_id" name="silh_id"/>
<field column="gndr_age_desc" name="gndr_age_desc"/>
<field column="silh_desc" name="silh_desc"/>
<field column="silo_desc" name="silo_desc"/>
<field column="org_lgcy_div_cd" name="org_lgcy_div_cd"/>
<entity name="prod_reg" query="SELECT pr.prod_id,
pr.prod_cd,
pr.reg_id,
pr.retl_pr_amt,
pr.whsle_pr_amt,
pr.retl_crcy_id,
pr.whsle_crcy_id,
pr.frst_prod_offr_dt,
pr.end_ftr_offr_dt,
pr.last_mod_dt last_mod_dt
FROM prod_reg pr
WHERE prod_cd =* '${prod.prod_cd}' ">
*
<field column="retl_pr_amt" name="retl_pr_amt"/>
<field column="whsle_pr_amt" name="whsle_pr_amt"/>
<field column="retl_crcy_id" name="retl_crcy_id"/>
<field column="whsle_crcy_id" name="whsle_crcy_id"/>
<field column="frst_prod_offr_dt"
name="frst_prod_offr_dt"/>
<field column="end_ftr_offr_dt" name="end_ftr_offr_dt"/>
<field column="last_mod_dt" name="last_mod_dt"/>
<entity name="prod_reg_cmrc_styl" query="SELECT p.prod_id,
p.prod_cd,
pr.reg_id,
prcs.sap_lang_id,
prcs.reg_cmrc_styl_nm,
prcs.insm_desc,
prcs.otsm_desc,
prcs.dim_desc,
prcs.prfl_desc,
prcs.upr_desc,
prcs.mdsl_desc,
prcs.outsl_desc,
prcs.ctnt_desc,
prcs.size_run_desc,
greatest (
nvl(p.last_mod_dt,sysdate-9999),
nvl(ps.last_mod_dt,sysdate-9999),
nvl(pr.last_mod_dt,sysdate-9999),
nvl(prcs.last_mod_dt,sysdate-9999)
) last_mod_dt
FROM prod p
INNER JOIN prod_styl ps ON p.prod_styl_id = ps.prod_styl_id
INNER JOIN prod_reg pr ON p.prod_id = pr.prod_id
INNER JOIN prod_reg_cmrc_styl prcs ON prcs.prod_styl_id = ps.prod_styl_id
AND prcs.reg_id = pr.reg_id
WHERE prcs.stat_cd = 'A'
*AND prod_cd ='${prod.prod_cd}'
AND reg_id = '${prod_reg.reg_id'">
*
<field column="sap_lang_id" name="sap_lang_id"/>
<field column="reg_cmrc_styl_nm"
name="reg_cmrc_styl_nm"/>
<field column="insm_desc" name="insm_desc"/>
<field column="otsm_desc" name="otsm_desc"/>
<field column="dim_desc" name="dim_desc"/>
<field column="prfl_desc" name="prfl_desc"/>
<field column="upr_desc" name="upr_desc"/>
<field column="mdsl_desc" name="mdsl_desc"/>
<field column="outsl_desc" name="outsl_desc"/>
<field column="ctnt_desc" name="ctnt_desc"/>
<field column="size_run_desc" name="size_run_desc"/>
</entity>
</entity>
</entity>
</document>
</dataConfig>
The issue is IF I replace the *AND prod_cd ='${prod.prod_cd}' AND reg_id =
'${prod_reg.reg_id'">* with the exact value '302437-413' I am getting the
result If not it is not
executing the prod_reg and prod_reg_cmrc_styl entity.
Please advise anything I am missing in the above db-data-config.xml.
Thanks in advance.
Regards,
Jayakeerthi
Re: Problem using db-data-config.xml
Posted by jayakeerthi s <ma...@gmail.com>.
Many thanks for the information Nobel and Shalin
One more query.
I Configured indexing by using DIH
1)one full query in one Entity
2)splitting the queries into Entities
1) for One single Query in the data-config.xml this is the stats.
*Documents Count* *Time taken* *CPU%* *Memory* *Index Size* 1
million
0:36:43
49-55%
89,236 k
645 MB
2) For Splitting the query into Entity the stats came as
*Documents Count* *Time taken* *CPU%* *Memory* *Index Size* 1 million
2:36:43
35-45%
61,236 k
119 MB
Total Fields Indexed : 22 fields
Document Size : ~150kb
System Config Used :
Processor :Core 2 Duo Processor 3 Ghz
OS :Win XP Professional
RAM :3 GB
The time taken and the size of the index found lot of difference. Please
advise why the diference is and let me know IF any further config changes to
be needed....I have attached the schema.xml
Please advise....thanks in advance.
regards,
Jayakeerthi
On Wed, Jun 10, 2009 at 11:02 PM, Shalin Shekhar Mangar <
shalinmangar@gmail.com> wrote:
> On Thu, Jun 11, 2009 at 2:41 AM, jayakeerthi s <mail2keerthi@gmail.com
> >wrote:
>
> > As displayed above....
> > <str name="*Total Requests made to DataSource*">*3739*</str>
> > * * <str name="*Total Rows Fetched*">*4135*</str>
> > * * <str name="*Total Documents Processed*">*1402*</str>
> >
> > are differing ....The request to the datasource is increasing ......and
> the
> > documents processed is less than the rows fetched....Please advise If I
> am
> > missing something here.
> >
> >
> You many entities, some of them nested within others. The rows is the count
> of number of rows retrieved for all entities but only the root-level
> entities create documents.
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
Re: Problem using db-data-config.xml
Posted by Shalin Shekhar Mangar <sh...@gmail.com>.
On Thu, Jun 11, 2009 at 2:41 AM, jayakeerthi s <ma...@gmail.com>wrote:
> As displayed above....
> <str name="*Total Requests made to DataSource*">*3739*</str>
> * * <str name="*Total Rows Fetched*">*4135*</str>
> * * <str name="*Total Documents Processed*">*1402*</str>
>
> are differing ....The request to the datasource is increasing ......and the
> documents processed is less than the rows fetched....Please advise If I am
> missing something here.
>
>
You many entities, some of them nested within others. The rows is the count
of number of rows retrieved for all entities but only the root-level
entities create documents.
--
Regards,
Shalin Shekhar Mangar.
Re: Problem using db-data-config.xml
Posted by jayakeerthi s <ma...@gmail.com>.
Many Thanks Noble the issue was with case of the field names.
After fixing that I am getting the response for the full-data import cmd as
*-* <http://localhost:8983/solr/dataimport?command=abort#> <lst name="*
initArgs*">
*-* <http://localhost:8983/solr/dataimport?command=abort#> <lst name="*
defaults*">
* * <str name="*config*">*
C:\apache-solr-nightly\example\example-DIH\solr\db\conf\db-data-config.xml*
</str>
* * </lst>
* * </lst>
* * <str name="*command*">*abort*</str>
* * <str name="*status*">*busy*</str>
* * <str name="*importResponse*" />
*-* <http://localhost:8983/solr/dataimport?command=abort#> <lst name="*
statusMessages*">
* * <str name="*Time Elapsed*">*0:3:55.861*</str>
* * <str name="*Total Requests made to DataSource*">*3739*</str>
* * <str name="*Total Rows Fetched*">*4135*</str>
* * <str name="*Total Documents Processed*">*1402*</str>
* * <str name="*Total Documents Skipped*">*0*</str>
* * <str name="*Full Dump Started*">*2009-06-10 13:54:22*</str>
* * </lst>
* * <str name="*WARNING*">*This response format is experimental. It is
likely to change in the future.*</str>
* * </response>
As displayed above....
<str name="*Total Requests made to DataSource*">*3739*</str>
* * <str name="*Total Rows Fetched*">*4135*</str>
* * <str name="*Total Documents Processed*">*1402*</str>
are differing ....The request to the datasource is increasing ......and the
documents processed is less than the rows fetched....Please advise If I am
missing something here.
I have attached the db-data-config.xml after modifying.
Thanks in advance,
jayakeerthi
2009/6/9 Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>
> are you sure prod_cd and reg_id\ are emitted by respective entities in
> the same name if not you may need to alias those fields (using as)
>
> keep in mind ,the field namkes are case sensitive. Just to know what
> are the values emitted use debug mode or use logTransformer
>
> On Wed, Jun 10, 2009 at 4:55 AM, jayakeerthi s<ma...@gmail.com>
> wrote:
> > Hi All,
> >
> > I am facing an issue while fetching the records from database by
> providing
> > the value" '${prod.prod_cd}' " in this type at db-data-config.xml.
> > It is working fine If I provide the exact value of the product code ie
> > '302437-413'
> >
> > Here is the db-data-config.xm I am using
> >
> > <dataConfig>
> > <dataSource type="JdbcDataSource"
> driver="oracle.jdbc.driver.OracleDriver"
> > url="jdbc:oracle:thin:@*********:1521:****" user="lslsls"
> > password="*******"/>
> >
> > <document name="products">
> > <entity name="prod" pk="prod_id" query="SELECT p.prod_id,
> > p.prod_cd,
> > ps.styl_cd,
> > p.colr_disp_cd,
> > p.colr_comb_desc,
> > p.div_id,
> > p.po_grid_desc,
> > p.silo_id,
> > p.silh_id,
> > psa.sport_acty_desc,
> > pga.gndr_age_desc,
> > psh.silh_desc,
> > pso.silo_desc,
> > od.org_lgcy_div_cd,
> > greatest (
> > nvl(p.last_mod_dt,sysdate-9999),
> > nvl(ps.last_mod_dt,sysdate-9999),
> > nvl(od.last_mod_dt,sysdate-9999),
> > nvl(psa.last_mod_dt,sysdate-9999),
> > nvl(pga.last_mod_dt,sysdate-9999),
> > nvl(psh.last_mod_dt,sysdate-9999),
> > nvl(pso.last_mod_dt,sysdate-9999)
> > ) last_mod_dt
> > FROM prod p
> > INNER JOIN prod_styl ps ON p.prod_styl_id =
> ps.prod_styl_id
> > INNER JOIN org_div od ON p.div_id = od.div_id
> > LEFT OUTER JOIN prod_sport_acty psa ON p.sport_acty_id =
> > psa.sport_acty_id
> > LEFT OUTER JOIN prod_gndr_age pga ON p.gndr_age_id =
> pga.gndr_age_id
> > LEFT OUTER JOIN prod_silh psh ON p.silh_id = psh.silh_id
> > LEFT OUTER JOIN prod_silo pso ON p.silo_id = pso.silo_id
> > WHERE nvl(od.stat,'A') = 'A'
> > AND nvl(psa.stat,'A') = 'A'
> > AND nvl(pga.stat,'A') = 'A'
> > AND nvl(psh.stat,'A') = 'A'
> > AND nvl(pso.stat,'A') = 'A'">
> > AND p.prod_cd = '302437-413'">
> > <field column="prod_id" name="prod_id"/>
> > <field column="prod_cd" name="prod_cd"/>
> > <field column="styl_cd" name="styl_cd"/>
> > <field column="colr_disp_cd" name="colr_disp_cd"/>
> > <field column="colr_comb_desc" name="colr_comb_desc"/>
> > <field column="div_id" name="div_id"/>
> > <field column="po_grid_desc" name="po_grid_desc"/>
> > <field column="silo_id" name="silo_id"/>
> > <field column="sport_acty_desc" name="sport_acty_desc"/>
> > <field column="silh_id" name="silh_id"/>
> > <field column="gndr_age_desc" name="gndr_age_desc"/>
> > <field column="silh_desc" name="silh_desc"/>
> > <field column="silo_desc" name="silo_desc"/>
> > <field column="org_lgcy_div_cd" name="org_lgcy_div_cd"/>
> >
> >
> > <entity name="prod_reg" query="SELECT pr.prod_id,
> > pr.prod_cd,
> > pr.reg_id,
> > pr.retl_pr_amt,
> > pr.whsle_pr_amt,
> > pr.retl_crcy_id,
> > pr.whsle_crcy_id,
> > pr.frst_prod_offr_dt,
> > pr.end_ftr_offr_dt,
> > pr.last_mod_dt last_mod_dt
> > FROM prod_reg pr
> > WHERE prod_cd =* '${prod.prod_cd}' ">
> > *
> >
> > <field column="retl_pr_amt" name="retl_pr_amt"/>
> > <field column="whsle_pr_amt" name="whsle_pr_amt"/>
> > <field column="retl_crcy_id" name="retl_crcy_id"/>
> > <field column="whsle_crcy_id" name="whsle_crcy_id"/>
> > <field column="frst_prod_offr_dt"
> > name="frst_prod_offr_dt"/>
> > <field column="end_ftr_offr_dt" name="end_ftr_offr_dt"/>
> >
> > <field column="last_mod_dt" name="last_mod_dt"/>
> >
> >
> > <entity name="prod_reg_cmrc_styl" query="SELECT p.prod_id,
> > p.prod_cd,
> > pr.reg_id,
> > prcs.sap_lang_id,
> > prcs.reg_cmrc_styl_nm,
> > prcs.insm_desc,
> > prcs.otsm_desc,
> > prcs.dim_desc,
> > prcs.prfl_desc,
> > prcs.upr_desc,
> > prcs.mdsl_desc,
> > prcs.outsl_desc,
> > prcs.ctnt_desc,
> > prcs.size_run_desc,
> > greatest (
> > nvl(p.last_mod_dt,sysdate-9999),
> > nvl(ps.last_mod_dt,sysdate-9999),
> > nvl(pr.last_mod_dt,sysdate-9999),
> > nvl(prcs.last_mod_dt,sysdate-9999)
> > ) last_mod_dt
> > FROM prod p
> > INNER JOIN prod_styl ps ON p.prod_styl_id = ps.prod_styl_id
> > INNER JOIN prod_reg pr ON p.prod_id = pr.prod_id
> > INNER JOIN prod_reg_cmrc_styl prcs ON prcs.prod_styl_id = ps.prod_styl_id
> > AND prcs.reg_id = pr.reg_id
> > WHERE prcs.stat_cd = 'A'
> > *AND prod_cd ='${prod.prod_cd}'
> > AND reg_id = '${prod_reg.reg_id'">
> > *
> > <field column="sap_lang_id" name="sap_lang_id"/>
> > <field column="reg_cmrc_styl_nm"
> > name="reg_cmrc_styl_nm"/>
> > <field column="insm_desc" name="insm_desc"/>
> > <field column="otsm_desc" name="otsm_desc"/>
> >
> > <field column="dim_desc" name="dim_desc"/>
> > <field column="prfl_desc" name="prfl_desc"/>
> > <field column="upr_desc" name="upr_desc"/>
> >
> > <field column="mdsl_desc" name="mdsl_desc"/>
> > <field column="outsl_desc" name="outsl_desc"/>
> > <field column="ctnt_desc" name="ctnt_desc"/>
> > <field column="size_run_desc" name="size_run_desc"/>
> >
> >
> > </entity>
> > </entity>
> > </entity>
> > </document>
> > </dataConfig>
> >
> >
> > The issue is IF I replace the *AND prod_cd ='${prod.prod_cd}' AND
> reg_id =
> > '${prod_reg.reg_id'">* with the exact value '302437-413' I am getting the
> > result If not it is not
> > executing the prod_reg and prod_reg_cmrc_styl entity.
> >
> > Please advise anything I am missing in the above db-data-config.xml.
> >
> > Thanks in advance.
> >
> > Regards,
> > Jayakeerthi
> >
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
Re: Problem using db-data-config.xml
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
are you sure prod_cd and reg_id\ are emitted by respective entities in
the same name if not you may need to alias those fields (using as)
keep in mind ,the field namkes are case sensitive. Just to know what
are the values emitted use debug mode or use logTransformer
On Wed, Jun 10, 2009 at 4:55 AM, jayakeerthi s<ma...@gmail.com> wrote:
> Hi All,
>
> I am facing an issue while fetching the records from database by providing
> the value" '${prod.prod_cd}' " in this type at db-data-config.xml.
> It is working fine If I provide the exact value of the product code ie
> '302437-413'
>
> Here is the db-data-config.xm I am using
>
> <dataConfig>
> <dataSource type="JdbcDataSource" driver="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@*********:1521:****" user="lslsls"
> password="*******"/>
>
> <document name="products">
> <entity name="prod" pk="prod_id" query="SELECT p.prod_id,
> p.prod_cd,
> ps.styl_cd,
> p.colr_disp_cd,
> p.colr_comb_desc,
> p.div_id,
> p.po_grid_desc,
> p.silo_id,
> p.silh_id,
> psa.sport_acty_desc,
> pga.gndr_age_desc,
> psh.silh_desc,
> pso.silo_desc,
> od.org_lgcy_div_cd,
> greatest (
> nvl(p.last_mod_dt,sysdate-9999),
> nvl(ps.last_mod_dt,sysdate-9999),
> nvl(od.last_mod_dt,sysdate-9999),
> nvl(psa.last_mod_dt,sysdate-9999),
> nvl(pga.last_mod_dt,sysdate-9999),
> nvl(psh.last_mod_dt,sysdate-9999),
> nvl(pso.last_mod_dt,sysdate-9999)
> ) last_mod_dt
> FROM prod p
> INNER JOIN prod_styl ps ON p.prod_styl_id = ps.prod_styl_id
> INNER JOIN org_div od ON p.div_id = od.div_id
> LEFT OUTER JOIN prod_sport_acty psa ON p.sport_acty_id =
> psa.sport_acty_id
> LEFT OUTER JOIN prod_gndr_age pga ON p.gndr_age_id = pga.gndr_age_id
> LEFT OUTER JOIN prod_silh psh ON p.silh_id = psh.silh_id
> LEFT OUTER JOIN prod_silo pso ON p.silo_id = pso.silo_id
> WHERE nvl(od.stat,'A') = 'A'
> AND nvl(psa.stat,'A') = 'A'
> AND nvl(pga.stat,'A') = 'A'
> AND nvl(psh.stat,'A') = 'A'
> AND nvl(pso.stat,'A') = 'A'">
> AND p.prod_cd = '302437-413'">
> <field column="prod_id" name="prod_id"/>
> <field column="prod_cd" name="prod_cd"/>
> <field column="styl_cd" name="styl_cd"/>
> <field column="colr_disp_cd" name="colr_disp_cd"/>
> <field column="colr_comb_desc" name="colr_comb_desc"/>
> <field column="div_id" name="div_id"/>
> <field column="po_grid_desc" name="po_grid_desc"/>
> <field column="silo_id" name="silo_id"/>
> <field column="sport_acty_desc" name="sport_acty_desc"/>
> <field column="silh_id" name="silh_id"/>
> <field column="gndr_age_desc" name="gndr_age_desc"/>
> <field column="silh_desc" name="silh_desc"/>
> <field column="silo_desc" name="silo_desc"/>
> <field column="org_lgcy_div_cd" name="org_lgcy_div_cd"/>
>
>
> <entity name="prod_reg" query="SELECT pr.prod_id,
> pr.prod_cd,
> pr.reg_id,
> pr.retl_pr_amt,
> pr.whsle_pr_amt,
> pr.retl_crcy_id,
> pr.whsle_crcy_id,
> pr.frst_prod_offr_dt,
> pr.end_ftr_offr_dt,
> pr.last_mod_dt last_mod_dt
> FROM prod_reg pr
> WHERE prod_cd =* '${prod.prod_cd}' ">
> *
>
> <field column="retl_pr_amt" name="retl_pr_amt"/>
> <field column="whsle_pr_amt" name="whsle_pr_amt"/>
> <field column="retl_crcy_id" name="retl_crcy_id"/>
> <field column="whsle_crcy_id" name="whsle_crcy_id"/>
> <field column="frst_prod_offr_dt"
> name="frst_prod_offr_dt"/>
> <field column="end_ftr_offr_dt" name="end_ftr_offr_dt"/>
>
> <field column="last_mod_dt" name="last_mod_dt"/>
>
>
> <entity name="prod_reg_cmrc_styl" query="SELECT p.prod_id,
> p.prod_cd,
> pr.reg_id,
> prcs.sap_lang_id,
> prcs.reg_cmrc_styl_nm,
> prcs.insm_desc,
> prcs.otsm_desc,
> prcs.dim_desc,
> prcs.prfl_desc,
> prcs.upr_desc,
> prcs.mdsl_desc,
> prcs.outsl_desc,
> prcs.ctnt_desc,
> prcs.size_run_desc,
> greatest (
> nvl(p.last_mod_dt,sysdate-9999),
> nvl(ps.last_mod_dt,sysdate-9999),
> nvl(pr.last_mod_dt,sysdate-9999),
> nvl(prcs.last_mod_dt,sysdate-9999)
> ) last_mod_dt
> FROM prod p
> INNER JOIN prod_styl ps ON p.prod_styl_id = ps.prod_styl_id
> INNER JOIN prod_reg pr ON p.prod_id = pr.prod_id
> INNER JOIN prod_reg_cmrc_styl prcs ON prcs.prod_styl_id = ps.prod_styl_id
> AND prcs.reg_id = pr.reg_id
> WHERE prcs.stat_cd = 'A'
> *AND prod_cd ='${prod.prod_cd}'
> AND reg_id = '${prod_reg.reg_id'">
> *
> <field column="sap_lang_id" name="sap_lang_id"/>
> <field column="reg_cmrc_styl_nm"
> name="reg_cmrc_styl_nm"/>
> <field column="insm_desc" name="insm_desc"/>
> <field column="otsm_desc" name="otsm_desc"/>
>
> <field column="dim_desc" name="dim_desc"/>
> <field column="prfl_desc" name="prfl_desc"/>
> <field column="upr_desc" name="upr_desc"/>
>
> <field column="mdsl_desc" name="mdsl_desc"/>
> <field column="outsl_desc" name="outsl_desc"/>
> <field column="ctnt_desc" name="ctnt_desc"/>
> <field column="size_run_desc" name="size_run_desc"/>
>
>
> </entity>
> </entity>
> </entity>
> </document>
> </dataConfig>
>
>
> The issue is IF I replace the *AND prod_cd ='${prod.prod_cd}' AND reg_id =
> '${prod_reg.reg_id'">* with the exact value '302437-413' I am getting the
> result If not it is not
> executing the prod_reg and prod_reg_cmrc_styl entity.
>
> Please advise anything I am missing in the above db-data-config.xml.
>
> Thanks in advance.
>
> Regards,
> Jayakeerthi
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com