JDBC: DatabaseMetaDat a

[Maroon]

import java.sql.*;

public class TESTA{

TESTA(){}

public static int product() {

try {
Class.forName(" com.ibm.db2.jcc .DB2Driver");
} catch (ClassNotFoundE xception e) {
e.printStackTra ce();
}

try{
String url = "jdbc:db2://192.168.2.3:500 00/coffee:";
System.out.prin tln("Before the Connection");
Connection con =
DriverManager.g etConnection(ur l,"jence_user", "jence_db") ;

DatabaseMetaDat a dbmd=con.getMet aData();
String[] types = {"TABLE"};
ResultSet rset=dbmd.getTa bles(null,"jenc e_user","%",typ es);

while(rset.next ()){
System.out.prin tln("Table Name
"+rset.getStrin g("TABLE_NAME") );
}

return 0;

}catch(Exceptio n e){
e.printStackTra ce();
return -1; //it represent the error has occured
}

}

public static void main(String argv[]){
System.out.prin tln("Output: "+TESTA.product ());
}
}

When i was trying to get metadata of the database by the jdbc driver
that come with db2 database. Then i could not find any coulmn name.
Have any way to get table name form db2 database?

[Bernd Hohmann]

Maroon wrote:

When i was trying to get metadata of the database by the jdbc driver
that come with db2 database. Then i could not find any coulmn name.
Have any way to get table name form db2 database?

You can fetch the columns with the ResultSetMetaDa ta from a SELECT *
dummy query on this table.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpf e
des 18. März in Berlin

[Maroon]

Hello
I have found my solution. The schema name is case sensitive. I used
lower case, but it will be upper case.
Thanks