org.h2.jdbc.JdbcSQLException: Function FTL_REINDEX not found; SQL statement: HELP!! org.h2.jdbc.JdbcSQLException: Function FTL_REINDEX not found;

[mollet]

Hello,

I have made a java program (first as a Netbeans project, but I have
just moved it to Eclipes), that uses an embedded H2 database. The
database has a lucene fulltext index. The connection to the database
is working fine. I added the h2.jar and lucene-core-2.3.1.jar to the
project java build path. And the database files to the program source
folder. However if I put the database files in a directory, I
couldn't connect.
Lets get to the point. I have a text search function in my
application, and when I try to search for a word, some queries are
executed. But here lays the problem, the first query is:
CALL FTL_REINDEX();

Here I get this exception:

org.h2.jdbc.JdbcSQLException: Function FTL_REINDEX not found; SQL
statement:
CALL FTL_REINDEX() [90022-67]

I get this exception in both Netbeans and Eclipse, but not when I
built the project and ran it on Ubuntu. However I got the exception
when I ran the program on XP.

I hope someone has a solution to this problem and can help me.

[mollet]

I think I have found the problem. The promlem is, that I have set the
right path to the database. I don't know how to set the path to a
database in the source folder, I have tried several ways. What I can
get to work, is to refer to the user home directory, so I will use
that for now. If someone knows how to refer to the source folder,
please show me. I have tried everything, that was in the manual, but
it didn't work.

[mollet]

Finally I cracked it !! I have used this:

String url = "jdbc:h2:file:/path/DATABASE";

when it should be:

String url = "jdbc:h2:file:path/DATABASE";

hehehe, very stupid and simple problem. But hey, isn't it always ?