Native Queries

Abbzug · **Joined:** Sat Nov 21, 2009 9:42 am **Posts:** 7

Hello,

In some circumstances we need to execute database depended native queries.
As some customers have this database and others that one, we need to support a query in more than one dialect.
Therefore we keep the statements in files named according to the database name, e.g., "sqlserver.sql"

AFAIK the native query annotations do not support this, do they?

How can we determine the database name or JDBC URL (that contains the JDBC subprotocol)?
I didn't find anything in this direction neither in JPA API nor in Hibernate Session class.

Kind Regards,
Abbzug

mmerder · **Posted:** Mon Nov 23, 2009 9:38 am

Try

Code:

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

Note that connection() method is deprecated now.