Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS 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:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Can't create new topics in JForum 2.1.7

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Have just installed JForum 2.1.7 with Oracle 10g. Unfortunately I'm not able to create new topics in the forum. Getting this error:

ORA-01006: bind variable does not exist

Does this means that JForum are trying to issue a bind call for a variable that are not listed in the corresponding SQL statement?

The full stack trace:




[originally posted on jforum.net by Christer]
 
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 I have installed JForum with Oracle. But in the log I get this information on startup:



So I thought, why are JForum loading MysqlDataAccessDriver?

Found the setting in jforum-custom.conf file. Changed it to

Now I get a different error when creating a new topic:



I'm confused here. Did the installer miss some other settings as well? How stable are JForum on Oracle anyway :?

[originally posted on jforum.net by Christer]
 
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
Hi,

looks like your Oracle JDBC Driver is not up to date.
Just download the latest version from oracle's website.
[originally posted on jforum.net by Five-O]
 
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

looks like your Oracle JDBC Driver is not up to date.



I'm using the latest oracle Drivers - ojdbc14.jar. It's the same that comes with JForum.



[originally posted on jforum.net by Christer]
 
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
Five-O - you're right and I'm wrong ops:

I did use JForums Oracle drivers. But it turned out that JForum 2.1.7 comes with an old odjbc14.jar :?:

Switched to the latest drivers and now I can start play with my new forum


[originally posted on jforum.net by Christer]
 
reply
    Bookmark Topic Watch Topic
  • New Topic