Could you provide a more detailed stack trace from the hosted environment? It would help us help you!
Mike On 10/27/07, BruceLee <[EMAIL PROTECTED]> wrote: > > > 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] > >
