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

java.lang.reflect.InvocationTargetException

 
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,

I'm working with JForum 2.1.8 and PostgreSQL 7.4 running on SuSE Linux Enterprise Server 9 on a POWER 5+ 64 bits machine.

JForum runs well during several days, but now when I create a new post I recive this message

<!-- BEGIN ERROR STACK TRACE <br /> net.jforum.exceptions.ForumException: java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) <br /> at java.lang.reflect.Method.invoke(Method.java:618) <br /> at net.jforum.Command.process(Command.java:114) <br /> at net.jforum.JForum.processCommand(JForum.java:217) <br /> at net.jforum.JForum.service(JForum.java:200) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) <br /> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989) <br /> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:766) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:674) <br /> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498) <br /> at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464) <br /> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90) <br /> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744) <br /> at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455) <br /> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113) <br /> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454) <br /> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383) <br /> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102) <br /> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) <br /> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) <br /> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) <br /> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136) <br /> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195) <br /> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743) <br /> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873) <br /> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469) <br /> Caused by: java.lang.reflect.InvocationTargetException <br /> ... 34 more <br /> Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: ERROR: duplicate key violates unique constraint "jforum_topics_pkey" <br /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471) <br /> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256) <br /> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175) <br /> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392) <br /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330) <br /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282) <br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:118) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:112) <br /> at net.jforum.dao.generic.GenericTopicDAO.addNew(GenericTopicDAO.java:351) <br /> at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1101) <br /> ... 34 more <br /> Caused by: java.sql.SQLException: ERROR: duplicate key violates unique constraint "jforum_topics_pkey" <br /> ... 45 more <br /> <br /> URL is: /jforum/jforum.page?null <br /> END ERROR STACK TRACE-->


Any idea?

Thanks a lot
[originally posted on jforum.net by gardan]
 
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
Solved,

The problem was that the PostgreSQL database was reset the sequence number files.

Also I changed the JDBC driver to pg74.216.jdbc3.jar.


Regards,
Dani
[originally posted on jforum.net by gardan]
 
reply
    Bookmark Topic Watch Topic
  • New Topic