How to check oracle database version after connection in java code

Question

I am connecting to Oracle 11g/12c using java code by providing correct URL, User & Password. But now i want the oracle version like 11g/12c after successful connection through java code.

Please help to get that.

Answer 1

Apart from querying the database, that information is also supplied by the JDBC driver, through DatabaseMetaData

Connection con = DriverManager.connect(...);
DatabaseMetaData meta = con.getMetaData();
int majorVersion = meta.getDatabaseMajorVersion();
int minorVersion = meta.getDatabaseMinorVersion();

e.g. Oracle 11.2 would result in majorVersion=11 and minorVersion=2