[DERBY-5244] DatabaseMetaData.getColumns(null, null, tableName, null) does not return the columns meta for a SYNONYM

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.8.1.2
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Documentation
• Labels: SYNONYM getColumns
• Environment: Windows
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Prashanth Godey
• Created: 24/May/11 16:18
• Updated: 16/Apr/14 02:40
• Resolved: 18/Oct/13 15:20

Description

DatabaseMetaData.getColumns(null, null, tableName, null) does not return the columns meta for a SYNONYM.

Sample java code use for testing.

/**

• ListColumns.java
  */
  import java.sql.*;
  import java.util.Properties;

public class ListColumns {
public static void main(String[] args) {
Connection con = null;
try {

Class.forName("org.apache.derby.jdbc.ClientDriver");

Properties connectionProps = new Properties();
connectionProps.put("user", "app");
connectionProps.put("password", "app");

con = DriverManager.getConnection(
"jdbc:derby://localhost:1527/northwind", connectionProps);

String tableName = "V1";

DatabaseMetaData meta = con.getMetaData();
System.out.println("Database Product Version"
+ meta.getDatabaseProductVersion());

ResultSet res = meta.getColumns(null, null, tableName, null);
System.out.println("List of columns for " + tableName);
while (res.next())

{ System.out.println(" " + res.getString("TABLE_SCHEM") + ", " + res.getString("TABLE_NAME") + ", " + res.getString("COLUMN_NAME") + ", " + res.getString("TYPE_NAME") + ", " + res.getInt("COLUMN_SIZE") + ", " + res.getString("NULLABLE")); }

res.close();

con.close();
} catch (java.lang.ClassNotFoundException e)

{ System.err.println("ClassNotFoundException: " + e.getMessage()); }

catch (SQLException e)

{ System.err.println("SQLException: " + e.getMessage()); }

}
}