JForum with Oracle 10i and WebSphere

[Gardner Buchanan]

I've seen a few other JForum discussions in this forum and I know there are some JForum experts here amongst the admins.

I have JForum 2.1.9 deployed in WebSphere 7. I have a WAS datasource configured to point to an Oracle 10i database.
JForum deploys and I can run the install.jsp. JForum finds the connection and I can see that several tables and sequences are created.
But the configuration process ultimately fails with "java.lang.ArrayIndexOutOfBoundsException" thrown by oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)

I'm kind of at a loss what could be wrong. Is there an issue with my Oracle version or the Oracle JDBC driver version maybe?

Thanks for any ideas.

[Ulf Dittmer]

When we switched to JForum it had explicit support for MySQL and PostgreSQL, but nothing else. I don't think that changed from 2.1.8 (which we forked) to 2.1.9. In other words - there is DB-specific stuff in it, and most likely nobody ever ported that to Oracle. It probably would not take much to make the SQL standards-compliant, but nobody at JavaRanch ever made an effort to look into that, since we're a Postgres-only shop. The JForum folks can probably provide more insight into this.

[Gardner Buchanan]

Thanks, but I do believe Oracle is meant to be supported -- both 2.1.8 and 2.1.9 -- which seem very similar -- have explicit support for Oracle. The install.jsp includes Oracle as a choice on the dropdown menu. The instructions on http://jforum.net/install_no_wizard.jsp definitely list Oracle in a number of places. In the class directory tree I see oracle specific classes, jars and properties.

[Ulf Dittmer]

I stand corrected. Let me clarify what I do know for certain about the code base: it does have special code for MySQL and PostgreSQL. Seeing the link you posted, I guess Oracle is supposed to work without any of that (good for Oracle!). In that case, I have no clue what's happening (and, I'm fairly certain, nobody of the folks here who work on the forum software does either, because none of us run it on Oracle). Sorry for the confusion.