Description:
DatabaseMetaData's storesXXXXXCaseIdentifiers() methods return all "true" when using MySQL 4.1.15 on Linux.
dmd.storesLowerCaseIdentifiers() = true
dmd.storesUpperCaseIdentifiers() = true
dmd.storesMixedCaseIdentifiers() = true
I am using the JDBC driver v3.1.11. The client is running on Windows.
The problem occurs only when the db server is running on Linux.
On Windows, I am getting the following
dmd.storesLowerCaseIdentifiers() = true
dmd.storesUpperCaseIdentifiers() = false
dmd.storesMixedCaseIdentifiers() = false
which is correct
Looking forward to hearing from you guys,
Best regards,
How to repeat:
InitialContext ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:/DefaultDS");
con = ds.getConnection();
DatabaseMetaData dmd = con.getMetaData();
System.out.println("<br>dmd.storesLowerCaseIdentifiers() = "+dmd.storesLowerCaseIdentifiers());
System.out.println("<br>dmd.storesUpperCaseIdentifiers() = "+dmd.storesUpperCaseIdentifiers());
System.out.println("<br>dmd.storesMixedCaseIdentifiers() = "+dmd.storesMixedCaseIdentifiers());
Description: DatabaseMetaData's storesXXXXXCaseIdentifiers() methods return all "true" when using MySQL 4.1.15 on Linux. dmd.storesLowerCaseIdentifiers() = true dmd.storesUpperCaseIdentifiers() = true dmd.storesMixedCaseIdentifiers() = true I am using the JDBC driver v3.1.11. The client is running on Windows. The problem occurs only when the db server is running on Linux. On Windows, I am getting the following dmd.storesLowerCaseIdentifiers() = true dmd.storesUpperCaseIdentifiers() = false dmd.storesMixedCaseIdentifiers() = false which is correct Looking forward to hearing from you guys, Best regards, How to repeat: InitialContext ctx = new InitialContext(); ds = (DataSource) ctx.lookup("java:/DefaultDS"); con = ds.getConnection(); DatabaseMetaData dmd = con.getMetaData(); System.out.println("<br>dmd.storesLowerCaseIdentifiers() = "+dmd.storesLowerCaseIdentifiers()); System.out.println("<br>dmd.storesUpperCaseIdentifiers() = "+dmd.storesUpperCaseIdentifiers()); System.out.println("<br>dmd.storesMixedCaseIdentifiers() = "+dmd.storesMixedCaseIdentifiers());