I wander if it is right i post this issue here, however i still hope someone can help me work this out.
I just installed the JBoss Portal 2.0alpha; App Server:4.0.0 &4.0.1 Database My Sql 4.1.8 J Connector:mysql-connector-java-3.1.6-bin.jar installation Guide:http://www.jboss.org/wiki/Wiki.jsp?page=JBossPortal[http://www.jboss.org/wiki/Wiki.jsp?page=JBossPortal] When i access "First forum" or "Second Forum" it throws null poniter exception on webpage and I checked the server.log, it seems tell me: 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.impl.Printer] org.jboss.portlet.forums.impl.ForumImpl{type=0, category=CategoryImpl#1, order=20, topicSize=0, status=0, forumWatch=uninitialized, lastPost=null, pruneEnable=true, postSize=0, pruneNext=0, description=Second description, name=Second forum, topics=uninitialized, ID=2} 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.impl.Printer] org.jboss.portlet.forums.impl.CategoryImpl{title=Dummy demo category, order=1, forums=uninitialized, id=1} 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.impl.SessionImpl] Dont need to execute flush 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.hql.QueryTranslator] HQL: from org.jboss.portlet.forums.impl.TopicImpl as t where t.forum = :forumid and t.type <> :type order by t.lastPostDate desc 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.hql.QueryTranslator] SQL: select topicimpl0_.jbp_id as x0_0_ from jbp_forums_topics topicimpl0_ where (topicimpl0_.jbp_forum_id=? )and(topicimpl0_.jbp_type<>? ) order by topicimpl0_.jbp_last_post_date desc 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.SQL] select topicimpl0_.jbp_id as x0_0_ from jbp_forums_topics topicimpl0_ where (topicimpl0_.jbp_forum_id=? )and(topicimpl0_.jbp_type<>? ) order by topicimpl0_.jbp_last_post_date desc limit ? 2005-02-01 17:56:05,687 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement 2005-02-01 17:56:05,707 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485) at com.mysql.jdbc.ServerPreparedStatement.(ServerPreparedStatement.java:151) at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309) at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:355) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:205) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257) at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232) at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65) at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779) at net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:864) at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1609) at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27) at org.jboss.portlet.forums.impl.ForumsModuleImpl.findTopics(ForumsModuleImpl.java:331) at org.jboss.portlet.forums.impl.ForumsModuleImpl.findTopicsDesc(ForumsModuleImpl.java:381) at org.jboss.portlet.forums.ForumsPortlet.fillShowForumContext(ForumsPortlet.java:2197) at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:300) at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:169) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:159) at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:233) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeRequest(DispatcherInterceptor.java:143) at org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.java:171) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.core.portlet.cms.CMSInterceptor.invoke(CMSInterceptor.java:78) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.java:93) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:552) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510) at org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:58) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor.java:125) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.invocation.component.ModeInterceptor.invoke(ModeInterceptor.java:37) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.core.invocation.ConstrainedWindowStateInterceptor.invoke(ConstrainedWindowStateInterceptor.java:51) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.invocation.component.ParametersInterceptor.invoke(ParametersInterceptor.java:70) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.java:74) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:239) at org.jboss.portal.server.Component.invoke(Component.java:127) at org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.invoke(MainDispatcherInterceptor.java:159) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.invocation.portal.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:33) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewInterceptor.java:58) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.java:90) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214) at org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:239) at org.jboss.portal.server.PortalServer.invoke(PortalServer.java:195) at org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:58) at org.jboss.portal.core.servlet.CoreServlet.process(CoreServlet.java:201) at org.jboss.portal.core.servlet.CoreServlet.invoke(CoreServlet.java:101) at org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:53) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.portal.core.servlet.TransactionFilter$1.run(TransactionFilter.java:78) at org.jboss.portal.common.transaction.Demarcator.requiresNew(Demarcator.java:52) at org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoe(CustomPrincipalValve.java:66) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) 2005-02-01 17:56:05,707 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000 2005-02-01 17:56:05,717 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1 2005-02-01 17:56:05,717 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) Can someone help me work this out ? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3864535#3864535 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3864535 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
