Hallo, I tried to use hibernate with jboss with your example, but jboss tells that do not have hibernate.cfg.xml.

As I understand, using jboss-service.xml is instead of hibernate.cfg.xml- did I understood well?

I have datasource defined in jboss:
<local-tx-datasource>
<jndi-name>OraHbDS</jndi-name>
<connection-url>jdbc:oracle:thin:@chaloupkaj.iccc.cz:1521:ordb</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>hb</user-name>
<password>oracle</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>

, *.sar/META-INF/jboss-service.xml:
<server>
<mbean code="net.sf.hibernate.jmx.HibernateService" name="jboss.jca:service=HibernateFactory,
name=HibernateFactory">
<depends>jboss.jca:service=RARDeployer</depends>
<depends>jboss.jca:service=LocalTxCM,name=OraHbDS</depends>
<!-- Make it deploy ONLY after DataSource had been started -->
<attribute name="MapResources">mappings/cat.hbm.xml</attribute>
<attribute name="JndiName">java:/hibernate/HibernateFactory</attribute>
<attribute name="Datasource">java:/OraHbDS</attribute>
<attribute name="Dialect">net.sf.hibernate.dialect.Oracle9Dialect</attribute>
<attribute name="TransactionStrategy">net.sf.hibernate.transaction.JTATransactionFactory</attribute>
<attribute name="TransactionManagerLookupStrategy">net.sf.hibernate.transaction.JBossTransactionManagerLookup</attribute>
<attribute name="UseOuterJoin">false</attribute>
<attribute name="ShowSql">false</attribute>
<attribute name="UserTransactionName">java:/UserTransaction</attribute>
</mbean>
</server>

and mapp file *.sar/mappings/cat.hbm.xml

in code I have only session factory creation, for now.

What I understood bad?
Thanks, Jirk

If you are using JMX, you should not need .cfg.xml


I'm not sure what you mean by "Hibernate tells me". What does it tell you?? When??

code:
try{
SessionFactory sessionFactory =
new Configuration().configure().buildSessionFactory();
}catch(Exception e){
out.println("Fail: "+e.getMessage());
}

prints :
Fail: /hibernate.cfg.xml not found

You don't need to use Configuration when using JMX. The MBean does all that stuff for you.

I think I do not understand, documentation seems not unambiguous here.
In classical jboss I have connection from datasource:
DataSource ds = (DataSource) ctx.lookup("java:/someDS");
Connection conn = ds.getConnection();
etc etc. (via jdbc)
You tell that it is sufficient and hibernate manages this connection now? I do not think :(

Apparently you know much better than me, so you shouldn't ask me any more questions.