DatabaseMetaData.getColumns returns columns of similar named tables

Asked Sep 13 '16 at 11:56

Active Sep 13 '16 at 11:56

Viewed 563 times

In my database I have tables "EMPLOYEE_DETAILS" and "EMPLOYEE DETAILS" with different columns for both tables. When I used the getColumns() method of the DatabaseMetaData (java.sql.DatabaseMetaData) to get the column details of the table "EMPLOYEE_DETAILS", I am getting the columns of both "EMPLOYEE_DETAILS" and "EMPLOYEE DETAILS".

I have tried this for databases Oracle, MySql and MSSQL. The result is same.

The code which I have used to call the getColumns method is given below :

String tableName = "EMPLOYEE_DETAILS";
ResultSet columnResultSet = databaseMetaData.getColumns(null, null,tableName, null);

while (columnResultSet.next()) {
System.out.println(columnResultSet.getString("COLUMN_NAME"));
System.out.println(columnType = columnResultSet.getString("TYPE_NAME"));
System.out.println(columnSize = columnResultSet.getInt("COLUMN_SIZE"));
}

Could anyone please help me to resolve this.

asked Sep 13 '16 at 11:56

Hajas

1

Take a look at getSearchStringEscape() . "_" is probably a wildcard character in the table search. – OldProgrammer Sep 13 '16 at 12:03
@OldProgrammer that is exactly the answer, as you probably knew. I'm curious: why do people post answers as comments instead of answers? – Matthew McPeak Sep 13 '16 at 12:19
It was just a hunch. – OldProgrammer Sep 13 '16 at 15:09

DatabaseMetaData.getColumns returns columns of similar named tables

0 Answers0