Error adding a new category

[Migrated From Jforum.net]

When i try to add a new category to my jorum installed just now, i see this error. Any help is appreciated.:
An error has ocurred. For detailed stack trace, please see the page's source code.

jrun.sql.JRunConnectionHandle.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement;
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

here is the stack it shows when i viewed page source. I'm using a datasource.

<!-- BEGIN ERROR STACK TRACE <br /> java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) <br /> at java.lang.reflect.Method.invoke(Method.java:324) <br /> at net.jforum.Command.process(Command.java:106) <br /> at net.jforum.view.admin.CategoryAction.process(CategoryAction.java:238) <br /> at net.jforum.JForum.service(JForum.java:298) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) <br /> at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) <br /> at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) <br /> at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249) <br /> at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) <br /> at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) <br /> at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457) <br /> at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) <br /> Caused by: java.lang.AbstractMethodError: jrun.sql.JRunConnectionHandle.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement; <br /> at net.jforum.drivers.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:105) <br /> at net.jforum.drivers.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:117) <br /> at net.jforum.drivers.generic.CategoryModel.addNew(CategoryModel.java:171) <br /> at net.jforum.view.admin.CategoryAction.insertSave(CategoryAction.java:157) <br /> ... 15 more <br /> <br /> END ERROR STACK TRACE-->
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

What's the VM version are you using? This is a problem with the JRun's SQL implementation stuff.

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

[Migrated From Jforum.net]

i'm using jdk1.4.2. how can i fix the problem?
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

the above post was from me. To be more specific, I'm using: j2sdk1.4.2_07.

I was able to add groups without any problem. i did delete the category without issue. But, when i'm adding a category, then only i'm having issue. "add category" and "add group" functions were implemented differently in jforum? JRun is a J2EE 1.3 certified product, do you think they implemented something different than J2EE standards?



[originally posted on jforum.net by balakiran]

[Migrated From Jforum.net]

Relax, I just asked. I have seen JForum running on Jetty, Resin, JBoss (3 and 4), Websphere and Oracle produtcts. And, because the exception

 Caused by: java.lang.AbstractMethodError: jrun.sql.JRunConnectionHandle.prepareStatement(Ljava/lang/String;I)Ljava/sql/PreparedStatement; 

which points to some stuff inside JRun's core, I though it could be some problem with jdk version or whatever.

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

[Migrated From Jforum.net]

well, this is wrecking my brains off for past few days. It seems like only "adding category" is having problems. I wonder how this functionality alone is not compatible with jrun's "core". if I want to add categories manually in the database, will it do just adding in that particular table? i tried, but somehow the new category is not showing up in the admin interface. Is there anywhere else i should add?

Any help is appreciated.
[originally posted on jforum.net by balakiran]

[Migrated From Jforum.net]

Ok balakiran, I found and fixed the problem. It is in fact a problem with JRun.

The main point is that JRun comes with an outdated mysql driver, and it ignores the driver that comes with JForum. So, in order to solve the problem, please do this:

:arrow: Stop JRun

:arrow: Open JRUN_ROOT/lib/macromedia_drivers.jar with any tool (I used winrar)

:arrow: Delete the directory org\gjt\....

:arrow: Unpack the file mysql-connector-java-3.1.4-beta-bin.jar from JForum's WEB-INF/lib

:arrow: Add the directories (and subdirectories, of course )"org" and "com" to "macromedia_drivers.jar"

:arrow: Start JRun, and JForum will work fine now.

Hope this helps. I downloaded JRun, read the docs and give some time of my Sunday to work on this issue ;)

Rafael
ps: I tested it with JRun 4
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Ok Great, i really appreciate your help. I did break my head during weekend and did update the macromedia_drivers.jar with mysql, but didnt update com. After I updated com also, it is working great.

Thank you again.


[originally posted on jforum.net by balakiran]