Hello,
I am trying to get the beer4all sample application running, which I downloaded from SourceForge. To ojb I am a newbie, so don't shoot me for asking silly questions. System is : Tomcat 5.0.28, jk2, apache 2.0.48, mysql 4.1.4-gamma-nt, eclipse 3.0.1, mysql connector 3.1.1-alpha, ojb-0.9.4 (came with example download) I have modified the repository.xml file (which is in the classpath) to use the installed MySql server, user/password were modified, access is OK. I created a database ojb and loaded the sql.sql file which came with the example zipfile. I verified that all tables were created and are filled : everything is in place within Mysql. When I run the application, I have found three places (for now) where DB-access is used (signin authenticate method, getFeaturedCatalogs, getFeaturedItems). Where struts seems to work OK (welcome page is displayed, links are active), DB access keeps going wrong. The errors are always similar to those from getFeaturedCatalogs : INFO 23:02:2005-16:03:31 org.apache.struts.action.RequestProcessor - Processing a 'GET' for path '/main' [ODMG] ERROR: null org.apache.ojb.broker.TransactionInProgressException at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.beginTransaction(Unknow n Source) Every idea over what could be wrong would be welcome ! Also something I don't get : In the DB, the User table has 4 fields: ID, Firstname, Lastname, username, there is no password field In the authenticate() method a query is being made with the password field in the where clause. How can this be ? Where is the password info stored ? Thanx for any reply, Thierry Van Acker. PS : The link to this document : The famous Beer4All Struts/OJB tutorial by Chuck Cavaness seems not to be working...
