db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5244) DatabaseMetaData.getColumns(null, null, tableName, null) does not return the columns meta for a SYNONYM
Date Fri, 18 Oct 2013 15:20:43 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13799184#comment-13799184
] 

ASF subversion and git services commented on DERBY-5244:
--------------------------------------------------------

Commit 1533494 from [~chaase3] in branch 'docs/branches/10.10'
[ https://svn.apache.org/r1533494 ]

DERBY-5244  Revise DatabaseMetaData section of Reference Manual

Merged DERBY-5244.diff to 10.10 doc branch from trunk revision 1533480.

> 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: Improvement
>          Components: Documentation
>    Affects Versions: 10.8.1.2
>         Environment: Windows
>            Reporter: Prashanth Godey
>            Assignee: Kim Haase
>            Priority: Minor
>              Labels: SYNONYM, getColumns
>             Fix For: 10.10.1.3, 10.11.0.0
>
>         Attachments: DERBY-5244.diff, rrefjdbc15905.html
>
>
> 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 was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message