Return-Path: Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: (qmail 70619 invoked from network); 10 Jun 2009 05:01:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Jun 2009 05:01:48 -0000 Received: (qmail 1022 invoked by uid 500); 10 Jun 2009 05:01:57 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 945 invoked by uid 500); 10 Jun 2009 05:01:57 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 935 invoked by uid 99); 10 Jun 2009 05:01:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jun 2009 05:01:57 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of noble.paul@gmail.com designates 209.85.198.238 as permitted sender) Received: from [209.85.198.238] (HELO rv-out-0506.google.com) (209.85.198.238) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jun 2009 05:01:49 +0000 Received: by rv-out-0506.google.com with SMTP id l9so197637rvb.5 for ; Tue, 09 Jun 2009 22:01:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:reply-to:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:content-type:content-transfer-encoding; bh=Gqz+SDMYqPRKwWoTXuh9s9vV28thCizq1PdVETt77VY=; b=ACoX7QA8xpJnOxXCClNNrT9Emz9Q4uxtuceZ+wlgfnzm1FLrQ/qNDlQvXV2h6i32k6 V7MpsJAQtfduYg1AR/fdrb2TX6KboV0VSX+g7qayYXuj+nfJ3JfF2cq6x7zMjibBw/oT +jTrigyboAWx9TbK1uf8R89inSvTTwPYvaaAA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:reply-to:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:content-type :content-transfer-encoding; b=hTd9KG6dAZrNYdUwWBoY1TdSr6hKfrH5yv2dY4SGhjUKO6YKnk34tpKDorbkyAw3Oo CMWmub6twkB3M6SK8nl/K6SPspzylDQQ1IlNcDP/Uyl9YzcIJlITF8048iUToaPGFwmF Fo2o3BXt1krnr7Sc9UKFHB2dvpOuPcKddboQo= MIME-Version: 1.0 Sender: noble.paul@gmail.com Reply-To: noble.paul@gmail.com Received: by 10.140.136.19 with SMTP id j19mr850773rvd.21.1244610089076; Tue, 09 Jun 2009 22:01:29 -0700 (PDT) In-Reply-To: References: From: =?UTF-8?B?Tm9ibGUgUGF1bCDgtKjgtYvgtKzgtL/gtLPgtY3igI0gIOCkqOCli+CkrOCljeCks+CljQ==?= Date: Wed, 10 Jun 2009 10:31:09 +0530 X-Google-Sender-Auth: 3f619c578dacf159 Message-ID: <5e76b0ad0906092201h2e9dd759y4b32a8ad39312133@mail.gmail.com> Subject: Re: Problem using db-data-config.xml To: solr-user@lucene.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org 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 wrot= e: > Hi All, > > I am facing an issue while fetching the records from database by providin= g > 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 > > > url=3D"jdbc:oracle:thin:@*********:1521:****" user=3D"lslsls" > password=3D"*******"/> > > =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0p.prod_cd, > =A0 =A0 =A0 =A0ps.styl_cd, > =A0 =A0 =A0 =A0p.colr_disp_cd, > =A0 =A0 =A0 =A0p.colr_comb_desc, > =A0 =A0 =A0 =A0p.div_id, > =A0 =A0 =A0 =A0p.po_grid_desc, > =A0 =A0 =A0 =A0p.silo_id, > =A0 =A0 =A0 =A0p.silh_id, > =A0 =A0 =A0 =A0psa.sport_acty_desc, > =A0 =A0 =A0 =A0pga.gndr_age_desc, > =A0 =A0 =A0 =A0psh.silh_desc, > =A0 =A0 =A0 =A0pso.silo_desc, > =A0 =A0 =A0 =A0od.org_lgcy_div_cd, > =A0 =A0 =A0 =A0greatest ( > =A0 =A0 =A0 =A0 =A0 nvl(p.last_mod_dt,sysdate-9999), > =A0 =A0 =A0 =A0 =A0 nvl(ps.last_mod_dt,sysdate-9999), > =A0 =A0 =A0 =A0 =A0 nvl(od.last_mod_dt,sysdate-9999), > =A0 =A0 =A0 =A0 =A0 nvl(psa.last_mod_dt,sysdate-9999), > =A0 =A0 =A0 =A0 =A0 nvl(pga.last_mod_dt,sysdate-9999), > =A0 =A0 =A0 =A0 =A0 nvl(psh.last_mod_dt,sysdate-9999), > =A0 =A0 =A0 =A0 =A0 nvl(pso.last_mod_dt,sysdate-9999) > =A0 =A0 =A0 =A0) last_mod_dt > =A0 =A0 FROM prod p > =A0 =A0 INNER JOIN prod_styl ps =A0 =A0 =A0 =A0 =A0 =A0 ON p.prod_styl_id= =3D ps.prod_styl_id > =A0 =A0 INNER JOIN org_div od =A0 =A0 =A0 =A0 =A0 =A0 =A0 ON p.div_id =3D= od.div_id > =A0 =A0 LEFT OUTER JOIN prod_sport_acty psa ON p.sport_acty_id =3D > psa.sport_acty_id > =A0 =A0 LEFT OUTER JOIN prod_gndr_age pga =A0 ON p.gndr_age_id =3D pga.gn= dr_age_id > =A0 =A0 LEFT OUTER JOIN prod_silh psh =A0 =A0 =A0 ON p.silh_id =3D psh.si= lh_id > =A0 =A0 LEFT OUTER JOIN prod_silo pso =A0 =A0 =A0 ON p.silo_id =3D pso.si= lo_id > =A0 =A0 WHERE nvl(od.stat,'A') =3D 'A' > =A0 =A0 =A0 AND nvl(psa.stat,'A') =3D 'A' > =A0 =A0 =A0 AND nvl(pga.stat,'A') =3D 'A' > =A0 =A0 =A0 AND nvl(psh.stat,'A') =3D 'A' > =A0 =A0 =A0 AND nvl(pso.stat,'A') =3D 'A'"> > =A0 =A0 =A0 =A0 =A0 =A0 =A0AND p.prod_cd =3D '302437-413'"> > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > > > =A0 =A0 =A0 =A0 pr.prod_cd, > =A0pr.reg_id, > =A0pr.retl_pr_amt, > =A0pr.whsle_pr_amt, > =A0 =A0 =A0 =A0 =A0pr.retl_crcy_id, > =A0pr.whsle_crcy_id, > =A0pr.frst_prod_offr_dt, > =A0pr.end_ftr_offr_dt, > =A0pr.last_mod_dt last_mod_dt > =A0FROM prod_reg pr > =A0WHERE prod_cd =3D* '${prod.prod_cd}' "> > * > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 name=3D"frst_prod_offr_dt"/> > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > > > =A0 =A0 p.prod_cd, > =A0 pr.reg_id, > =A0 prcs.sap_lang_id, > =A0 prcs.reg_cmrc_styl_nm, > =A0 prcs.insm_desc, > =A0 prcs.otsm_desc, > =A0 prcs.dim_desc, > =A0 prcs.prfl_desc, > =A0 prcs.upr_desc, > =A0 prcs.mdsl_desc, > =A0 prcs.outsl_desc, > =A0 prcs.ctnt_desc, > =A0 prcs.size_run_desc, > =A0 greatest ( > =A0 =A0 =A0nvl(p.last_mod_dt,sysdate-9999), > =A0 =A0 =A0nvl(ps.last_mod_dt,sysdate-9999), > =A0 =A0 =A0nvl(pr.last_mod_dt,sysdate-9999), > =A0 =A0 =A0nvl(prcs.last_mod_dt,sysdate-9999) > =A0 ) last_mod_dt > FROM prod p > INNER JOIN prod_styl ps =A0 =A0 =A0 =A0 =A0 =A0 ON p.prod_styl_id =3D ps.= prod_styl_id > INNER JOIN prod_reg pr =A0 =A0 =A0 =A0 =A0 =A0 =A0ON p.prod_id =3D pr.pro= d_id > INNER JOIN prod_reg_cmrc_styl prcs ON prcs.prod_styl_id =3D ps.prod_styl_= id > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 AND p= rcs.reg_id =3D pr.reg_id > WHERE prcs.stat_cd =3D 'A' > =A0*AND prod_cd =3D'${prod.prod_cd}' > =A0AND reg_id =3D '${prod_reg.reg_id'"> > * > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 name=3D"reg_cmrc_styl_nm"/> > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > > > =A0 =A0 > =A0 > =A0 > =A0 > =A0 > > > The issue is IF I replace the *AND prod_cd =3D'${prod.prod_cd}' =A0 AND r= eg_id =3D > '${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 > --=20 ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com