How to find out type of underlying database

[Shailesh Shailesh]

I need to know the type of underlying database (not the actual connection object). So, far I could only find following way

String className = new DefaultOfBizConnectionFactory().getDatasourceInfo().getJdbcDatasource().getUri();

if(uri.indexOf("postgres"){

doSomething()

}

Is there a better way in JIRA 5?

[JamieA]

Sometimes it's needed, when you have raw sql and haven't yet moved to AO.

Personally I do it like this:

session.connection().getMetaData().getDatabaseProductName()

[Shailesh Shailesh]

I would hate to put any database specific code, but we are running into AO-296.

I found an alternative way do get the database metada

new SystemInfoUtilsImpl().getDatabaseType().

I dont like it as it fails in UT with NullPointerException.

[Samuel Le Berrigaud]

I'm curious as to why you need to find the type of the database? One of the goal of Active Objects is actually to abstract the type of the database away.