Thanks a lot. It worked well with all the suggestions above.
But I still have some issues if you are able to help.
1. The indexes I created using the older versions don't seem to work
anymore. This is a problem since the database is already distributed to all
of our users.
Here "don't seem to work" means that I find no results after searching for
a keyword that I am sure exists among the data in the databases (and that
returned a lot of results before)
2. We are still considering sticking to the older version (1.3.160 with
lucene-core 3.4.0 for compatibility with all the users we have so far).
There are a few issues we have when using this version:
- the results returned seem to be very limited for example the query:
SELECT COUNT(*) FROM BURSUCUL.NORMA WHERE NORMADESCRIERE LIKE '%beton%'
returns about 2000, but
SELECT COUNT(*) FROM FTL_SEARCH_DATA("+beton", 0, 0)
returns about 70 results, although the column "NORMADESCRIERE" in
"BURSUCUL.NORMA" is indexed
- considering that, I tried to drop the indexes and recreate them but when
I do:
CALL FTL_CREATE_INDEX("BURSUCUL", "NORMA", "NORMACOD, NORMADESCRIERE")
i get:
Error: org.h2.jdbc.JdbcSQLException: Error creating or initializing trigger
"FTL_NORMA" object, class "org.h2.fulltext.
FullTextLucene$FullTextTrigger", cause: "java.sql.SQLException: Column not
found: NORMACOD"; see root cause for details; SQL statement:
CREATE
TRIGGER IF NOT EXISTS "BURSUCUL"."FTL_NORMA" AFTER INSERT, UPDATE,
DELETE, ROLLBACK ON "BURSUCUL"."NORMA" FOR EACH ROW CALL
"org.h2.fulltext.FullTextLucene$FullTextTrigger" [90043-160]
My first thought was that it must be a typo, but I checked a few times and
I know I wrote it well. Here is the structure of my table:
sql> SHOW COLUMNS FROM BURSUCUL.NORMA;
FIELD | TYPE | NULL | KEY | DEFAULT
normaid | integer(10) | NO | PRI | (NEXT VALUE FOR BURSUCUL.
SYSTEM_SEQUENCE_A35B0D2E_EB1B_4869_B3C8_80767DBE85DE)
normalinkarticol | integer(10) | NO | | NULL
normacod | varchar(256) | NO | | NULL
normaum | varchar(256) | NO | | NULL
normadescriere | varchar(2048) | NO | | NULL
- I also tried to use the native fulltext indexer in this older version but
then I get:
sql> CALL FT_INIT();
Error: org.h2.jdbc.JdbcSQLException: Syntax
error in SQL statement "CREATE TABLE IF NOT EXISTS FT.ROWS(ID IDENTITY,
HASH INT, INDEXID INT, KEY VARCHAR,[*] UNIQUE(HASH, INDEXID, KEY))";
expected "("; SQL statement:
CREATE TABLE IF NOT EXISTS FT.ROWS(ID IDENTITY, HASH INT, INDEXID INT, KEY
VARCHAR, UNIQUE(HASH, INDEXID, KEY)) [42001-160]Enter code here...
Please let me know if you have a suggestion regarding any of the issues
above.
--
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/cd957b6c-1198-4d58-9532-621f3058421c%40googlegroups.com.
