On Mon, Feb 23, 2009 at 2:09 PM, con <convo...@gmail.com> wrote: > > 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.
deltaImportQuery is not a replacement for deltaQuery both hast to be present. 'deltaQuery' identifies the changed rows and deltaImportQuery uses the values to import data > > 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 <convo...@gmail.com> 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. > > -- --Noble Paul