Oracle error

[Migrated From Jforum.net]

Hi,

After installing JForum 2.1.5 using oracle 10g the test forum is not there. After manually adding the forum I am unable to make a post. I get the following error message:

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

oracle.sql.BLOB

And the following stacktrace is given:

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at net.jforum.Command.process(Command.java:116)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.ClassCastException: oracle.sql.BLOB
at net.jforum.dao.oracle.OracleUtils.writeBlobUTF16BinaryStream(OracleUtils.java:111)
at net.jforum.dao.oracle.OraclePostDAO.addNewPostText(OraclePostDAO.java:70)
at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:235)
at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1075)
... 24 more

Thanks,

Alan
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Which JDBC Driver version are you using?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Hi,

I am using ojbc 1.4. What version should I be using?

Thanks,

Alan
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

1.4? Ok, I guess you mean, ojdbc14.jar.

If you are using Tomcat, please take a look in the directory <TOMCAT_HOME>/common/lib.. see if there is any other oracle jar there.

It looks like a conflict.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

OK, I deleted the ojdbc14.jar file from jforum\WEB-INF\lib and now it works! Thanks! Any idea why the test forum is not created when the forum is installed using oracle?

Thanks so much,

Alan
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Because there isn't any procedure to create it ;).

Post text data is written into a blob field, and as it is not possible to easily insert data into it from a .sql script, I left it from the installer.

Maybe in some future release...

Rafael
[originally posted on jforum.net by Rafael Steil]