com.mysql.jdbc.ResultSetMetaData; vs java.sql.ResultSetMetaData;

Question

I am using tomcat7, java 1.6 to access a mysql db with com.mysql.jdbc.Driver. I was going to get metaData from a table like

java.sql.ResultSet set=getStuff();
ResultSetMetaData meta = set.getMetaData();

The problem is , set.getMetaData returns java.sql.ResultSetMetaData; but I am using mysql with jdbc, so shouldn't it be returning com.mysql.jdbc.ResultSetMetaData;? Did I import something wrong? If not when will com.mysql.jdbc.ResultSetMetaData; be used or whats the difference?

benzonico · Accepted Answer · 2013-03-10 20:10:04Z

3

The role of the driver is actually to abstract the use of database specific code. So you just specify the driver and then interact with an api that is not database dependent.

If you have a closer look you will see that com.mysql.jdbc.ResultSetMetaData is an implementation of the interface java.sql.ResultSetMetaData.

And for sake of decoupling you are better off working with the interface (so you are not tied to a specific database in your code)

answered Mar 10, 2013 at 20:10

benzonico

10.9k5 gold badges46 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

com.mysql.jdbc.ResultSetMetaData; vs java.sql.ResultSetMetaData;

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related