• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

Oracle Installation issues

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I tried installing JForum in two diffent Oracle databases 8.1.7 and now 10g and I was unable to get the installer to work, so I had to resort to manual installation.
The automatic installer was complaining about some methods not being implemented in the driver and quite weird messages, so I tried the manual way.

After installing it manually, no problem with that, when I start the forum I can see at the console:


...
INFO [ConfigLoader ] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
...
INFO [FileMonitor ] Watching D:\Apps\cvs\MedexForum\/WEB-INF/config/database/oracle/oracle.sql
...



And that made me thought and I rememebered reading something like that during the installation. Shouldn't it be net.jforum.dao.oracle.OracleDataAccessDriver as specified in the oracle.properties file?

The forum seems to work and it is reading the oracle.sql file, so I think I set it up correctly (I used oracle as database name) but it still reports MysqlDataAccessDriver as the one being used.

Is that simply a bad logging error? Or should it report the appropriate one?

Thanks
D.
[originally posted on jforum.net by GreenEyed]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I *guess* it is bad logging, because of an helper class, specific for mysql, that always run when JForum starts. If the forum is working for you, then great.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In the end, I think it was a problem of the installation script creating an incorrect jforum-custom.conf file. I did not know it had been created so after the manual installation, it was still there.

To be more precise, after selecting "oracle" in the installation page, the jforum-custom.conf contained

dao.driver=net.jforum.dao.mysql.MysqlDataAccessDriver

so it was loading the wrong driver for my db. I guess that's also why the automatic installation script failed.

The forum started with this, but it created other problems for me down the road until I changed the value to the proper one with help from this forum.

So, it's not a wrong logging issue but I suspect it is a problem with the installation script putting the wrong value in jforum-custom.conf.

Anyway, now it's working fine with Oracle.

Thx
[originally posted on jforum.net by GreenEyed]
 
reply
    Bookmark Topic Watch Topic
  • New Topic