Hi, Sure, so the SQL query is a simple select using an index on curve_id :
SELECT * FROM volume_curve_value WHERE curve_id = 3685
Index is:
CREATE INDEX PUBLIC.GET_LAST_RUN_ID ON PUBLIC.VOLUME_CURVE_VALUE(CURVE_ID)
Table is:
CREATE CACHED TABLE PUBLIC.VOLUME_CURVE_VALUE(
CURVE_ID INT SELECTIVITY 1,
TIME DOUBLE SELECTIVITY 1,
VALUE DOUBLE SELECTIVITY 96
)
To connect the database I do the following:
System.setProperty("h2.bindAddress", "localhost");
Class.forName("org.h2.Driver");
connection =
DriverManager.getConnection("jdbc:h2:"+filename+";AUTO_SERVER=TRUE",
username, password);
What do you mean by database setup? H2 version is 1.3.157.
Thanks
Sylvain.
--
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.
corrupted.trace.db
Description: Binary data
