Can't create new topics in JForum 2.1.7

[Migrated From Jforum.net]

Have just installed JForum 2.1.7 with Oracle 10g. Unfortunately I'm not able to create new topics in the forum. Getting this error:

ORA-01006: bind variable does not exist

Does this means that JForum are trying to issue a bind call for a variable that are not listed in the corresponding SQL statement?

The full stack trace:

06:35:17,144 ERROR [ExceptionWriter     ] net.jforum.exceptions.ForumException: 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:117)
	at net.jforum.JForum.processCommand(JForum.java:220)
	at net.jforum.JForum.service(JForum.java:203)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.InvocationTargetException
	... 23 more
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: ORA-01006: bind variable does not exist

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
	at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)
	at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	at net.jforum.dao.generic.GenericPostDAO.addNewPostText(GenericPostDAO.java:308)
	at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:287)
	at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1114)
	... 23 more
Caused by: java.sql.SQLException: ORA-01006: bind variable does not exist

	... 36 more

[originally posted on jforum.net by Christer]

[Migrated From Jforum.net]

Strange I have installed JForum with Oracle. But in the log I get this information on startup:

10:59:14,401  INFO [FileMonitor] Watching C:\Tomcat 6\webapps\jforum/WEB-INF/config/languages/en_US.properties
10:59:14,511  INFO [ConfigLoader] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
10:59:15,136  INFO [FileMonitor] Watching C:\Tomcat 6\webapps\jforum/WEB-INF/config/database/generic/generic_queries.sql
10:59:15,136  INFO [FileMonitor] Watching C:\Tomcat 6\webapps\jforum/WEB-INF/config/database/oracle/oracle.sql
10:59:15,151  INFO [FileMonitor] Watching C:\Tomcat 6\webapps\jforum/WEB-INF/config/SystemGlobals.properties
10:59:15,151  INFO [FileMonitor Watching C:\Tomcat 6\webapps\jforum/WEB-INF/config/jforum-custom.conf

So I thought, why are JForum loading MysqlDataAccessDriver?

Found the setting in jforum-custom.conf file. Changed it to

dao.driver=net.jforum.dao.oracle.OracleDataAccessDriver

Now I get a different error when creating a new topic:

Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Unsupported feature
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
	at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
	at oracle.sql.BLOB.setBinaryStream(BLOB.java:1016)
	at net.jforum.dao.oracle.OracleUtils.writeBlobUTF16BinaryStream(OracleUtils.java:128)
	at net.jforum.dao.oracle.OraclePostDAO.addNewPostText(OraclePostDAO.java:76)
	at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:287)
	at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1114)
	... 23 more
Caused by: java.sql.SQLException: Unsupported feature
	... 32 more

I'm confused here. Did the installer miss some other settings as well? How stable are JForum on Oracle anyway :?

[originally posted on jforum.net by Christer]

[Migrated From Jforum.net]

Hi,

looks like your Oracle JDBC Driver is not up to date.
Just download the latest version from oracle's website.
[originally posted on jforum.net by Five-O]

[Migrated From Jforum.net]

looks like your Oracle JDBC Driver is not up to date.

I'm using the latest oracle Drivers - ojdbc14.jar. It's the same that comes with JForum.



[originally posted on jforum.net by Christer]

[Migrated From Jforum.net]

Five-O - you're right and I'm wrong ops:

I did use JForums Oracle drivers. But it turned out that JForum 2.1.7 comes with an old odjbc14.jar :?:

Switched to the latest drivers and now I can start play with my new forum


[originally posted on jforum.net by Christer]