Where does hibernate sit in my J2EE stack. My middle tier uses Stateless Session Beans for business logic. At the moment these SLSB also contain hand written JDBC code.
What I want to do is create a DAO layer outside of the middle tier. Because other J2EE applications need to use the DAO layer as well. I want to share the DAO layer accross different applications that need to access the same RDBMS.
The applications are deployed as ear files. How should i deploy my DAO layer. Should I still use the session facade pattern to 'front' the dao layer and back this with Hibernate persistent business objects. If I deploy this as an ear file as well will this mean that the applications that need DB access will need to use remote interfaces to communicate with the Hibernate layer. Because of another question I asked at the ranch I think this is true under WebLogic because of the way classloaders are allocated to ear files.
I guess my question is can someone suggest a good architecture for me. I would be very grateful for any suggestions.
For now, I am going to close this copy of the same thread posted in the EJB forum. If we decide that this forum is better for your question, or you would rather this be the forum that this thread resides, then I can move the one in the EJB forum back to here. Since I have already posted a reply there.