Ok so is there a way to explicitly specify the path for Lucene by using H2 in memory mode?
On Mar 23, 10:35 am, Thomas Mueller <[email protected]> wrote: > 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 > > athttp://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.
