Thank Mike for advice. I cannot login even with built-in user tomcat:tomcat either. The page displays "Invalid User or Password". In local test everything is OK. Do I need to change some configurations when I copy it from local TOMCAT_HOME/webapp/ to remote hosting directory (which is not under TOMCAT_HOME, but under my home directory) ?
Thanks! -Bruce Mike Horwitz wrote: > > 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] >> >> > > -- View this message in context: http://www.nabble.com/Cannot-access-database-with-remote-shared-web-hosting-tf4698767s2369.html#a13443950 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
