Hello,
I set up JForum to use an Oracle DataSource that I configured in
Tomcat. It's definitely connecting to Oracle, but when I create a new post to my forum, it blows up. The problem is that there seems to be some confusion between the
Java class that runs the query and the query that it's using.
I get this stack trace:
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5360)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5352)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
at net.jforum.dao.generic.GenericPostDAO.addNewPostText(GenericPostDAO.java:311)
at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:291)
I'm not sure which sql it's running, but the oracle.sql file specifies only two parameters to the query; GenericPostDAO attempts to set 3. I'm guessing it should be using OraclePostDAO instead of GenericPostDAO.
I have
database.driver.name=oracle
in oracle.properties, jforum-custom.conf, and oracle.properties.
I ran install.jsp first, and it had the same error when that tried to create an "initial" post to the default forum or something. So I blew the tables away and did a manual install.
Any suggestions?
[originally posted on jforum.net by bazoople]
