Hibernate Persistence Manager for JbossMQ

[npujol]

Hi,

I would like to use hibernate to generate the JbossMQ tables as well as for persisting the JbossMQ messages. I saw a thread from back in 2001 from Adrian making the same observation. Do we know if this is available now? If not how do I keep from having multiple *-jdbc2-service.xml an *-jdbc-state-service.xml files for each db i need to support? Any pointers?

Thanks!

Nicolas

[byorn]

Why do you want to use Hibernate for this??

[npujol]

As you probably know *-jdbc2-service.xml and *-jdbc-state-service.xml contain SQL statements. Unfortunately, as you also know, while SQL is a standard there exists database differences. This is is the reason why Jboss provides out of the box different flavors of *-jdbc2-service.xml and *-jdbc-state-service.xml such oracle-jdbc2-service.xml, mysql-jdbc2-service.xml, postgres-jdbc2-service.xml etc.... (look into your $JBOSS_INSTALL/docs/examples/jms. I need to support different databases and would like to make it easy for my users.

Nicolas