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());