Where The Streets Have No Name

Retrieving column metadata over database link 본문

Developement/Java

Retrieving column metadata over database link

highheat 2006. 10. 1. 02:15
http://forums.oracle.com/forums/thread.jspa?messageID=1434437



props.put("includeSynonyms", true);
connection = DriverManager.getConnection(connectUrl, props);

I'm using the most recent Oracle thin JDBC driver. Then to get the columns for my synonym:

meta = conn.getMetaData();
rs = meta.getColumns(null, "MY_DB", "MY_SYN", "%");

http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96654/basic.htm#1006248