java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1

Apereo Issues | Vladimir Potapov | 1 decade ago
  1. 0

    I have downloaded uportal 2.4.patch from cvs,and I have the exception ,when I started uPortal INFO: Server startup in 20653 ms INFO [http-9091-Processor25] portal.RDBMServices.[] Aug/31 11:31:37 - MySQL/com.mysql.jdbc.Driver (mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )) database/driver supports: Prepared statements=true, Outer joins=true, Transactions=true, '{ts' metasyntax=true, TO_DATE()=false INFO [http-9091-Processor25] groups.GroupServiceConfiguration.[] Aug/31 11:31:38 - Group services: Parsing group service configuration. INFO [http-9091-Processor25] groups.RDBMEntityGroupStore.[] Aug/31 11:31:38 - RDBMEntityGroupStore.initialize(): Node separator set to . INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.sweepInterval] was requested but not found. ERROR [http-9091-Processor25] layout.AggregatedUserLayoutStore.[] Aug/31 11:31:39 - Error getting aggregated layout for user org.jasig.portal.security.provider.PersonImpl@3461d1 java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 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.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.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) ERROR [http-9091-Processor25] layout.AggregatedLayoutManager.[] Aug/31 11:31:39 - Exception loading user layout java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 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.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.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) ERROR [http-9091-Processor25] portal.ExceptionHelper.[] Aug/31 11:31:39 - Programming error java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) Caused by: org.jasig.portal.PortalException: Exception loading user layout: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1] [based on exception: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1]] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 35 more I have found the place in SQL in AggregatedUserLayoutStore // The query for getting information of the fragments String sqlFragment = "SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID"; if (RDBMServices.supportsOuterJoins) { sqlFragment += ",UFP.PARAM_NAME,UFP.PARAM_VALUE FROM UP_LAYOUT_STRUCT_AGGR ULS, " + fragmentJoinQuery; } else { sqlFragment += " FROM UP_FRAGMENTS UF, UP_LAYOUT_STRUCT_AGGR ULS WHERE "; } sqlFragment += "(ULS.USER_ID="+userId+" AND ULS.FRAGMENT_ID=UF.FRAGMENT_ID)"; if (pushFragmentIds!=null){ sqlFragment += " UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID" + " FROM UP_FRAGMENTS UF WHERE UF.FRAGMENT_ID IN ("+pushFragmentIds+")"; } log.debug(sqlFragment); And I also has found in Mysql Docs that UNION is implemented in MySQL 4.0.0. that's mean that uPortal won't correct work whith Mysql 3.x?? Thanks.

    Apereo Issues | 1 decade ago | Vladimir Potapov
    java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1
  2. 0

    I have downloaded uportal 2.4.patch from cvs,and I have the exception ,when I started uPortal INFO: Server startup in 20653 ms INFO [http-9091-Processor25] portal.RDBMServices.[] Aug/31 11:31:37 - MySQL/com.mysql.jdbc.Driver (mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )) database/driver supports: Prepared statements=true, Outer joins=true, Transactions=true, '{ts' metasyntax=true, TO_DATE()=false INFO [http-9091-Processor25] groups.GroupServiceConfiguration.[] Aug/31 11:31:38 - Group services: Parsing group service configuration. INFO [http-9091-Processor25] groups.RDBMEntityGroupStore.[] Aug/31 11:31:38 - RDBMEntityGroupStore.initialize(): Node separator set to . INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntity.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.groups.IEntityGroup.sweepInterval] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.maxCacheSize] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.MaxIdleTime] was requested but not found. INFO [http-9091-Processor25] properties.PropertiesManager.[] Aug/31 11:31:39 - Property [org.jasig.portal.concurrency.IEntityCachingService.org.jasig.portal.ChannelDefinition.sweepInterval] was requested but not found. ERROR [http-9091-Processor25] layout.AggregatedUserLayoutStore.[] Aug/31 11:31:39 - Error getting aggregated layout for user org.jasig.portal.security.provider.PersonImpl@3461d1 java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 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.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.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) ERROR [http-9091-Processor25] layout.AggregatedLayoutManager.[] Aug/31 11:31:39 - Exception loading user layout java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) at org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944) at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 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.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.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) ERROR [http-9091-Processor25] portal.ExceptionHelper.[] Aug/31 11:31:39 - Programming error java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85) at org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198) at org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98) at org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92) at org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242) Caused by: org.jasig.portal.PortalException: Exception loading user layout: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1] [based on exception: null [based on exception: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1]] at org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1101) at org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120) ... 35 more I have found the place in SQL in AggregatedUserLayoutStore // The query for getting information of the fragments String sqlFragment = "SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID"; if (RDBMServices.supportsOuterJoins) { sqlFragment += ",UFP.PARAM_NAME,UFP.PARAM_VALUE FROM UP_LAYOUT_STRUCT_AGGR ULS, " + fragmentJoinQuery; } else { sqlFragment += " FROM UP_FRAGMENTS UF, UP_LAYOUT_STRUCT_AGGR ULS WHERE "; } sqlFragment += "(ULS.USER_ID="+userId+" AND ULS.FRAGMENT_ID=UF.FRAGMENT_ID)"; if (pushFragmentIds!=null){ sqlFragment += " UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_NODE_ID,UF.CHAN_ID,UF.NAME,UF.TYPE,UF.HIDDEN,"+ "UF.UNREMOVABLE,UF.IMMUTABLE,UF.PRIORITY,UF.FRAGMENT_ID" + " FROM UP_FRAGMENTS UF WHERE UF.FRAGMENT_ID IN ("+pushFragmentIds+")"; } log.debug(sqlFragment); And I also has found in Mysql Docs that UNION is implemented in MySQL 4.0.0. that's mean that uPortal won't correct work whith Mysql 3.x?? Thanks.

    Apereo Issues | 1 decade ago | Vladimir Potapov
    java.sql.SQLException: You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1
  3. 0

    MySQL Lists: java: java.sql.SQLException

    mysql.com | 11 months ago
    java.sql.SQLException: Communication link failure: java.net.SocketException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Streaming ResultSet Error

    Stack Overflow | 6 years ago | JJunior
    java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@174cc1f is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
  6. 0

    MySQL version error

    Stack Overflow | 2 years ago | dhruvsheth7
    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 'select avg(kdt_build_Box_Gen), max(kdt_build_Box_Gen),min(kdt_build_Box_Gen) fro' at line 1

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      You have an error in your SQL syntax near 'UNION SELECT UF.NODE_ID,UF.NEXT_NODE_ID,UF.CHLD_NODE_ID,UF.PREV_NODE_ID,UF.PRNT_' at line 1

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      Statement.executeQuery
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
      4. com.mysql.jdbc.Connection.execSQL(Connection.java:2370)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
      6. com.mysql.jdbc.Statement.executeQuery(Statement.java:1183)
      6 frames
    3. org.jasig.portal
      AggregatedLayoutManager.<init>
      1. org.jasig.portal.layout.AggregatedUserLayoutStore.getAggregatedLayout(AggregatedUserLayoutStore.java:1944)
      2. org.jasig.portal.layout.AggregatedLayoutManager.loadUserLayout(AggregatedLayoutManager.java:1081)
      3. org.jasig.portal.layout.AggregatedLayoutManager.<init>(AggregatedLayoutManager.java:120)
      3 frames
    4. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:274)
      4 frames
    5. org.jasig.portal
      PortalSessionManager.doGet
      1. org.jasig.portal.layout.UserLayoutManagerFactory.getUserLayoutManager(UserLayoutManagerFactory.java:85)
      2. org.jasig.portal.GuestUserPreferencesManager.registerSession(GuestUserPreferencesManager.java:198)
      3. org.jasig.portal.GuestUserInstance.registerSession(GuestUserInstance.java:98)
      4. org.jasig.portal.UserInstanceManager.getUserInstance(UserInstanceManager.java:92)
      5. org.jasig.portal.PortalSessionManager.doGet(PortalSessionManager.java:242)
      5 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    7. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
      4. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      6. org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
      8. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      10. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
      11. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      12. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
      13. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
      14. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      15. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      16. org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
      17. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      18. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      18 frames
    8. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      1 frame
    9. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
      3 frames
    10. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      1 frame
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame