DatabaseMetaData.getColumns(null, null, tableName, null) does not return the
columns meta for a SYNONYM
-------------------------------------------------------------------------------------------------------
Key: DERBY-5244
URL: https://issues.apache.org/jira/browse/DERBY-5244
Project: Derby
Issue Type: Bug
Components: JDBC
Affects Versions: 10.8.1.2
Environment: Windows
Reporter: Prashanth G
Priority: Minor
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());
}
}
}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
