db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prashanth G (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5244) DatabaseMetaData.getColumns(null, null, tableName, null) does not return the columns meta for a SYNONYM
Date Tue, 24 May 2011 16:19:47 GMT
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

Mime
View raw message