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 scenarios (test, QA, Dev, Prod)
> > >>>> and maybe what maven tasks to run etc. Thanks for any help and
> > >>>> invested time.
>
> > >>> Well, there is a standard way of doing this indeed. I suggest you read
> > >>> up a bit on maven as the problems you are encountering so far are really
> > >>> basic maven stuff. But on the other hand, you can always ask here, it's
> > >>> no problem to help out.
> > >>> They way we go about managing the different configurations is through
> > >>> the use of maven profiles. The configurations can be found under /etc.
> > >>> These are copied over the exploded war before packaging depending on
> > >>> which profile is selected (default none I think). Activation of a
> > >>> profile is done through the use of an extra parameter: -Denv=... You can
> > >>> find out what to use by checking out the profiles section of the pom.xml
> > >>> file.
>
> > >>> If I need to be more specific, just let me know.
>
> > >>> Regards,
> > >>> Ivo van Dongen
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
