Return-Path: 
 <esme-dev-return-570-apmail-incubator-esme-dev-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-esme-dev-archive@minotaur.apache.org
Received: (qmail 82830 invoked from network); 16 Mar 2009 16:01:40 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Mar 2009 16:01:40 -0000
Received: (qmail 24007 invoked by uid 500); 16 Mar 2009 16:01:40 -0000
Delivered-To: apmail-incubator-esme-dev-archive@incubator.apache.org
Received: (qmail 23964 invoked by uid 500); 16 Mar 2009 16:01:39 -0000
Mailing-List: contact esme-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:esme-dev-help@incubator.apache.org>
List-Unsubscribe: <mailto:esme-dev-unsubscribe@incubator.apache.org>
List-Post: <mailto:esme-dev@incubator.apache.org>
List-Id: <esme-dev.incubator.apache.org>
Reply-To: esme-dev@incubator.apache.org
Delivered-To: mailing list esme-dev@incubator.apache.org
Received: (qmail 23953 invoked by uid 99); 16 Mar 2009 16:01:39 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Mar 2009 09:01:39 -0700
X-ASF-Spam-Status: No, hits=-2.8 required=10.0
	tests=RCVD_IN_DNSWL_MED,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [194.138.12.131] (HELO mxs1.siemens.at) (194.138.12.131)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Mar 2009 16:01:29 +0000
Received: from vies1kbx.sie.siemens.at ([158.226.129.82])
	by mxs1.siemens.at  with ESMTP id n2GG17YP000403
	for <esme-dev@incubator.apache.org>; Mon, 16 Mar 2009 17:01:07 +0100
Received: from nets139a.ww300.siemens.net ([192.168.217.3])
	by vies1kbx.sie.siemens.at (8.12.11.20060308/8.12.1) with ESMTP id
 n2GG17Zk009397
	for <esme-dev@incubator.apache.org>; Mon, 16 Mar 2009 17:01:07 +0100
Received: from nets13ja.ww300.siemens.net ([158.226.250.79]) by
 nets139a.ww300.siemens.net with Microsoft SMTPSVC(6.0.3790.3959);
	 Mon, 16 Mar 2009 17:01:06 +0100
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Compass Integration - Exception
Date: Mon, 16 Mar 2009 17:01:05 +0100
Message-ID: 
 <30DB6ACF50A0A3439F39EFEB1C52E16607CBA169@nets13ja.ww300.siemens.net>
In-Reply-To: <f470f68e0903160752q4b165b42rbb9b4b65c2d8dfc8@mail.gmail.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Compass Integration - Exception
Thread-Index: AcmmRtkChw0J7SUUTMaOCKBEoamnqQAA/8Bg
References: <f470f68e0903160315v23f38bb3se5ef07141cf3e3e1@mail.gmail.com>
 <c7fc82820903160406s594a7f5bo7d06efa116357ae@mail.gmail.com>
 <30DB6ACF50A0A3439F39EFEB1C52E16607CB9F06@nets13ja.ww300.siemens.net>
 <f470f68e0903160752q4b165b42rbb9b4b65c2d8dfc8@mail.gmail.com>
From: "Hirsch, Richard" <richard.hirsch@siemens.com>
To: <esme-dev@incubator.apache.org>
X-OriginalArrivalTime: 16 Mar 2009 16:01:06.0271 (UTC)
 FILETIME=[69FF66F0:01C9A650]
X-purgate: clean
X-purgate: This mail is considered clean
X-purgate-type: clean
X-purgate-Ad: Checked for Spam by eleven - eXpurgate www.eXpurgate.net
X-purgate-ID: 149917::090316170107-0B9DABA0-30FB75E7/0-0/0-15
X-purgate-size: 4439/0
X-Virus-Checked: Checked by ClamAV on apache.org

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=3D"jdbc:stax://esmeapache?emulateLocators=3Dtrue"
                              username=3D"esmeapache" password=3D"xxxx"
                              driverClass=3D"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_ =3D =
?];
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_ =3D ?]; 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)