Dear Team, I'm new with Appfuse 1.9.4 with WW2. We have a weird problem: When I test our website locally with Tomcat & MySQL, everything is OK. But after I copy our webapp under Tomcat to remote web hosting, I can only access the JSP pages, not able to access data from database.
The error on page is below, Data Access Failure JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.cmn.model.User] I did Google search and someone said the hibernate mapping maybe not good. In my local Tomcat, I can see bunch of * hbm.xml under work/Catalina/localhost/cmnweb/loader/com/cmn/model/ But I'm not sure the remote Tomcat since it's a shared hosting. My questions: 1) Any idea about above Hibernate Data Access Failure? 2) How does Tomcat decide to load *hbm.xml from my lib cmnweb-dao.jar, but not all .jar in WEB-INF/lib/ ? Thanks a lot! -Mike -- View this message in context: http://www.nabble.com/Cannot-access-database-with-remote-shared-web-hosting-tf4698767s2369.html#a13432068 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
