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)
