Can I get a table name from a join select resultset metadata
- by Matt
Below is my code trying to retrieve table name form Resultset
ResultSet rs = stmt.executeQuery("select * from product");
ResultSetMetaData meta = rs.getMetaData();
int count = meta.getColumnCount();
for (int i=0; i<count; i++) {
System.out.println(meta.getTableName(i));
}
But it returns empty, no mention it is a join select resultset.
Is there any other approaches to retrieve table name from reusltset metadata?