com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

alfresco.com | 2 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    iBatis error: Nested SQL exception on parametermap with database object type

    yenlo.com | 1 year ago
    java.sql.SQLException: Internal Error:
  2. 0

    hi....i have installed mirth2.1.0.5389. When i was deployed any channel i m getting following errors on server log....can anybody help me regarding this issue.... 1> [2011-05-10 12:24:53,777] ERROR (com.mirth.connect.server.controllers.MuleEngineController:230): Error unregistering channel after failed deploy. com.mirth.connect.server.controllers.ControllerException: error clearing templates at com.mirth.connect.server.controllers.DefaultTemplateController.removeTemplates(DefaultTemplateController.java:98) at com.mirth.connect.server.controllers.MuleEngineController.unregisterChannel(MuleEngineController.java:805) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:228) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the Template.deleteTemplate-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:480) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:74) at com.mirth.connect.server.controllers.DefaultTemplateController.removeTemplates(DefaultTemplateController.java:96) ... 26 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94) ... 31 more 2>[2011-05-10 12:24:53,761] ERROR (com.mirth.connect.server.controllers.MuleEngineController:219): Error registering channel. javax.management.InstanceAlreadyExistsException: MirthConfiguration:type=control,name=e7a071be-a21b-4829-892b-e730b7b63c06ComponentService at com.sun.jmx.mbeanserver.Repository.addMBean(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source) at org.mule.management.agents.JmxAgent.registerComponentService(JmxAgent.java:316) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:348) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) 3>[2011-05-10 12:24:53,746] ERROR (com.mirth.connect.server.controllers.MuleEngineController:341): Failed to configure outbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:180) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureOutboundRouter(MuleEngineController.java:531) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:339) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) ... 28 moreCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 4>[2011-05-10 12:24:53,746] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureOutboundRouter(MuleEngineController.java:531) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:339) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 more Caused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 5>[2011-05-10 12:24:53,667] ERROR (com.mirth.connect.server.controllers.MuleEngineController:334): Failed to configure inbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:180) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:425) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:332) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) ... 28 moreCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 6>[2011-05-10 12:24:53,667] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:425) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:332) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 more Caused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more

    Mirth Project | 6 years ago | vinayak bennur
    com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'.
  3. 0

    iBATIS - User - Java - Problem in resultMap:Cause: java.sql.SQLException: Invalid state, the ResultSet object is closed

    nabble.com | 9 months ago
    java.sql.SQLException: Invalid state, the ResultSet object is closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Getting an uncategorized SQL exception while opening a job details page

    GitHub | 4 months ago | kashishm
    org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.

  1. linxiaolong 2 times, last 5 months ago
  2. tvrmsmith 3 times, last 8 months ago
  3. DannyDBag 2 times, last 11 months ago
  4. davidvanlaatum 2 times, last 11 months ago
  5. poroszd 1 times, last 12 months ago
5 more registered users
5 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. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

    Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

    at sun.reflect.GeneratedConstructorAccessor384.newInstance()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.GeneratedConstructorAccessor384.newInstance(Unknown Source)
    2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    3. java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    3 frames
  3. MySQL jdbc
    JDBC4Connection.<init>
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    2. com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
    3. com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
    4. com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
    5. com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    5 frames
  4. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    4 frames
  5. MySQL jdbc
    NonRegisteringDriver.connect
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    2. com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
    3. com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
    3 frames
  6. Commons DBCP
    PoolableConnectionFactory.makeObject
    1. org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    2. org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    2 frames
  7. Commons Pool
    GenericObjectPool.borrowObject
    1. org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
    1 frame
  8. Commons DBCP
    BasicDataSource.getConnection
    1. org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
    2. org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    2 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:616)
    4 frames
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  11. org.alfresco.util
    AutoCommitInterceptor.invoke
    1. org.alfresco.util.AutoCommitInterceptor.invoke(AutoCommitInterceptor.java:35)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    2 frames
  13. Unknown
    $Proxy70.getConnection
    1. $Proxy70.getConnection(Unknown Source)
    1 frame
  14. Spring Framework
    TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke
    1. org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
    2. org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:213)
    2 frames
  15. Unknown
    $Proxy181.prepareStatement
    1. $Proxy181.prepareStatement(Unknown Source)
    1 frame
  16. com.ibatis.sqlmap
    MappedStatement.executeQueryWithCallback
    1. com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:541)
    2. com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:219)
    3. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
    4. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
    4 frames