aspose file tools*
The moose likes JForum and the fly likes JForum with Oracle 10i and WebSphere Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "JForum with Oracle 10i and WebSphere" Watch "JForum with Oracle 10i and WebSphere" New topic
Author

JForum with Oracle 10i and WebSphere

Gardner Buchanan
Greenhorn

Joined: Jan 18, 2012
Posts: 4
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.


Gardner
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42289
    
  64
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.


Ping & DNS - my free Android networking tools app
Gardner Buchanan
Greenhorn

Joined: Jan 18, 2012
Posts: 4
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
Marshal

Joined: Mar 22, 2005
Posts: 42289
    
  64
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.
 
Don't get me started about those stupid light bulbs.
 
subject: JForum with Oracle 10i and WebSphere