java.lang.RuntimeException: data-import for ./admin.profile.xml failed

Apereo Issues | Eric Dalquist | 5 years ago
  1. 0

    Importing a profile file from 3.2 or earlier fails with the following error: {noformat} [java] Exception in thread "main" java.lang.RuntimeException: data-import for ./admin.profile.xml failed [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [java] at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77) [java] at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194) [java] at upshell_270242091.run(upshell_270242091.groovy:13) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:229) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/home/edalquist/.m2/repository/org/jasig/portal/uportal-war/4.0.2-SNAPSHOT/uportal-war-4.0.2-SNAPSHOT-classes.jar!/org/jasig/portal/io/import-profile_v3-2.crn [java] Source: /with/subtasks/with/subtasks/sql-transaction/sql-query/subtasks/node-iterator[2]/sql-upsert [java] Entity Name: <sql-upsert> [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:93) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.xml.NodeIteratorTask.perform(NodeIteratorTask.java:95) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.QueryTask.access$100(QueryTask.java:58) [java] at org.danann.cernunnos.sql.QueryTask$ResponseMappingRowCallbackHandler.processRow(QueryTask.java:193) [java] at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1421) [java] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:685) [java] at org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:130) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java:40) [java] at org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult(TransactionTask.java:141) [java] at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) [java] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [java] at org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:115) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.runtime.PojoTask.perform(PojoTask.java:202) [java] at org.jasig.portal.io.xml.crn.CernunnosDataImporter.importDataElement(CernunnosDataImporter.java:59) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426) [java] at org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) [java] at upshell_270242091.run(upshell_270242091.groovy:10) [java] ... 3 more [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ [java] UPDATE up_ss_user_parm [java] SET param_val = ? [java] WHERE user_id = ? AND profile_id = ? AND ss_id = ? AND ss_type = 2 AND param_name = ? [java] ]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM [java] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) [java] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811) [java] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867) [java] at org.danann.cernunnos.sql.UpsertTask.doUpdate(UpsertTask.java:167) [java] at org.danann.cernunnos.sql.UpsertTask.perform(UpsertTask.java:147) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] ... 50 more [java] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM [java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) [java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) [java] at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) [java] at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) [java] at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) [java] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74) [java] at $Proxy94.prepareStatement(Unknown Source) [java] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) [java] ... 55 more {noformat}

    Apereo Issues | 5 years ago | Eric Dalquist
    java.lang.RuntimeException: data-import for ./admin.profile.xml failed
  2. 0

    Importing a profile file from 3.2 or earlier fails with the following error: {noformat} [java] Exception in thread "main" java.lang.RuntimeException: data-import for ./admin.profile.xml failed [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [java] at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77) [java] at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194) [java] at upshell_270242091.run(upshell_270242091.groovy:13) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:229) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) [java] Caused by: org.danann.cernunnos.ManagedException: The Cernunnos Runtime encountered an error: [java] Origin Document: jar:file:/home/edalquist/.m2/repository/org/jasig/portal/uportal-war/4.0.2-SNAPSHOT/uportal-war-4.0.2-SNAPSHOT-classes.jar!/org/jasig/portal/io/import-profile_v3-2.crn [java] Source: /with/subtasks/with/subtasks/sql-transaction/sql-query/subtasks/node-iterator[2]/sql-upsert [java] Entity Name: <sql-upsert> [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:93) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.xml.NodeIteratorTask.perform(NodeIteratorTask.java:95) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.QueryTask.access$100(QueryTask.java:58) [java] at org.danann.cernunnos.sql.QueryTask$ResponseMappingRowCallbackHandler.processRow(QueryTask.java:193) [java] at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1421) [java] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:685) [java] at org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:130) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java:40) [java] at org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult(TransactionTask.java:141) [java] at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) [java] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) [java] at org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:115) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148) [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123) [java] at org.danann.cernunnos.core.WithTask.perform(WithTask.java:90) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435) [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287) [java] at org.danann.cernunnos.runtime.PojoTask.perform(PojoTask.java:202) [java] at org.jasig.portal.io.xml.crn.CernunnosDataImporter.importDataElement(CernunnosDataImporter.java:59) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86) [java] at org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448) [java] at org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426) [java] at org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) [java] at upshell_270242091.run(upshell_270242091.groovy:10) [java] ... 3 more [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ [java] UPDATE up_ss_user_parm [java] SET param_val = ? [java] WHERE user_id = ? AND profile_id = ? AND ss_id = ? AND ss_type = 2 AND param_name = ? [java] ]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM [java] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) [java] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811) [java] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867) [java] at org.danann.cernunnos.sql.UpsertTask.doUpdate(UpsertTask.java:167) [java] at org.danann.cernunnos.sql.UpsertTask.perform(UpsertTask.java:147) [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77) [java] ... 50 more [java] Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM [java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) [java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) [java] at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) [java] at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) [java] at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) [java] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74) [java] at $Proxy94.prepareStatement(Unknown Source) [java] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) [java] ... 55 more {noformat}

    Apereo Issues | 5 years ago | Eric Dalquist
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: UP_SS_USER_PARM
  3. 0

    When visit http://localhost:8081/admin/ said:user lacks privilege or object not found: BLC_LOCALE

    GitHub | 3 years ago | MadeInChina
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_LOCALE
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Login as admin Click on Manage Portlets Click on the Popular Portlets button. An error popup appears. See also Jira up-3094 Stacktrace SEVERE: Servlet.service() for servlet MVCDispatcherServlet threw exception java.sql.SQLSyntaxErrorException: unexpected token: SELECT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:205) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.buildEventCounts(StatsLayoutModificationsController.java:318) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.getEventCounts(StatsLayoutModificationsController.java:306) at org.jasig.portal.rest.StatsLayoutModificationsController.getEventCounts(StatsLayoutModificationsController.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) Jan 17, 2012 4:20:14 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet MVCDispatcherServlet threw exception java.sql.SQLSyntaxErrorException: unexpected token: SELECT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:205) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.buildEventCounts(StatsLayoutModificationsController.java:318) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.getEventCounts(StatsLayoutModificationsController.java:306) at org.jasig.portal.rest.StatsLayoutModificationsController.getEventCounts(StatsLayoutModificationsController.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679)

    Apereo Issues | 5 years ago | Alan Berg
    java.sql.SQLSyntaxErrorException: unexpected token: SELECT
  6. 0

    Login as admin Click on Manage Portlets Click on the Popular Portlets button. An error popup appears. See also Jira up-3094 Stacktrace SEVERE: Servlet.service() for servlet MVCDispatcherServlet threw exception java.sql.SQLSyntaxErrorException: unexpected token: SELECT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:205) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.buildEventCounts(StatsLayoutModificationsController.java:318) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.getEventCounts(StatsLayoutModificationsController.java:306) at org.jasig.portal.rest.StatsLayoutModificationsController.getEventCounts(StatsLayoutModificationsController.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) Jan 17, 2012 4:20:14 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet MVCDispatcherServlet threw exception java.sql.SQLSyntaxErrorException: unexpected token: SELECT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:205) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.buildEventCounts(StatsLayoutModificationsController.java:318) at org.jasig.portal.rest.StatsLayoutModificationsController$EventCountFactory.getEventCounts(StatsLayoutModificationsController.java:306) at org.jasig.portal.rest.StatsLayoutModificationsController.getEventCounts(StatsLayoutModificationsController.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:585) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:58) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:113) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679)

    Apereo Issues | 5 years ago | Alan Berg
    java.sql.SQLSyntaxErrorException: unexpected token: SELECT

  1. pradhul 7 times, last 9 months ago
