• 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

Error adding a new category

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
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'm using jdk1.4.2. how can i fix the problem?
[originally posted on jforum.net by Anonymous]
 
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
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Relax, I just asked. I have seen JForum running on Jetty, Resin, JBoss (3 and 4), Websphere and Oracle produtcts. And, because the exception



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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
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 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
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 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]
reply
    Bookmark Topic Watch Topic
  • New Topic