Help coderanch get a
new server
by contributing to the fundraiser
  • 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Can't insert to db on JRun4

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have completed installation of JForum 2.1.7 on JRun4 with Oracle10g. When I try to insert fields, like users or categories, to the database I get this error:

"jrun.sql.JRunConnectionHandle.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement;"

When trying to update fields theres no problem.

I have searched through this forum and found an article that discusses the same problem: https://coderanch.com/t/575157

Unfortunaly the solution in that article doesn't work for me. Anybody familiar with this problem?

[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
You'll have to stop using macromedia's version of the Oracle driver, and use the jar provided by Oracle (that comes with JForum).

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
But I'm not using Macromedias Oracle driver. At least I do all I can not to.

When creating the datasource for JForum in JRun I choose the Oracle Thin Driver (oracle.jdbc.driver.OracleDriver) and not the JRun version.

In JRuns classpath I include a path to the Oracle Driver (ojdbc14.jar - I belive thats the same that comes with JForum). To be really sure I also place the oracle drivers in JRuns lib catalouge.

So I can't see how the Macromedia driver could be used here... :?
[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
Yes, you're, because of this error:



JRun is using it in some way.

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
After tearing my hair up by the roots for a week I gave up and installed JForum on Tomcat instead.

Got the same error (well, the same behavior). Take a look here: http://www.jforum.net/posts/list/0/3466.page

Turned out that dabatase.support.autokeys was set to "true" in my jforum-custom.conf. Changing it to "false" did the trick. Now it also works on JRun4
[originally posted on jforum.net by Christer]
 
What's gotten into you? Could it be this tiny ad?
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic