Errors running 2.1.6 under Oracle 9.2.0.6 / WebLogic 8.1 SP5

[Migrated From Jforum.net]

Tried to insert a user with the 2.16 install running under Oracle 9.2.0.6 and received this error:

Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.

Any pointers on where I should start looking to resolve the problems?
[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

This problem is not related to Oracle itself. Take a look here:

https://coderanch.com/t/574500

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Thanks for the X11 tip.

I'm also running into an issue when creating Categories. When I try to create a a category I receive the error message "Unsupported feature"

I am able to create rankings, save the configuration, and login so some of the SQL calls are working. Current config has JForum running under BEA WebLogic 8.1 SP5 connecting to Oracle via a Datasource. I ran version 2.1.4 under WebLogic w/no Oracle (just the default database) and it ran fine.

[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

Open your WEB-INF/config/database/oracle/oracle.properties and see if you have the key "database.support.autokeys" set to "false".

Also check WEB-INF/config/jforum-custom.conf

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Rafael Steil wrote:Open your WEB-INF/config/database/oracle/oracle.properties and see if you have the key "database.support.autokeys" set to "false".

Also check WEB-INF/config/jforum-custom.conf

Rafael

OK, oracle.properties was set correctly and I updated the jforum-custom.conf file so now I can create categories & forums.

Tried to create a new topic & received "Invalid column index"
[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

Did you do a fresh new install, or an upgrade from a previous version?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Clean install.
[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

Strange.. the package available for download has the right configurtion file, and I can run it fine on Oracle 10g...

Raafel
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Aye, strange indeed. When the jforum-custom.conf file is created where does it get that autokeys value from? the oracle.properties file?

I can wipe it out and do a fresh install again to see what happens...
[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

Oh, please do. Let's try to isolate the problem then!

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Performed a clean install & everything is working great except when I attempt to post a topic. I now received the error message

"Invalid column index"

I am using the DataSource option.
[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

Ok, I'll investigate further.

Can you please register this bug at http://www.jforum.net/jira ? Thanks a lot

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

bug report posted. where would i look to investigate the SQL statements & database settings - my money is that it is something simple.
[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

From my logs I see:

1) INFO [ConfigLoader] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
- I'm running Oracle, should I still see that message?

2) Stock error msg from the log...
Caused by: java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4666)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4629)
at weblogic.jdbc.wrapper.PreparedStatement.setString(PreparedStatement.java:638 )
at net.jforum.dao.generic.GenericPostDAO.addNewPostText(GenericPostDAO.java:248 )
at net.jforum.dao.generic.GenericPostDAO.addNew(GenericPostDAO.java:235 )
at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1086 )




[originally posted on jforum.net by thx1855]

[Migrated From Jforum.net]

thx1855 wrote:From my logs I see:

1) INFO [ConfigLoader] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
- I'm running Oracle, should I still see that message?

Hmm.. looks like the database settings are wrong. Open your jforum-custom.conf (web-inf/config) and search for the key "database.driver.name". It should be "oracle". If you don't have this file or the key does not exist, look at SystemGlobals.properties

Rafael
[originally posted on jforum.net by Rafael Steil]