I am reworking a Sybase Hibernate/JBoss app to point to Oracle.

I would like to record all our known Sybase and Oracle datasources in a single datasource file.

Then in my hibernate-service file I will select which datasource I use.

However, I find the database dialect specification in the MBean definition in the hibernate-service.xml file as well as the JNDI datasource name. This suggests that I can't just point the MBean at a datasource, I also have to configure it for the specific DB dialect.

I would rather just change the service name. Can I put each appropriate dialect into my datasource file, perhaps as an attribute in each <local-tx-datasource> section?

Thanks,

Andrew

If I understand, you want to be able to hide and centralize the dialect specification. Is so, I do not think it's possible. Hibernate needs in fact to know which dialect is to be used in the datasource pipe he's using.