[Building Sakai] Jforum 2.6.4 and Oracle

[Stephen Jaegle]

Hi all:

I just installed JForum 2.6.4 in a test instance connected to Oracle (10g, I
believe), and it appears to be running properly for the most part. I was
able to access the configure screen and users can post and read messages.
When the update button is clicked when grading a message, a sql exception
occurs.

There was no previous instance of JForum installed; after experiencing the
sql exception, I dropped all tables and allowed them to be rebuilt on the
next launch, but obtained the same result as follows: 

DEBUG: Module is gradeForum (2009-08-21 19:55:13,091
http-8080-Processor23_org.etudes.jforum.JForum)
DEBUG: Entering command processing (2009-08-21 19:55:13,091
http-8080-Processor23_org.etudes.jforum.JForum)
DEBUG: Action = evaluateForumUser (2009-08-21 19:55:13,091
http-8080-Processor23_org.etudes.jforum.Command)
DEBUG: Running command on org.etudes.jforum.view.forum.GradeAction with
method evaluateForumUser (2009-08-21 19:55:13,091
http-8080-Processor23_org.etudes.jforum.Command)
DEBUG: checkAndAddCourseCategoriesForumsToCache() : course categories are in
cache..... :  (2009-08-21 19:55:13,095
http-8080-Processor23_org.etudes.jforum.repository.ForumRepository)
...
followed by two iterations of:
...
ERROR: an error occured in JForum.service():
java.lang.reflect.InvocationTargetException (2009-08-21 19:55:13,124
http-8080-Processor23_org.etudes.jforum.JForum)
java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
...
Caused by: 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.setTimestampInternal(OraclePreparedStatement.java:7629)
	at
oracle.jdbc.driver.OraclePreparedStatement.setTimestamp(OraclePreparedStatement.java:7603)
	at
org.apache.commons.dbcp.DelegatingPreparedStatement.setTimestamp(DelegatingPreparedStatement.java:144)
	at
org.etudes.jforum.dao.generic.GenericEvaluationDAO.addNew(GenericEvaluationDAO.java:103)
	at
org.etudes.jforum.view.forum.GradeAction.evaluateForumUser(GradeAction.java:921)
	... 48 more

I suspect that some combination of tables and fields may be missing. What is
a good place to look to verify that the tables are set up correctly? Right
now I'm assuming that everything called for in
WEB-INF/config/database/oracle/oracle_db_struct.sql is being created
properly.

Thanks,

Steve
-- 
View this message in context: http://www.nabble.com/Jforum-2.6.4-and-Oracle-tp25089454p25089454.html
Sent from the Sakai - Development mailing list archive at Nabble.com.