How to determine database type for a given JDBC connection?

Question

I need to handle resultsets returning stored procedures/functions for three databases (Oracle, sybase, MS-Server). The procedures/functions are generally the same but the call is a little different in Oracle.

statement.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);
...
statement.execute(); 
ResultSet rs = (ResultSet)statement.getObject(1);

JDBC doesn't provide a generic way to handle this, so I'll need to distinguish the different types of DBs in my code. I'm given the connection but don't know the best way to determine if the DB is oracle. I can use the driver name but would rather find a cleaner way.

score 56 · Answer 1 · edited Apr 15 '14 at 09:52

56

I suspect you would want to use the DatabaseMetaData class. Most likely DatabaseMetaData.getDatabaseProductName would be sufficient, though you may also want to use the getDatabaseProductVersion method if you have code that depends on the particular version of the particular database you're working with.

edited Apr 15 '14 at 09:52

Jerven

582
3
7

answered Oct 31 '08 at 17:01

Justin Cave

227,342
24
367
384

11

Microsoft SQL Server gives "Microsoft SQL Server" for the product name. – OldCurmudgeon Jun 08 '12 at 16:04
14

PostgreSQL gives "PostgreSQL" – BxlSofty Dec 29 '13 at 04:51
9

MySQL gives "MySQL", and HSQLDB gives "HSQL Database Engine". – Cannoliopsida Jun 12 '14 at 18:58
3

Derby gives "Apache Derby" – Peter L Oct 07 '16 at 02:13
1

Is there an enum we could use to compare ? – Farid Sep 05 '17 at 07:58
2

Most other values are listed in this answer: https://stackoverflow.com/questions/9320200/inline-blob-binary-data-types-in-sql-jdbc/58736912#58736912 – Vadzim Jun 02 '20 at 22:03
H2 gives "H2" . – Igor Mukhin Jun 04 '20 at 10:29

score 3 · Answer 2 · edited Sep 23 '16 at 04:38

3

You can use org.apache.ddlutils, class Platformutils:

databaseName = new PlatformUtils().determineDatabaseType(dataSource)

edited Sep 23 '16 at 04:38

Andrew Swan

13,427
22
69
98

answered Jan 30 '12 at 13:42

Rinat Tainov

1,479
2
19
39

How to determine database type for a given JDBC connection?

2 Answers2

Linked