lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "tamanjit.bindra@yahoo.co.in" <tamanjit.bin...@yahoo.co.in>
Subject Not getting data using concat in DIH
Date Wed, 06 Jul 2011 09:06:37 GMT
Hi all,

My data-import.xml looks like this:

<dataConfig>
	<dataSource driver="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://10.150.200.69:60000/livedb" user="property"
password="property" />
	
	<document name="articlePosting">
		<entity name="articleDetails" query="select 'A' concat cast(MBFARTRFNUM as
char(8)) as MBFARTUNIQUEKEY, MBFARTRFNUM, MBFARTUBIRFNUM, MBFARTCNDCATE,
MBFARTCNDCITY, MBFARTLMTRFNUM, MBFARTDESC, char(date(CREATEDATE)) as
CREATEDATE, time(CREATEDATE) as CREATETIME, char(date(LASTMODIDATE)) as
MODIDATE, time(LASTMODIDATE) as MODITIME, MBFARTVIEWED, MBFARTSNIPPET, 2 as
POPULARITYSORTCODE, 4 as RECENCYSORT, 1 as EXPERTADVICE, MBFARTTOPIC concat
' ' concat MBFARTSNIPPET concat ' ' concat MBFARTDESC concat ' ' concat ' '
concat cast(MBFARTCNDCATE as char(8)) as ADTEXT, 'Y' as EXPERTQUES, 'Y' as
EXPERTANS, MBFARTTOPIC, 'A' as CONTENTTYPE from MBFARTICLE where
upper(MBFARTISACTIVE) = 'Y'"
		deltaQuery="select 'A' concat cast(MBFARTRFNUM as char(8)) as
MBFARTUNIQUEKEY, MBFARTRFNUM, MBFARTUBIRFNUM, MBFARTCNDCATE, MBFARTCNDCITY,
MBFARTLMTRFNUM, MBFARTDESC, char(date(CREATEDATE)) as CREATEDATE,
time(CREATEDATE) as CREATETIME, char(date(LASTMODIDATE)) as MODIDATE,
time(LASTMODIDATE) as MODITIME, MBFARTVIEWED, MBFARTSNIPPET, 2 as
POPULARITYSORTCODE, 4 as RECENCYSORT, 1 as EXPERTADVICE, MBFARTTOPIC concat
' ' concat MBFARTSNIPPET concat ' ' concat MBFARTDESC concat ' ' concat ' '
concat cast(MBFARTCNDCATE as char(8)) as ADTEXT, 'Y' as EXPERTQUES, 'Y' as
EXPERTANS, MBFARTTOPIC, 'A' as CONTENTTYPE from MBFARTICLE where
upper(MBFARTISACTIVE) = 'Y' and
(CREATEDATE>='${dataimporter.last_index_time}' or
LASTMODIDATE>='${dataimporter.last_index_time}')">
			<field column="MBFARTUNIQUEKEY"			name="ukey" />
			<field column="MBFARTRFNUM"				name="id" />
			<field column="MBFARTUBIRFNUM"			name="oid" />
			<field column="MBFARTCNDCATE"			name="cg" />
			<field column="MBFARTCNDCITY"			name="ct" />
			<field column="MBFARTLMTRFNUM"			name="lt" />
			<field column="MBFARTDESC"				name="dtldesc" />
			<field column="CREATEDATE"				name="ppd" />
			<field column="CREATETIME"				name="ppt" />
			<field column="MODIDATE"				name="ecd" />
			<field column="MODITIME"				name="tmsrt" />
			<field column="MBFARTVIEWED"			name="viewcount" />
			<field column="MBFARTSNIPPET"			name="ansdesc" />
			<field column="POPULARITYSORTCODE"		name="popularsort" />
			<field column="RECENCYSORT"				name="recencysort" />
			<field column="EXPERTADVICE"			name="expadvice" />
			<field column="EXPERTQUES"				name="expertQues" />
			<field column="EXPERTANS"				name="expertAns" />
			<field column="MBFARTTOPIC"				name="topic" />
			<field column="CONTENTTYPE"				name="contentType" />
			<field column="ADTEXT"					name="ad_text" />

			<entity name="setOwnerName" query="select UBILOGIN from TPUBI where
UBIRFNUM=${articleDetails.MBFARTUBIRFNUM}">
				<field column="UBILOGIN"				name="oname" />
			</entity>

			
		</entity>
	</document>
</dataConfig>


This works fine.

But if I comment the line 

<field column="ADTEXT"					name="ad_text" />


and uncomment the following



It stops working. Does concat not work for fields??

Please help.

--
View this message in context: http://lucene.472066.n3.nabble.com/Not-getting-data-using-concat-in-DIH-tp3144006p3144006.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message