Dear All,
I am user of H2 2019 -03-13.
I added lucene fulltext search to my windows 10 64 environtment in the
variable CLASSPATH with contain this file: lucene-core-8.0.0.jar,
lucene-analyzers-common-8.0.0.jar, and lucene-queryparser-8.0.0.jar.
The Command to initilize Lucene Fultext in my H2 Console are succeded to
compile.
command:
CREATE ALIAS IF NOT EXISTS FTL_INIT FOR
"org.h2.fulltext.FullTextLucene.init";
CALL FTL_INIT();
I was created the table and fill it with my data.
command:
CREATE TABLE TABLE_NAME(ID INT PRIMARY KEY, NAME VARCHAR);
INSERT INTO TABLE_NAME VALUES(1, 'Hello World');
But I have an error message when I create the index with this command:
CALL FTL_CREATE_INDEX('PUBLIC', 'TABLE_NAME', NULL);
This is the error message:
Error creating or initializing trigger "FTL_ULALA" object, class
"org.h2.fulltext.FullTextLucene$FullTextTrigger", cause:
"java.lang.reflect.InvocationTargetException"; see root cause for details;
SQL statement:
CREATE TRIGGER IF NOT EXISTS "PUBLIC"."FTL_ULALA" AFTER INSERT, UPDATE,
DELETE, ROLLBACK ON "PUBLIC"."ULALA" FOR EACH ROW CALL
"org.h2.fulltext.FullTextLucene$FullTextTrigger" [90043-199]
<http://192.168.2.26:8082/query.do?jsessionid=f107debd68f80040af87cef769fc2424#>
90043/90043 (Help)
<http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c90043>
What should I do to solve this problem?
Thanks For Attention,
Rgds,
Satt
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/c970182b-d73e-42c9-a4cd-7de7ad30671f%40googlegroups.com.
