incubator-esme-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hirsch, Richard" <richard.hir...@siemens.com>
Subject Compass Integration - Exception
Date Mon, 16 Mar 2009 16:01:05 GMT
Working on Compass integration via JDBC and I'm getting a strange error.

Does someone has had experience with compass and mysql.

<connection>
      <jdbc>
          <dataSourceProvider>
              <driverManager
url="jdbc:stax://esmeapache?emulateLocators=true"
                              username="esmeapache" password="xxxx"
                              driverClass="com.staxnet.jdbc.Driver" />
          </dataSourceProvider>
      </jdbc>

    </connection>

Caused by: org.compass.core.engine.SearchEngineException: Failed to
create index for sub index [message]; nested exception is
org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute sql
[select name_, 'value_' as x, size_ from index_message where name_ = ?];
nested exception is java.sql.SQLException: "pos" + "length" arguments
can not be larger than the BLOB's length.
	at
org.compass.core.lucene.engine.store.DefaultLuceneSearchEngineStore.crea
teIndex(DefaultLuceneSearchEngineStore.java:496)
	at
org.compass.core.lucene.engine.store.DefaultLuceneSearchEngineStore.veri
fyIndex(DefaultLuceneSearchEngineStore.java:532)
	at
org.compass.core.lucene.engine.store.DefaultLuceneSearchEngineStore.veri
fyIndex(DefaultLuceneSearchEngineStore.java:527)
	at
org.compass.core.lucene.engine.store.DefaultLuceneSearchEngineStore.veri
fyIndex(DefaultLuceneSearchEngineStore.java:519)
	at
org.compass.core.lucene.engine.manager.DefaultLuceneSearchEngineIndexMan
ager$4.doInTransaction(DefaultLuceneSearchEngineIndexManager.java:144)
	at
org.compass.core.lucene.engine.manager.DefaultLuceneSearchEngineIndexMan
ager$4.doInTransaction(DefaultLuceneSearchEngineIndexManager.java:142)
	at
org.compass.core.impl.DefaultCompass$CompassTransactionContext.execute(D
efaultCompass.java:349)
	at
org.compass.core.lucene.engine.manager.DefaultLuceneSearchEngineIndexMan
ager.verifyIndex(DefaultLuceneSearchEngineIndexManager.java:141)
	at
org.compass.core.impl.DefaultCompass.<init>(DefaultCompass.java:154)
	at
org.compass.core.impl.DefaultCompass.<init>(DefaultCompass.java:113)
	at
org.compass.core.impl.DefaultCompass.<init>(DefaultCompass.java:106)
	at
org.compass.core.config.CompassConfiguration.buildCompass(CompassConfigu
ration.java:285)
	at bootstrap.liftweb.Compass$.<init>(Boot.scala:152)
	at bootstrap.liftweb.Compass$.<clinit>(Boot.scala)
	... 72 more
Caused by: org.apache.lucene.store.jdbc.JdbcStoreException: Failed to
execute sql [select name_, 'value_' as x, size_ from index_message where
name_ = ?]; nested exception is java.sql.SQLException: "pos" + "length"
arguments can not be larger than the BLOB's length.
	at
org.apache.lucene.store.jdbc.support.JdbcTemplate.executeSelect(JdbcTemp
late.java:122)
	at
org.apache.lucene.store.jdbc.index.FetchOnBufferReadJdbcIndexInput.refil
l(FetchOnBufferReadJdbcIndexInput.java:58)
	at
org.apache.lucene.store.ConfigurableBufferedIndexInput.readByte(Configur
ableBufferedIndexInput.java:27)
	at
org.apache.lucene.store.ChecksumIndexInput.readByte(ChecksumIndexInput.j
ava:36)
	at
org.apache.lucene.store.IndexInput.readInt(IndexInput.java:68)
	at
org.apache.lucene.index.SegmentInfos.read(SegmentInfos.java:221)
	at
org.apache.lucene.index.IndexFileDeleter.<init>(IndexFileDeleter.java:17
5)
	at
org.apache.lucene.index.IndexWriter.init(IndexWriter.java:1093)
	at
org.apache.lucene.index.IndexWriter.<init>(IndexWriter.java:698)
	at
org.compass.core.lucene.engine.store.DefaultLuceneSearchEngineStore.crea
teIndex(DefaultLuceneSearchEngineStore.java:493)
	... 85 more
Caused by: java.sql.SQLException: "pos" + "length" arguments can not be
larger than the BLOB's length.
	at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
	at com.mysql.jdbc.Blob.getBytes(Blob.java:142)
	at
org.apache.lucene.store.jdbc.index.FetchOnBufferReadJdbcIndexInput.readI
nternal(FetchOnBufferReadJdbcIndexInput.java:132)
	at
org.apache.lucene.store.jdbc.index.FetchOnBufferReadJdbcIndexInput.acces
s$1400(FetchOnBufferReadJdbcIndexInput.java:35)
	at
org.apache.lucene.store.jdbc.index.FetchOnBufferReadJdbcIndexInput$1.exe
cute(FetchOnBufferReadJdbcIndexInput.java:91)
	at
org.apache.lucene.store.jdbc.support.JdbcTemplate.executeSelect(JdbcTemp
late.java:112)

Mime
View raw message