Hi-
I tried to run the following commands in this order:
st.executeUpdate("CREATE ALIAS IF NOT EXISTS FTL_INIT FOR
\"org.h2.fulltext.FullTextLucene.init\";");
st.executeUpdate("CALL FTL_INIT();"));
st.executeUpdate("CREATE TABLE test_table(id INTEGER NOT NULL
AUTO_INCREMENT, title VARCHAR, PRIMARY KEY (id));");
st.executeUpdate("CREATE TABLE test_table_li(id INTEGER NOT NULL
AUTO_INCREMENT, title VARCHAR, PRIMARY KEY (id));");
st.executeUpdate("INSERT INTO test_table(title) VALUES
('testline');");
st.executeUpdate("INSERT INTO test_table_li(title) VALUES
('testline');");
st.executeUpdate("CALL FTL_CREATE_INDEX('PUBLIC', 'test_table_li',
NULL);");
where "st" is a java.sql.Statement. All of the commands are executed
except for the last one which throws the exception below.
H2InsertTestRunner.java:76 is the last row of the command set above.
Any suggestions? Thanks for advance,
D_mISi
org.h2.jdbc.JdbcSQLException: Table test_table_li not found [42102-77]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.schema.Schema.getTableOrView(Schema.java:348)
at org.h2.command.ddl.CreateTrigger.update(CreateTrigger.java:
89)
at
org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:205)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:163)
at
org.h2.fulltext.FullTextLucene.createTrigger(FullTextLucene.java:559)
at
org.h2.fulltext.FullTextLucene.createIndex(FullTextLucene.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.h2.engine.FunctionAlias
$JavaMethod.getValue(FunctionAlias.java:268)
at org.h2.expression.JavaFunction.getValue(JavaFunction.java:
36)
at org.h2.command.dml.Call.update(Call.java:43)
at
org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:205)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:
117)
at h2.H2InsertTestRunner.beforeRun(H2InsertTestRunner.java:76)
at
freedb.FreeDbInsertTestRunner.run(FreeDbInsertTestRunner.java:32)
at java.lang.Thread.run(Thread.java:636)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
