Thanks for the asistance. I want to make my changes available somewhere if its possible. Like the SQL Script and triggers I used for oracle database. Let me know when you have time if and how I'll be able to set this up. Thanks.
On Sep 14, 8:59 am, Ivo van Dongen <[email protected]> wrote: > Hi, > > Great that you've worked out all the kinks. Sorry to see that the code isn't > as refactorable as I hoped. Love the Criteria api of Hibernate, but using > strings remains an evil thing. I hope that the current incarnation of > webical fits your purposes after your alterations. Activity on the project > has been low for a long time, but I'm still hoping to get the time soon to > put some more effort into it. > > In the meantime, let us know how if you need anything else. > > Regards, > Ivo > > On Wed, Sep 9, 2009 at 7:03 PM, Marks Andre <[email protected]> wrote: > > > Update, > > > I managed to find the offending line of code. In pacakge > > org.webical.dao.hibernateImpl the class SettingsDaoHibernateImpl has > > the following method: > > > public UserSettings getUserSettings(User user) throws DaoException > > ... > > > try { > > Criteria criteria = getSession().createCriteria > > (UserSettings.class); > > criteria.add(Restrictions.eq("user_settings", > > user)); //had to > > change the string "user" to "user_settings". > > return (UserSettings) criteria.uniqueResult(); > > > As you can see the Restrictions.eq method passed "user" as an explicit > > string and was not refactored. By changing this to the correct > > property, it prevents the exception. > > > The application seems to be in a working state now with the Oracle 10g > > database. I'm sure that we will find further quirks as it now we enter > > in to full testing. My testing team will be hard at work and I will > > hope to continue posting in separate threads from now on. > > > On Sep 9, 12:39 pm, Marks Andre <[email protected]> wrote: > > > Hello, > > > > Thanks for the tip. I managed to debug the login by activating the > > > debug flag you mention. Indeed is quite a pain but the fact that it > > > delegates authentication to Tomcat worked out perfect for my purpose. > > > Interestingly, I had to explicitly configure the realm in the > > > server.xml file for the Tomcat configuration (this is unfortunate as > > > is preferable that the application can be deployed without modifying > > > the server configuration). For some reason the aplication server is > > > ignoring the context.xml realm on META-INF. > > > > Now, it seems that the application its having problems initializing. I > > > manage to login to the aplication with the default webical user. It > > > will ofcourse, take me to the administrator page. I then have to login > > > with un: admin, pw: admin (I dont know why, I merely guessed it). I > > > then go on to configure the application wide settings.When I click the > > > save button, the application tries to take me to the user calendar > > > (Acording to the URL in the > > browserhttp://localhost:8080/webical/app/calendar) > > > and displays the friendly error page with the following information: > > > > The application returned the following error message: > > > > Could not retrieve application settings for user: webical > > > > Also I get the following stack trace: > > > > org.webical.web.app.WebicalWebAplicationException: Could not retrieve > > > application settings for user: webical > > > at org.webical.web.app.WebicalSession.getUserSettings > > > (WebicalSession.java:158) > > > at org.webical.web.app.WebicalSession.getUserSettings > > > (WebicalSession.java:232) > > > at > > > org.webical.web.component.settings.UserSettingsPanel.setupCommonComponents > > > (UserSettingsPanel.java:73) > > > at org.webical.web.component.AbstractBasePanel.setupComponents > > > (AbstractBasePanel.java:113) > > > at org.webical.web.component.AbstractBasePanel.onBeforeRender > > > (AbstractBasePanel.java:223) > > > . > > > . > > > . > > > > I have to restart Tomcat to kill the session and be able to try to > > > login again, but the same cycle occurs. Upon further investigation I > > > get the following entry in the log: > > > > 2009-09-09 10:57:04,927 ERROR SettingsDaoHibernateImpl - Could not > > > retreive settings for user: org.webical.u...@10651eb > > > org.hibernate.QueryException: could not resolve property: user of: > > > org.webical.UserSettings > > > at > > > org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException > > > (AbstractPropertyMapping.java:43) > > > at org.hibernate.persister.entity.AbstractPropertyMapping.toType > > > (AbstractPropertyMapping.java:37)... > > > > This is clearly due to the fact that somewhere in the code the > > > application is trying to make a reference to a "user" colum. Since > > > "user" is a reserved world in oracle, the whole hibernate > > > configuration and its mappings in the classes had to be refactored. > > > All the "user" references were replaced with "user_settings". I would > > > have to scour the source to find this outdated reference. Perhaps the > > > Eclipse refactoring tool didn't catch it. > > > > On Sep 5, 3:25 am, Ivo van Dongen <[email protected]> wrote: > > > > > Hi, > > > > > Congratulations, seems like you're getting there. Debugging the log-in > > > > procedure is quite a pain I am sad to say. We choose to leave the login > > > > mechanism external, so it is managed by the container and can be easily > > > > swapped out. For tomcat it is managed in the context.xml file (either > > in > > > > src/main/webapp/META-INF or in the profile you choose to build the > > war). > > > > It looks like this: > > > > > <Context path="/webical-refactoring" docBase="webical" debug="5" > > reloadable="true" crossContext="true"> > > > > > <!-- The database resource for hibernate --> > > > > <Resource > > > > name="jdbc/calendarDataBase" > > > > auth="Container" > > > > type="javax.sql.DataSource" > > > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > > > > username="webical" > > > > password="webical" > > > > driverClassName="com.mysql.jdbc.Driver" > > > url="jdbc:mysql://localhost:3306/webical?autoReconnect=true" /> > > > > > </Context> > > > > > You need to substitute the driver, url, username and password with your > > > > own values depending on your setup. Now for debugging it you have to > > > > place debug="99" either on the context or resource element, forgot > > witch > > > > one. Then the logging to catalina.out will be more verbose. > > > > > Good luck again, > > > > Ivo > > > > > On 9/4/09 11:50 PM, Marks Andre wrote: > > > > > > Well somehow I managed to mannualy set the correct configurations and > > > > > I'm able to attempt loging in to the application. I have the database > > > > > setup with the same schema model as the mysql example (with its > > oracle > > > > > variations). I'm trying to log in as the user webical but the login > > > > > attempt fails and redirects me back to the login page. What I hope to > > > > > find is where to look in terms of trying to debbug a loging attempt. > > I > > > > > know that it makes a http post to j_security_check but i havent able > > > > > to find my way from there. Thanks for any help in the matter. > > > > > > On Sep 2, 10:37 am, Marks Andre<[email protected]> wrote: > > > > > >> Hello, > > > > > >> I believe I have managed to configure the application to > > successfully > > > > >> validate start-up of the context with the Oracle database. As you > > > > >> mention Oracle has too many quirks to what otherwise should have > > been > > > > >> a transparent process. I have encountered another roadblock in which > > > > >> the application presents the following exception when trying to > > access > > > > >> the login page: > > > > > >> Unexpected RuntimeException > > > > >> Root cause:org.webical.web.app.WebicalWebAplicationException: Could > > > > >> not retrieve application settings for user: jag at > > > org.webical.web.app.WebicalSession.getUserSettings(WebicalSession.java: > > > > >> 158) at org.webical.web.app.WebicalSession.getUserSettings > > > > >> (WebicalSession.java:232) at > > > > >> org.webical.web.component.calendar.CalendarPanel.<init> > > > > >> (CalendarPanel.java:142) at > > org.webical.web.pages.BasePage$8.<init> > > > > >> (BasePage.java:343) > > > > > >> ... > > > > > >> I believe this is due to the fact that the application is still > > > > >> compiling in development mode (hence is performing the bootstrap of > > > > >> the development configuration). I read the pom.xml profiles and > > tried > > > > >> to utilize the -Denv=build switch but it then will complain that the > > > > >> "maven.test.skip=true" switch is not a valid profile or task. I > > wonder > > > > >> why if I just specify the -D switch it will let me disable the tests > > > > >> just fine but with the -Devn=build switch it will not. > > > > > >> On Sep 1, 10:56 am, Ivo van Dongen<[email protected]> wrote: > > > > > >>> Hi, > > > > > >>> Good to hear you're making progress. Hope you'll get there.> At > > first I > > > > > >>>> was a little confused by the command typos so for future reference > > to > > > > >>>> anyone reading, the command I used was: > > > > > >>>> mvn -D maven.test.skip=true package > > > > > >>> Strange. They weren't really typos. Don't know what went wrong > > there. > > > > >>> Thanks for the correction.> I know that my development methodology > > is not what > > > > > >>>> Webical intends but changing the database type doesn't seem to be > > as > > > > >>>> seamless. > > > > > >>> I thought it would be less involved indeed. I've changed around the > > > > >>> settings a bit in the past (postgress, derby and hsqldb) and that > > went > > > > >>> without any effort beside changing the configuration a bit. I > > didn't > > > > >>> think that oracle had so much quirks. But I haven't really made use > > of > > > > >>> it since version 8 or so.> Perhaps someone could point me in the > > right direction as to what I > > > > > >>>> would need to change depending on the > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "webical-developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/webical-developers?hl=en -~----------~----~----~----~------~----~------~--~---
