Databasemetadata getting column details

Question

I use databasemetadata to find the column size. But getColumns(null,null,"table_name",null) returns an empty resultset. I checked for the table by querying it and the table is present. Where is the error? Thanks in advance!

Update:

Connection connection = getConnection(); //getting the connection -   
Statement st = connection.createStatement();  
ResultSet rs = st.executeQuery("select * from table_name");  
while (rs.next()) { 
   System.out.println(rs.getString("column_name")); //The values get printed 
}
ResultSet rsColumns = null;
DatabaseMetaData meta = connection.getMetaData();
rsColumns = meta.getColumns(null, null, "table_name",null);     
System.out.println(rsColumns.next()); // I get false here which means resultset is empty. But I dunno why.

score 0 · Answer 1 · answered Jan 06 '11 at 21:00

Which database are you using? It's probably related to how it handle unquoted identifiers, databases that follow the standard automatically store them in upper case. You can programmatically check if it does that by calling the storesUpperCaseIdentifiers method.

The solution would be to either use quoted identifiers while creating the table or calling the toUpperCase method on the table name string if storesUpperCaseIdentifiers returns true.

score 0 · Answer 2 · answered Oct 04 '17 at 07:17

Can you try the below snippet:

ResultSet rsColumns = null;
DatabaseMetaData meta = connection.getMetaData();
rsColumns = meta.getColumns(null, null, "table_name",null);     
While (rsColumns,next()) {
System.out.println(rsColumns.getInt("COLUMN_SIZE"));
}

I think you are missing the "COLUMN_SIZE".

Databasemetadata getting column details

2 Answers2