Get name of current table by resultSet on RowMapper

Question

It's possible get name of current table, on implementation of RowMapper. I try by metadata, but not have sucess

I am using the SpringData JdbcTemplate to run queries on the database, and implements the RowMapper to map the resultset — Thiago, Feb 12 '16 at 13:10
Read http://www.h2database.com/html/features.html for getTableName() and check if any of the metioned conditions for getTableName() == null applies to you. — Rainer Montag, Feb 12 '16 at 14:35

Rainer Montag · Accepted Answer · 2016-02-12T14:36:56.083

You can try to determine the tablename by

 ResultSet.getMetaData().getTableName(int column)

As both ResultSet and ResultSetMetaData are only interfaces, the implementation depends on the database driver your are using.

So, if this method does not deliver the tablename:

For example current oracle db driver does not support it.

For H2, check http://www.h2database.com/html/features.html , it describes the behaviour of getTableName() depending on the selected Compatibility Mode.

1 Answers1