You need a reference to the database metadata, and then just use that to get information about the database. Check the API for metadata. Bosun
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Joined: Apr 25, 2000
hi bosun i checked the API, but i just want to know the table name before the execution of query, but still, when i run through the query, i can't get the table name through the resultsetmetadata. Does the method getTableName() get me the table name?? but i got null. Thanks sathish
"santish" The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention whci hyou agreed to when you registered, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please create a new log in with a new name which meets the requirements. Thanks.