Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (nike.apache.org: domain of
 prvs=161154b5e0=pattabiraman.meenakshisundaram@aig.com designates
 167.230.202.35 as permitted sender)
From: "Pattabiraman, Meenakshisundaram"
	<Pattabiraman.Meenakshisundaram@aig.com>
To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
Subject: RE: XPathentity processor on CLOB field
Thread-Topic: XPathentity processor on CLOB field
Thread-Index: AdCpZr8S8OQ2GuuRQt2/UpdqVBVUhwAVX5Kg
Date: Thu, 18 Jun 2015 11:50:45 +0000
Message-ID: 
 <40A6BF1A1501954B86C6D1113FBF04AE41AFA67E@PWGSMSLIVMBS02.mail.aig.net>
References: 
 <40A6BF1A1501954B86C6D1113FBF04AE41AFA0E8@PWGSMSLIVMBS02.mail.aig.net>
In-Reply-To: 
 <40A6BF1A1501954B86C6D1113FBF04AE41AFA0E8@PWGSMSLIVMBS02.mail.aig.net>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0


This is the error cause reported.  I also see that it has been reported ear=
lier (http://mail-archives.apache.org/mod_mbox/lucene-solr-user/201103.mbox=
/%3CD0F0D26C-3AC0-4982-9E2B-09DC96937193@535consulting.com%3E) but could no=
t find a solution.


I am nesting the FieldReaderDataSource within the Entity definition that ha=
s a CLOB field. With this it fails only after transforming the clob.=20
If I do not nest, I get this error when the FieldReaderDataSource is initia=
lized thus failing even before the SQL is executed.
Either case, the error is happening at the same place.=20


Caused by: java.sql.SQLException: SQL statement to execute cannot be empty =
or null
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java=
:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112=
)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:1=
73)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:2=
29)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:4=
03)
	at oracle.jdbc.driver.OracleSql.initialize(OracleSql.java:110)
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java=
:1761)
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrappe=
r.java:298)
	at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<in=
it>(JdbcDataSource.java:314)
	... 14 more


Pattabi Meenakshisundaram


-----Original Message-----
From: Pattabiraman, Meenakshisundaram [mailto:Pattabiraman.Meenakshisundara=
m@aig.com]=20
Sent: Wednesday, June 17, 2015 9:33 PM
To: 'solr-user@lucene.apache.org'
Subject: XPathentity processor on CLOB field

My requirement is to read the XML from a CLOB field and parse it to get the=
 entity.

The data config is as shown below. I am trying to map two fields 'event' an=
d 'policyNumber' for the entity 'catreport'.


<dataSource name=3D"mbdev" driver=3D"oracle.jdbc.driver.OracleDriver" url=
=3D"jdbc:oracle:thin:@localhost:1521:orcl" user=3D"xyz" password=3D"xyz"/> =
<document name=3D"insight">
            <entity name=3D"input" query=3D"select * from test" logLevel=3D=
"debug" datasource=3D"mbdev" transformer=3D"ClobTransformer, script:toDate"=
>
            <field column=3D"LOAD_DATE" name=3D"load_date" />

            <field column=3D"RESPONSE_XML" name=3D"RESPONSE_XML" clob=3D"tr=
ue" /> <dataSource name=3D"xmldata" type=3D"FieldReaderDataSource"/>

            <entity name=3D"catReport" dataSource=3D"xmldata" dataField=3D"=
input.RESPONSE_XML" processor=3D"XPathEntityProcessor"  forEach=3D"/*:Decis=
ionServiceRs"  rootEntity=3D"true" logLevel=3D"debug">
                        <field column=3D"event" xpath=3D"/dec:DecisionServi=
ceRs/@event"/>


I am getting this error

....
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException: U=
nable to execute query: null Processing Document # 1
                at org.apache.solr.handler.dataimport.DataImportHandlerExce=
ption.wrapAndThrow(DataImportHandlerException.java:70)
                at org.apache.solr.handler.dataimport.JdbcDataSource$Result=
SetIterator.<init>(JdbcDataSource.java:321)
                at org.apache.solr.handler.dataimport.JdbcDataSource.getDat=
a(JdbcDataSource.java:278)
                at org.apache.solr.handler.dataimport.JdbcDataSource.getDat=
a(JdbcDataSource.java:53)
                at org.apache.solr.handler.dataimport.XPathEntityProcessor.=
initQuery(XPathEntityProcessor.java:283)
                at org.apache.solr.handler.dataimport.XPathEntityProcessor.=
fetchNextRow(XPathEntityProcessor.java:224)

I see that the Clob is getting converted to String correctly and the log ha=
s this entry where xml is printed Exception while processing: input documen=
t : SolrInputDocument(fields: [RESPONSE_XML=3D<dec:Deci....


I do not know why the error is thrown at Jdbc when the Clob is converted to=
 string and passed to the FieldReader and do not know how to make this work=
.

Thanks
Pattabi