Quick question: it looks like it is failing when you try and add a new user? Presumably to get there you can login, access the admin pages etc. If that is the case then the hibernate mappings must be good. There should be a nested lower level SQL exception which will give more details as to the exact error. There may also be an issue with sequence numbers for the user ids - try adding the user a few times, and you may find it magically starts working.
Mike On 10/26/07, BruceLee <[EMAIL PROTECTED]> wrote: > > > 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] > >