2 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.SQLSyntaxErrorException

    user lacks privilege or object not found: UP_SS_USER_PARM

    at org.hsqldb.jdbc.Util.sqlException()
  2. HSQLDB
    JDBCConnection.prepareStatement
    1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    2. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    3. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    4. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    4 frames
  3. Commons DBCP
    PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement
    1. org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
    2. org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
    2 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  5. Hibernate
    BorrowedConnectionProxy.invoke
    1. org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74)
    1 frame
  6. Unknown
    $Proxy94.prepareStatement
    1. $Proxy94.prepareStatement(Unknown Source)
    1 frame
  7. Spring Framework
    JdbcTemplate.update
    1. org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1375)
    2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580)
    3. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811)
    4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867)
    4 frames
  8. org.danann.cernunnos
    QueryTask$ResponseMappingRowCallbackHandler.processRow
    1. org.danann.cernunnos.sql.UpsertTask.doUpdate(UpsertTask.java:167)
    2. org.danann.cernunnos.sql.UpsertTask.perform(UpsertTask.java:147)
    3. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
    4. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148)
    5. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
    6. org.danann.cernunnos.xml.NodeIteratorTask.perform(NodeIteratorTask.java:95)
    7. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
    8. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148)
    9. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
    10. org.danann.cernunnos.sql.QueryTask.access$100(QueryTask.java:58)
    11. org.danann.cernunnos.sql.QueryTask$ResponseMappingRowCallbackHandler.processRow(QueryTask.java:193)
    11 frames
  9. Spring Framework
    JdbcTemplate.query
    1. org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1421)
    2. org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
    3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
    4. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
    5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
    6. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:685)
    6 frames
  10. org.danann.cernunnos
    TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult
    1. org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:130)
    2. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
    3. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148)
    4. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
    5. org.danann.cernunnos.sql.TransactionTask.access$300(TransactionTask.java:40)
    6. org.danann.cernunnos.sql.TransactionTask$PerformSubtasksTransactionCallback.doInTransactionWithoutResult(TransactionTask.java:141)
    6 frames
  11. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
    2. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
    2 frames
  12. org.danann.cernunnos
    PojoTask.perform
    1. org.danann.cernunnos.sql.TransactionTask.perform(TransactionTask.java:115)
    2. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
    3. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148)
    4. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
    5. org.danann.cernunnos.core.WithTask.perform(WithTask.java:90)
    6. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
    7. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:148)
    8. org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
    9. org.danann.cernunnos.core.WithTask.perform(WithTask.java:90)
    10. org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:77)
    11. org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:435)
    12. org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:287)
    13. org.danann.cernunnos.runtime.PojoTask.perform(PojoTask.java:202)
    13 frames
  13. org.jasig.portal
    IPortalDataHandlerService$importData.call
    1. org.jasig.portal.io.xml.crn.CernunnosDataImporter.importDataElement(CernunnosDataImporter.java:59)
    2. org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:86)
    3. org.jasig.portal.io.xml.crn.AbstractDom4jImporter.importData(AbstractDom4jImporter.java:53)
    4. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:518)
    5. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:481)
    6. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:448)
    7. org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:426)
    8. org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown Source)
    8 frames
  14. Groovy
    AbstractCallSite.call
    1. org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42)
    2. org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)
    3. org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
    3 frames
  15. Unknown
    upshell_270242091.run
    1. upshell_270242091.run(upshell_270242091.groovy:10)
    1 frame
  16. Groovy
    GroovyShell.run
    1. groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266)
    2. groovy.lang.GroovyShell.run(GroovyShell.java:229)
    2 frames
  17. org.jasig.portal
    PortalShell.main
    1. org.jasig.portal.shell.PortalShell.main(PortalShell.java:84)
    1 frame