Can't insert to db on JRun4

[Migrated From Jforum.net]

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]

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]

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]

Yes, you're, because of this error:

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

JRun is using it in some way.

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

[Migrated From Jforum.net]

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]