Hi, The error message is: "Fulltext search for in-memory databases is not supported."
The reason is there is no path to store the Lucene files. Regards, Thomas On Wed, Mar 23, 2011 at 6:17 AM, Sneha Shenoy <[email protected]> wrote: > 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. > > -- 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.
