I am using the full import option with the files as mentioned below:
*data-config.xml*
<dataConfig>
<dataSource driver="com.informix.jdbc.IfxDriver"
url="jdbc:informix-sqli://11.25.22.87:1526/cata_bis:INFORMIXSERVER=i_cer"
user="inmix"
password="kro3"/>
<document>
<entity name="item" query="SELECT nif, tipo_ent, tipo_dir FROM
cdt_empresas">
<field column="ID" name="nif" />
<field column="TIPO_ENT" name="tipo_ent" />
<field column="TIPO_DIR" name="tipo_dir" />
</entity>
</document>
</dataConfig>
*schema.xml*
...
<field name="id" type="string" indexed="true" stored="true" required="true"
/>
<field name="tipo_ent" type="string" indexed="true" stored="true"/>
<field name="tipo_dir" type="string" indexed="true" stored="true"/>
...
*solrconfig.xml*
<requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
<str name="config">data-config.xml</str>
</lst>
</requestHandler>
The query runs perfectly in informix but on running the full-import option I
am getting the error mentioned below:
0851data-config.xmlfull-importdebugSELECT nif ID, tipo_ent TIPO_ENT,
tipo_dir TIPO DIR FROM
cdt_empresasorg.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query: SELECT nif ID, tipo_ent TIPO_ENT, tipo_dir TIPO DIR
FROM cdt_empresas Processing Document # 1 at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39)
at
org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:188)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:238)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:596)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:268)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:187)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:359)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:427)
at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:206)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1372) at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326) at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: java.sql.SQLException: Transactions not supported at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373) at
com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1820) at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:172)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:128)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363)
at
org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
... 33 more 0:0:0.820idleConfiguration Re-loaded
sucessfully0:0:0.83510002012-04-12 11:46:46Indexing failed. Rolled back all
changes.2012-04-12 11:46:47This response format is experimental. It is
likely to change in the future.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Unable-to-execute-query-Transactions-not-supported-on-running-fullimport-tp3916529p3916529.html
Sent from the Solr - User mailing list archive at Nabble.com.
