Hi,
I am trying to use Lucene with in-memory option and I am getting an
exception
org.h2.jdbc.JdbcSQLException: Error while indexing document; SQL
statement:
CALL FTL_INIT() [0-142]
at org.h2.message.DbException.addSQL(DbException.java:122)
~[h2-1.2.142.jar:1.2.142]
at org.h2.command.Command.executeUpdate(Command.java:223)
~[h2-1.2.142.jar:1.2.142]
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:
124) ~[h2-1.2.142.jar:1.2.142]
at org.h2.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:628)
~[h2-1.2.142.jar:1.2.142]
at org.springframework.jdbc.core.JdbcTemplate
$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:535)
[org.springframework.jdbc.jar:3.0.3.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate
$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:1)
[org.springframework.jdbc.jar:3.0.3.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
395) [org.springframework.jdbc.jar:3.0.3.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:
554) [org.springframework.jdbc.jar:3.0.3.RELEASE]
at
ied.mssi.cache.InstrumentCacheMgr.buildIndex(InstrumentCacheMgr.java:
102) [classes/:na]
at
ied.mssi.cache.InstrumentCacheMgr.loadCache(InstrumentCacheMgr.java:
132) [classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:na]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:
1536) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:
1477) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:
1409) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:
519) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:
456) [org.springframework.beans.jar:3.0.3.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:291)
[org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:
222) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
288) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
190) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:
574) [org.springframework.beans.jar:3.0.3.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:
895) [org.springframework.context.jar:3.0.3.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:
425) [org.springframework.context.jar:3.0.3.RELEASE]
at msjava.base.application.SpringMain.run(SpringMain.java:112)
[msjava_base.jar:3.3]
at msjava.base.application.SpringMain.run(SpringMain.java:93)
[msjava_base.jar:3.3]
at msjava.base.application.SpringMain.main(SpringMain.java:135)
[msjava_base.jar:3.3]
Caused by: java.sql.SQLException: Error while indexing document
at
org.h2.fulltext.FullTextLucene.convertException(FullTextLucene.java:
230) ~[h2-1.2.142.jar:1.2.142]
at org.h2.fulltext.FullTextLucene.init(FullTextLucene.java:113)
~[h2-1.2.142.jar:1.2.142]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:na]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
at org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:
383) ~[h2-1.2.142.jar:1.2.142]
at org.h2.expression.JavaFunction.getValue(JavaFunction.java:38)
~[h2-1.2.142.jar:1.2.142]
at org.h2.command.dml.Call.update(Call.java:43) ~[h2-1.2.142.jar:
1.2.142]
at org.h2.command.CommandContainer.update(CommandContainer.java:70)
~[h2-1.2.142.jar:1.2.142]
at org.h2.command.Command.executeUpdate(Command.java:199)
~[h2-1.2.142.jar:1.2.142]
... 27 common frames omitted
Caused by: java.sql.SQLException: Fulltext search for in-memory
databases is not supported.
at org.h2.fulltext.FullText.throwException(FullText.java:1037)
~[h2-1.2.142.jar:1.2.142]
at org.h2.fulltext.FullTextLucene.getIndexPath(FullTextLucene.java:
311) ~[h2-1.2.142.jar:1.2.142]
at org.h2.fulltext.FullTextLucene.getIndexAccess(FullTextLucene.java:
266) ~[h2-1.2.142.jar:1.2.142]
at org.h2.fulltext.FullTextLucene.init(FullTextLucene.java:111)
~[h2-1.2.142.jar:1.2.142]
... 36 common frames omitted
Config details:
<bean id="h2DB"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="org.h2.Driver" />
<property name="url"
value="jdbc:h2:mem:si;DB_CLOSE_DELAY=-1;TRACE_LEVEL_FILE=4" />
</bean>
SQL:
CREATE ALIAS IF NOT EXISTS FTL_INIT FOR
"org.h2.fulltext.FullTextLucene.init";
CALL FTL_INIT();
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
