Hi, > h2.bindAddress = localhost
Why do you use this setting? It will not allow connections from other computers. Do you have a way to ensure all connections are from within the same computer? Do you have a reproducible test case? What version of H2 do you use? What is the complete error message including all stack traces? > corrupted.trace.db It contains "Syntax error in SQL statement "CORRUPTED[*].TRACE.DB "" Regards, Thomas On Fri, Aug 5, 2011 at 9:13 PM, Sylvain Archenault <[email protected]> wrote: > 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. > > -- 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.
