Hi Im using Hibernate-1.2.3 with JBoss-3.0.7 and i need to setup hibernate.fetch_size and hibernate.batch_size. How do I declare that in JBoss Service file?

This is my current jboss service file

<server>
<mbean code="cirrus.hibernate.jmx.HibernateService"
name="jboss.jca:service=servicename">

<classpath codebase="/jboss-3.0.7/server/default/lib/hibernate.jar"
lib="/jboss-3.0.7/server/default/deploy/hibernate-hms-0.1.0.sar,/jboss-3.0.7/server/default/lib/commons-collections.jar,/jboss-3.0.7/server/default/deploy/hibernate-ems-0.1.1.2.sar"/>
<depends>jboss.jca:service=RARDeployer</depends>

<!-- Make it deploy ONLY after DataSource had been started -->
<!--depends>jboss.jca:service=LocalTxCM,name=MySqlDS</depends-->
<attribute name="MapResources">...<my hbm.xml files>...</attribute>
<attribute name="JndiName">java:/hibernate/ABC</attribute>
<attribute name="Datasource">java:/MySqlDS</attribute>
<attribute name="UserName">root</attribute>
<attribute name="Dialect">cirrus.hibernate.sql.MySQLDialect</attribute>
<attribute name="UserName">root</attribute>
<attribute name="TransactionStrategy">cirrus.hibernate.transaction.JTATransactionFactory</attribute>
<attribute name="TransactionManagerLookupStrategy">cirrus.hibernate.transaction.JBossTransactionManagerLookup</attribute>
<attribute name="UseOuterJoin">true</attribute>
<attribute name="ShowSql">false</attribute>
<attribute name="
<!--attribute name="UserTransactionName">java:comp/UserTransaction</attribute-->
</mbean>
</server>

Thanks.

-Len

This cannot be set on the service parameters available. You can look at the code and make the changes to set the values - its not that difficult.

How? Could you please post a sample or maybe post a site address for more information?

Thanks.

Download the sources and have a look at the jca package for a start
http://cvs.sourceforge.net/viewcvs.py/hibernate/Hibernate2/src/net/sf/hibernate/jca/

Note that you can set it in 2.1.2 using <parameter name="JdbcFetchSize"> and <parameter name="JdbcBatchSize">. To patch it in yourself modify the classes in net.sf.hibernate.jmx

If I were to migrate my hibernate 1.2.3 to hibernate 2.x.x (latest stable) so I could take advantage of fetchsize and batchsize in JBoss, what are the typical gotchas i need to be aware of? My app is running in full production (MySQL4.x+Jboss3.0.7+Hibernate1.2.3+Swing), not much problem popped up in my session beans and hibernate daos and I dont really like it to "break" because of my upgrade. I use one-to-one, one-to-many and many-to-many relationships heavily.

Thanks.