Hi Eric, Comments inline below...
On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
first of all, i have found out that in the HibernateRefererManagerImpl.java class, there is a mistake with the oracle dialect (oracleDialect instead of oracle9Dialect). This make the home page of Roller crash. If i change it in the hibernate.cfg.xml, a lot of other things don't work anymore. Maybe this could be fixed in the next release?
I wish I could be more helpful, but I don't use Oracle. In Roller 2.3, the HibernateRefererManagerImpl.getDaysPopularWebsites() method uses a special case for the "OracleDialect" -- are you saying that we need another special case for the "Oracle9Dialect"? As a workaround, you could get the code for 2.3 change the one line that references OracleDialect and then create a build. It's not that hard to do -- I could talk you through it. By the way, the code in HibernateRefererManagerImpl.getDaysPopularWebsites() has been rewritten in Roller 3.0 to use Hibernate instead of raw SQL -- that should eliminate the Oracle problem that you mention becase we no longer have any special cases for different types of databases.
I have a very strange issue with all the server properties loading code. The best way to see it is to go on the "server configuration" page. This page loads blank (all fields empty). The database is ok. I've forced roller to display the parameters list retrieved, and all parameters are set to null as you can see it here after :
I'm not sure what's going on with properties, but I seem to remember somebody saying that Oracle tests nulls in a special way. Anybody remember issues with Oracles and nulls? - Dave
