Win a copy of Head First Android this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

Errors running 2.1.6 under Oracle 9.2.0.6 / WebLogic 8.1 SP5

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Tried to insert a user with the 2.16 install running under Oracle 9.2.0.6 and received this error:


Any pointers on where I should start looking to resolve the problems?
[originally posted on jforum.net by thx1855]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Clean install.
[originally posted on jforum.net by thx1855]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oh, please do. Let's try to isolate the problem then!

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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]
 
reply
    Bookmark Topic Watch Topic
  • New Topic