It appears that with version 1.4.198, field names are no longer case
insensitive with select statements. I've tried adding IGNORECASE=TRUE and
other collation statements but nothing appears to work here.
Is there something I need to add now to my connection string or to the
create table statement to allow for case insensitive queries again?
With this example code, this works fine in 1.4.197 but fails with 1.4.198
package example;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test {
public static void main(String[] args) throws Exception {
Class.forName("org.h2.Driver");
File file = new File("c:/temp/h2db.mv.db");
file.delete();
String url =
"jdbc:h2:c:/temp/h2db;DATABASE_TO_UPPER=FALSE;MODE=MSSQLServer;LOCK_TIMEOUT=30;"
;
Connection conn = DriverManager.getConnection(url, "sa", "");
Statement cs = conn.createStatement();
cs.execute("create cached table IF NOT EXISTS [MyTable] (\"ColTest\"
VARCHAR_IGNORECASE)");
cs.close();
Statement ss = conn.createStatement();
ResultSet rs = ss.executeQuery("select coltest from MyTable");
rs.close();
ss.close();
conn.close();
}
}
Thanks
--
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/7f7bc569-2d5b-4ba5-9f98-50b73fdf0c87o%40googlegroups.com.
