Is it possible to get JDBC level API support via JDBC API?
That is 3.0, 3.1, 4.0, 4.1, 4.2, etc...
Yes, you can using
DatabaseMetaData.getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver.
and DatabaseMetaData.getJDBCMinorVersion():
Retrieves the minor JDBC version number for this driver.
This was added in Java 1.4 (JDBC 3); note that there is no JDBC 3.1.
So
Connection connection = ....
DatabaseMetaData dbmd = connection.getMetaData();
System.out.printf("JDBC: %d.%d%n", dbmd.getJDBCMajorVersion(), dbmd.getJDBCMinorVersion());