HI
I made that change of quotes and case sensitivity. But now i am getting the
below exception while running delta-import:
Document # 1
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:186)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:143)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:43)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:74)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:285)
at
org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:211)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:133)
at
org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:359)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:388)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:377)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously
defined
at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:179)
... 10 more
13:48:22,538 ERROR [STDERR] 23 Feb, 2009 1:48:22 PM
org.apache.solr.handler.dataimport.DataImporter doDeltaImport
SEVERE: Delta Import Failed
Also i tried replacing deltaQuery with deltaImportQuery. This is not
throwing any exception but not updating the index also. I have put the same
query that is used in full import to do the delta import.
Thanks
con
Shalin Shekhar Mangar wrote:
>
> 1. There is no closing quote in transformer="TemplateTransformer
> 2. Attribute names are case-sensitive so it should be deltaQuery instead
> of
> deltaquery
>
> On Fri, Feb 20, 2009 at 6:48 PM, con <[email protected]> wrote:
>
>>
>> Hi alll
>>
>> I am trying to run delta-import. For this I am having the below
>> data-config.xml
>>
>> <dataConfig>
>> <dataSource type="JdbcDataSource"
>> driver="oracle.jdbc.driver.OracleDriver"
>> url="*******" user="****" password="*********"/>
>> <document>
>> <entity name="users"
>> transformer="TemplateTransformer pk="USER_ID"
>> query="select USERS.USER_ID, USERS.USER_NAME,
>> USERS.CREATED_TIMESTAMP
>> FROM USERS, CUSTOMERS where USERS.USER_ID = CUSTOMERS.USER_ID"
>>
>> deltaquery="select USERS.USER_ID, USERS.USER_NAME,
>> USERS.CREATED_TIMESTAMP FROM USERS, CUSTOMERS where USERS.USER_ID =
>> CUSTOMERS.USER_ID" >
>> <field column="rowtype" template="users"
>> />
>> </entity>
>> </document>
>> </dataConfig>
>>
>> But nothing is happening when i call
>> http://localhost:8080/solr/users/dataimport?command=delta-import. Whereas
>> the dataimport.properties is getting updated with the time at which
>> delta-import is run.
>>
>> Where as
>> http://localhost:8080/solr/users/dataimport?command=full-importis
>> properly inserting data.
>>
>> Can anybody suggest what is wrong with this configuration.
>>
>> Thanks
>> con
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/delta-import-not-giving-updated-records-tp22120184p22120184.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
>
--
View this message in context:
http://www.nabble.com/delta-import-not-giving-updated-records-tp22120184p22157367.html
Sent from the Solr - User mailing list archive at Nabble.com.
