#31 JForum doesn't start after manual installation with oracle database.

[Anonymous]

Originally created by: peter.ri...@gmail.com
Originally owned by: peter.ri...@gmail.com

What steps will reproduce the problem?
1. Manual install for oracle, run ddl and init scripts.
2. open browser and go to: http://localhost:8080/jforum/forums/list.page
3.

What is the expected output? What do you see instead?

Expectation is the forum start page. Instead the following exception is shown:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet.init() for servlet jforum threw exception
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    java.lang.Thread.run(Thread.java:619)

root cause

net.jforum.exceptions.ForumStartupException: Error while starting JForum
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Class.java:169)
    net.jforum.ConfigLoader.loadDaoImplementation(ConfigLoader.java:216)
    net.jforum.JForum.startApplication(JForum.java:329)
    net.jforum.JForum.init(JForum.java:112)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    java.lang.Thread.run(Thread.java:619)

root cause

net.jforum.exceptions.ForumException: java.lang.NullPointerException
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Class.java:169)
    net.jforum.ConfigLoader.loadDaoImplementation(ConfigLoader.java:216)
    net.jforum.JForum.startApplication(JForum.java:329)
    net.jforum.JForum.init(JForum.java:112)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    java.lang.Thread.run(Thread.java:619)

root cause

java.lang.NullPointerException
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Class.java:169)
    net.jforum.ConfigLoader.loadDaoImplementation(ConfigLoader.java:216)
    net.jforum.JForum.startApplication(JForum.java:329)
    net.jforum.JForum.init(JForum.java:112)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    java.lang.Thread.run(Thread.java:619)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.32 logs.

--------------------------

I think that the problem is that the additional oracle database properties file is not used.

If I include the following line in JForum.startApplication():

SystemGlobals.loadAdditionalDefaults(SystemGlobals.getValue(ConfigKeys.DATABASE_DRIVER_CONFIG));

Then JForum starts OK.

The same initialization is done in the TestCaseUtils.initDatabaseImplementation() method, so I think it should be done in application startup as well.

[Anonymous]

Originally posted by: peter.ri...@gmail.com

This issue was updated by revision [r182].

This fixes the issue. Please review and close. Note I felt that creating a testcase for this is not practical, so there are no testcase for this.

[Anonymous]

Originally posted by: andow...@gmail.com

Did you follow the steps listed in https://code.google.com/p/jforum2/wiki/ManualInstallation ?
Besides running the database part, you need to edit the config file(SystemGlobals.properties or jforum-custom.conf).

The problem is that JForum use Oracle Blob type to store post, and the oracle_data_dump.sql doesn't contain three SQL statements in the Demostration Forum section:
INSERT INTO jforum_topics
INSERT INTO jforum_posts
INSERT INTO jforum_posts_text
They are executed in the InstallAction.java during auto installation.
So the fix should be to remove the following line from oracle_data_dump.sql:
INSERT INTO jforum_forums
and execute this in the InstallAction.java when using auto installation.

[Anonymous]

Originally posted by: andow...@gmail.com

Fixed in revision [r188].
You'll need to add a config key installed=true in jforum-custom.conf file after manual installation.

Status: Fixed