You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by ahammad <ah...@gmail.com> on 2009/04/28 21:32:16 UTC
Importing data from Sybase
Hello,
I'm trying to index data from a Sybase DB, but when I attempt to do a full
import, it fails. This is in the log:
SEVERE: Full Import failed
org.apache.solr.handler.dataimport.DataImportHandlerException:
java.lang.AbstractMethodError:
com.sybase.jdbc2.jdbc.SybConnection.setHoldability(I)V
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:221)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:164)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:312)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:370)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:351)
Caused by: java.lang.AbstractMethodError:
com.sybase.jdbc2.jdbc.SybConnection.setHoldability(I)V
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:181)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:361)
at
org.apache.solr.handler.dataimport.JdbcDataSource.access$300(JdbcDataSource.java:38)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:237)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:207)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:335)
This seems to me like a Sybase issue but I'm unsure. Is Solr designed to be
compatible with Sybase or has it had issues in the past?
My data-config.xml file is pretty much the same as the one I have for an
Oracle DB, except with the appropriate changes made to
driver/url/user/password fields.
Cheers
--
View this message in context: http://www.nabble.com/Importing-data-from-Sybase-tp23284464p23284464.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Importing data from Sybase
Posted by Bryan Talbot <bt...@aeriagames.com>.
Holdability is a JDBC 3.0 feature -- maybe that database driver is old
and doesn't support JDBC 3.0? I see from the stack trace that jdbc2
is in the package name ...
-Bryan
On Apr 28, 2009, at Apr 28, 12:32 PM, ahammad wrote:
>
> Hello,
>
> I'm trying to index data from a Sybase DB, but when I attempt to do
> a full
> import, it fails. This is in the log:
>
> SEVERE: Full Import failed
> org.apache.solr.handler.dataimport.DataImportHandlerException:
> java.lang.AbstractMethodError:
> com.sybase.jdbc2.jdbc.SybConnection.setHoldability(I)V
> at
> org
> .apache
> .solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
> at
> org
> .apache
> .solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:221)
> at
> org
> .apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:
> 164)
> at
> org
> .apache
> .solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:
> 312)
> at
> org
> .apache
> .solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:370)
> at
> org.apache.solr.handler.dataimport.DataImporter
> $1.run(DataImporter.java:351)
> Caused by: java.lang.AbstractMethodError:
> com.sybase.jdbc2.jdbc.SybConnection.setHoldability(I)V
> at
> org.apache.solr.handler.dataimport.JdbcDataSource
> $1.call(JdbcDataSource.java:181)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource
> $1.call(JdbcDataSource.java:127)
> at
> org
> .apache
> .solr
> .handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:
> 361)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource.access
> $300(JdbcDataSource.java:38)
> at
> org.apache.solr.handler.dataimport.JdbcDataSource
> $ResultSetIterator.<init>(JdbcDataSource.java:237)
> at
> org
> .apache
> .solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:
> 207)
> at
> org
> .apache
> .solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:
> 38)
> at
> org
> .apache
> .solr
> .handler
> .dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58)
> at
> org
> .apache
> .solr
> .handler
> .dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
> at
> org
> .apache
> .solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:335)
>
>
> This seems to me like a Sybase issue but I'm unsure. Is Solr
> designed to be
> compatible with Sybase or has it had issues in the past?
>
> My data-config.xml file is pretty much the same as the one I have
> for an
> Oracle DB, except with the appropriate changes made to
> driver/url/user/password fields.
>
> Cheers
> --
> View this message in context: http://www.nabble.com/Importing-data-from-Sybase-tp23284464p23284464.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>