Hi All,
I have written hibernate application to access stored procedures.How should i deploy this application to Oracle Application server or any appserver.Do i need to create jar file ?Where should i place hibernate-cfg.xml file while deployment.Can anyone give all the necessary steps for deployment.This is urgent , please help.

For a web application you can use following structure

/pages/index.jsp
/pages/login/signin.jsp
/pages/login/signout.jsp
....
/hibernate.cfg.xml
/log4j.properties
/TableOneMapping.hbm.xml
/TableTwoMapping.hbm.xml
/WEB-INF/classes/com/define/mypackage/TableOneMapping.class
/WEB-INF/classes/com/define/mypackage/TableTwoMapping.class

I have to call these hibernate DAOs from session bean.How should i write my session bean to invoke hibernate code.How should my project structure look.Can anyone provide deatail steps.

something like:

1. put the hibernate.cfg at the top of your java src tree

1. configure hibernate including these properties



2. write a startup servlet to read the hibernate config (from your classpath) the session factory store in JNDI

3. In your stateless session ejb (CMT/Required) lookup the session factory in JNDI and start using hibernate API

Your EJB/DAO code will be in your application-ejb.jar and hibernate libraries in your ear file.

Hi,
Thanks for your reply.Can you please send sample code to access hibernate DAO from session bean.

your session ejb code:



your dao code:



your DAO constructor might contain something like:



your getCurrentSession() might do something like:




Hope this helps

Thanks for your reply.I will try it.

Hi,
I tried accessing DAO from sessionbean as per your example code.I am getting following error when deploying my ear file to appserver

[19-Jul-2006 16:07:50] Application Deployer for TestEjbHibernate STARTS.
[19-Jul-2006 16:07:50] Copy the archive to C:\product\10.1.3\OracleAS_1\j2ee\home\applications\TestEjbHibernate.ear
[19-Jul-2006 16:07:50] Initialize C:\product\10.1.3\OracleAS_1\j2ee\home\applications\TestEjbHibernate.ear begins...
[19-Jul-2006 16:07:50] Unpacking TestEjbHibernate.ear
[19-Jul-2006 16:07:50] Done unpacking TestEjbHibernate.ear
[19-Jul-2006 16:07:50] Unpacking cai-web.war
[19-Jul-2006 16:07:51] Done unpacking cai-web.war
[19-Jul-2006 16:07:51] Initialize C:\product\10.1.3\OracleAS_1\j2ee\home\applications\TestEjbHibernate.ear ends...
[19-Jul-2006 16:07:51] Starting application : TestEjbHibernate
[19-Jul-2006 16:07:51] Initializing ClassLoader(s)
[19-Jul-2006 16:07:51] Initializing EJB container
[19-Jul-2006 16:07:51] Loading connector(s)
[19-Jul-2006 16:07:51] Starting up resource adapters
[19-Jul-2006 16:07:51] Processing EJB module: cai-ejb.jar
[19-Jul-2006 16:07:51] Operation failed with error: com/cai/datamatching/model/LookupList

I placed my jsps,DAO(in web-inf/classes) in war file and ejbs in jar file.Altogether i packed as ear file and deployed.If this is not proper way to package please suggest me how i should do.I don't want to package DAO with ejbs because DAOs should be accessible to other layers also.So please suggest me on this.Do i need to specify any mapping in ejb-jar.xml regarding DAO location.Please provide detail steps

Does the class "com/cai/datamatching/model/LookupList" exist in your cai-ejb.jar file? Files/libraries in your cai-web.war are not visible to ejb container.

Where do you normally place classes required by your EJB's / deployed J2EE applications? Are the DAO's being used by your web container or by your ejb container? Your persistant classes are probably required in both your cai-web.war and cai-ejb.jar file.

I suppose you could package your DAO (and dependants) into a jar in your ear file (your cai-ejb.jar manifest.mf should have a classpath entry which includes necessary jars). Jars in the ear should be accessible in both web/ejb tiers.

e.g.


I'm not sure that this is really a hibernate problem, as the error does not indicate any hibernate messages.

Hi,
First of all i would like to thank for your immediate replies.
"com/datamatching/model/LookupList" doesn't exist in my cai-ejb.jar .I placed hibernate DAO and test jsp in cai-web.war.Problem is not with hibernate because i am getting ClasssNotFound Exception .Moreover i tested hibernate DAO deploying to appserver as a war file and accessed it from jsp it is working fine.My DAOs should be available to session beans(ejb container) and also other layers so i should not package my DAO with sessionbean.As per your suggestion i will try placing DAO in jar file and specifying classpath in Manifest.I will let you know if it works properly.
Thank you very much for your suggestion.

Hi,
I have deployed ear to appserver editing MANIFEST.MF as per your suggestion.It is working fine.Thank You Very Much.