hi, the following is what i got in my server log:
2005-02-01 09:22:28,721 DEBUG [net.sf.hibernate.hql.QueryTranslator] HQL: from
org.jboss.portal.core.impl.user.UserImpl
2005-02-01 09:22:28,721 DEBUG [net.sf.hibernate.hql.QueryTranslator] SQL:
select userimpl0_.jbp_uid as x0_0_ from jbp_users userimpl0_
2005-02-01 09:22:28,721 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to
open: 0 open PreparedStatements, 0 open ResultSets
2005-02-01 09:22:28,721 DEBUG [net.sf.hibernate.SQL] select userimpl0_.jbp_uid
as x0_0_ from jbp_users userimpl0_ limit ?
2005-02-01 09:22:28,721 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing
statement
2005-02-01 09:22:28,841 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:228)
at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:703)
at
net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:842)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1540)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
at
org.jboss.portal.core.impl.user.UserModuleImpl.findUsers(UserModuleImpl.java:163)
at
org.jboss.portal.core.portlet.user.UserPortlet.doView(UserPortlet.java:237)
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.invoke(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 09:22:28,861 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL
Error: 1064, SQLState: 42000
2005-02-01 09:22:28,861 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 09:22:28,861 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:228)
at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:703)
at
net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:842)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1540)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
at
org.jboss.portal.core.impl.user.UserModuleImpl.findUsers(UserModuleImpl.java:163)
at
org.jboss.portal.core.portlet.user.UserPortlet.doView(UserPortlet.java:237)
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.invoke(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 09:22:28,861 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL
Error: 1064, SQLState: 42000
2005-02-01 09:22:28,861 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 09:22:28,871 ERROR [net.sf.hibernate.util.JDBCExceptionReporter]
Could not execute query
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:228)
at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:703)
at
net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:842)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1540)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
at
org.jboss.portal.core.impl.user.UserModuleImpl.findUsers(UserModuleImpl.java:163)
at
org.jboss.portal.core.portlet.user.UserPortlet.doView(UserPortlet.java:237)
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.invoke(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 09:22:28,952 ERROR [org.jboss.portal.core.impl.user.UserModuleImpl]
Cannot find user range [0,11]
net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1543)
at net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
at
org.jboss.portal.core.impl.user.UserModuleImpl.findUsers(UserModuleImpl.java:163)
at
org.jboss.portal.core.portlet.user.UserPortlet.doView(UserPortlet.java:237)
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.invoke(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)
Caused by: 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:228)
at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:703)
at
net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:842)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1540)
... 96 more
2005-02-01 09:22:28,982 INFO [STDOUT]
org.jboss.portal.core.modules.ModuleException: Cannot find user range [0,11]
2005-02-01 09:22:28,982 INFO [STDOUT] at
org.jboss.portal.core.impl.user.UserModuleImpl.findUsers(UserModuleImpl.java:171)
2005-02-01 09:22:28,982 INFO [STDOUT] at
org.jboss.portal.core.portlet.user.UserPortlet.doView(UserPortlet.java:237)
2005-02-01 09:22:28,982 INFO [STDOUT] at
org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:169)
2005-02-01 09:22:28,982 INFO [STDOUT] at
org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:159)
2005-02-01 09:22:28,982 INFO [STDOUT] at
org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:233)
2005-02-01 09:22:28,982 INFO [STDOUT] at
org.jboss.portal.portlet.invocation.DispatcherInterceptor.invokeRequest(DispatcherInterceptor.java:143)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.portlet.invocation.DispatcherInterceptor.invoke(DispatcherInterceptor.java:171)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.core.portlet.cms.CMSInterceptor.invoke(CMSInterceptor.java:78)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.portlet.invocation.PreferencesInterceptor.invoke(PreferencesInterceptor.java:93)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:94)
2005-02-01 09:22:28,992 INFO [STDOUT] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2005-02-01 09:22:28,992 INFO [STDOUT] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2005-02-01 09:22:28,992 INFO [STDOUT] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2005-02-01 09:22:28,992 INFO [STDOUT] at
java.lang.reflect.Method.invoke(Method.java:324)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:51)
2005-02-01 09:22:28,992 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
2005-02-01 09:22:28,992 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:552)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.invocation.component.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:58)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.core.invocation.AccessControlInterceptor.invoke(AccessControlInterceptor.java:125)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.invocation.component.ModeInterceptor.invoke(ModeInterceptor.java:37)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:28,992 INFO [STDOUT] at
org.jboss.portal.core.invocation.ConstrainedWindowStateInterceptor.invoke(ConstrainedWindowStateInterceptor.java:51)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.invocation.component.ParametersInterceptor.invoke(ParametersInterceptor.java:70)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.invocation.component.CacheInterceptor.invoke(CacheInterceptor.java:74)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:239)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.Component.invoke(Component.java:127)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.invocation.portal.MainDispatcherInterceptor.invoke(MainDispatcherInterceptor.java:159)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.invocation.portal.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:33)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.core.invocation.ViewInterceptor.invoke(ViewInterceptor.java:58)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.core.invocation.UserContextInterceptor.invoke(UserContextInterceptor.java:90)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:214)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.impl.invocation.InvocationImpl.invokeNext(InvocationImpl.java:239)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.PortalServer.invoke(PortalServer.java:195)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.servlet.AbstractMainServlet.invoke(AbstractMainServlet.java:58)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.core.servlet.CoreServlet.process(CoreServlet.java:201)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.core.servlet.CoreServlet.invoke(CoreServlet.java:101)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.jboss.portal.server.servlet.AbstractMainServlet.doGet(AbstractMainServlet.java:53)
2005-02-01 09:22:29,002 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
2005-02-01 09:22:29,002 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
2005-02-01 09:22:29,002 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.portal.core.servlet.TransactionFilter$1.run(TransactionFilter.java:78)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.portal.common.transaction.Demarcator.requiresNew(Demarcator.java:52)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.portal.core.servlet.TransactionFilter.doFilter(TransactionFilter.java:74)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2005-02-01 09:22:29,012 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
2005-02-01 09:22:29,022 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
2005-02-01 09:22:29,022 INFO [STDOUT] Caused by:
net.sf.hibernate.JDBCException: Could not execute query
2005-02-01 09:22:29,022 INFO [STDOUT] at
net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1543)
2005-02-01 09:22:29,022 INFO [STDOUT] at
net.sf.hibernate.impl.QueryImpl.iterate(QueryImpl.java:27)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.jboss.portal.core.impl.user.UserModuleImpl.findUsers(UserModuleImpl.java:163)
2005-02-01 09:22:29,022 INFO [STDOUT] ... 94 more
2005-02-01 09:22:29,022 INFO [STDOUT] Caused by: 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
2005-02-01 09:22:29,022 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
2005-02-01 09:22:29,022 INFO [STDOUT] at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
2005-02-01 09:22:29,022 INFO [STDOUT] at
com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
2005-02-01 09:22:29,022 INFO [STDOUT] at
com.mysql.jdbc.ServerPreparedStatement.(ServerPreparedStatement.java:151)
2005-02-01 09:22:29,022 INFO [STDOUT] at
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
2005-02-01 09:22:29,022 INFO [STDOUT] at
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
2005-02-01 09:22:29,022 INFO [STDOUT] at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:355)
2005-02-01 09:22:29,032 INFO [STDOUT] at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:205)
2005-02-01 09:22:29,032 INFO [STDOUT] at
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:228)
2005-02-01 09:22:29,032 INFO [STDOUT] at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
2005-02-01 09:22:29,032 INFO [STDOUT] at
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:703)
2005-02-01 09:22:29,032 INFO [STDOUT] at
net.sf.hibernate.hql.QueryTranslator.iterate(QueryTranslator.java:842)
2005-02-01 09:22:29,032 INFO [STDOUT] at
net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1540)
2005-02-01 09:22:29,032 INFO [STDOUT] ... 96 more
2005-02-01 09:22:29,282 DEBUG [net.sf.hibernate.impl.SessionImpl] running
Session.finalize()
Thanks again for the help
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3864484#3864484
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3864484
-------------------------------------------------------
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
