[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-11-27 Thread Satt Iqbal
thank you its work... my problem was solved. so I need to completed the *.jar file with 5.5.5 version, include lucene-analyzer-common, queryparser. my problem doesnt solved If we follow the Instruction in the official website of H2database. thank you for the help. thank you for the

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-11-26 Thread Evgenij Ryazanov
Unfortunately, you need to recompile H2 with your version of Lucene, or use Lucene 5.5.5. 1.4.200 was source compatible, but binary incompatible with more recent versions. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-11-26 Thread Satt Iqbal
I have the same problem. I Used H2 2019 03 13, Lucene-core-8.0.0.jar, Lucene-analyzer-common-8.0.0.jar, and Lucene-queryparser-8.0.0.jar in my CLASSPATH variable. the Error Message still show On Wednesday, October 16, 2019 at 10:11:43 AM UTC+7, Bengui Xie wrote: > > Run scripts below in H2

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-16 Thread Bengui Xie
Yes. 5.5.5 is normal. On Wednesday, October 16, 2019 at 4:37:56 PM UTC+8, Evgenij Ryazanov wrote: > > The situation is even worse, the binary compatibility with 6 is broken too. > > So you need to use 5.5.5 (it was used for compilation of official release > of H2 1.4.200), or you can build H2

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-16 Thread Evgenij Ryazanov
The situation is even worse, the binary compatibility with 6 is broken too. So you need to use 5.5.5 (it was used for compilation of official release of H2 1.4.200), or you can build H2 from its current sources if you definitely need a newer version of Lucene for a some reason. -- You

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-16 Thread Bengui Xie
Return to Lucene 6.6.6. I get this: CALL FTL_CREATE_INDEX('PUBLIC', 'TEST', 'FIRST_NAME,LAST_NAME'); Exception calling user-defined function: "createIndex(conn2: url=jdbc:default:connection user=SA, PUBLIC, TEST, FIRST_NAME,LAST_NAME): org.apache.lucene.index.IndexWriter.commit()V"; SQL

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-16 Thread Evgenij Ryazanov
Oh, I see. We definitely have a problem. Try some older version of Lucene such as 6.6.*. 7.0.0 and newer versions are source compatible but binary incompatible, if you need them, you need to recompile H2 with that version. I'll try to fix the binary compatibility for a next version of H2. I

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-16 Thread Bengui Xie
I'm sure that all lucene-related jars are in the classpath. Stack trace is below. But I don't know how to figure it. CALL FTL_CREATE_INDEX('PUBLIC', 'TEST', 'FIRST_NAME,LAST_NAME'); Error creating or initializing trigger "FTL_TEST" object, class

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-15 Thread Evgenij Ryazanov
Hello. I cannot reproduce this issue with Lucene 7.7.1 and Lucene 8.0.0. I can test 7.7.2 and 8.2.0 too, but I don't think that results will be different. You need to click on the error message to see the complete stack trace, it could describe the situation better. Most likely you don't

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-15 Thread Bengui Xie
and if call FTL_CREATE_INDEX with NULL, then got CALL FTL_CREATE_INDEX('PUBLIC', 'TEST',NULL); Error creating or initializing trigger "FTL_TEST" object, class "org.h2.fulltext.FullTextLucene$FullTextTrigger", cause: "java.lang.reflect.InvocationTargetException"; see root cause for details; SQL