ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Parkinson" <pa...@avaning.com>
Subject Broken pipe exception
Date Wed, 12 Dec 2007 15:15:07 GMT
Hello - wondering if anyone can help out and point me in the right
direction.

 

I have a server running using iBATIS and Spring DAO, with some pretty
basic config:

 

      <bean id="mapConfig"
class="org.springframework.core.io.ClassPathResource">

            <constructor-arg>

 
<value>com/ecobee/foundation/ibatis/SqlMapConfig.xml</value>

            </constructor-arg>

      </bean>

       

      <bean id="dataSource"
class="org.springframework.jdbc.datasource.SingleConnectionDataSource">

            <property name="driverClassName"
value="com.mysql.jdbc.Driver" />

            <property name="url" value="jdbc:mysql:///ecobee" />

            <property name="username" value="ecobee" />

            <property name="password" value="ecobee" />     

      </bean>

      

      <bean id="sqlMapClient"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

            <property name="dataSource" ref="dataSource" />

            <property name="configLocation" ref="mapConfig" />

      </bean>

 

The problem is that after some period of time (and I haven't been able
to determine exactly how long, but overnight - some length of time) I'm
getting a broken pipe exception - stack trace below.

 

Any ideas on what might be causing this (or, perhaps more importantly,
what do I need to do to avoid the problem)?

 

I'm having to bounce the server when this happens, which is a real pain
- unsure what the cause might be. Some timeout?

 

Any help is appreciated.


Regards,

 

parki...

 

--- s8 snip

 

 

ERROR 09:59:19:836 Error while extracting database product name -
falling back to empty error codes
{jdbc.support.SQLErrorCodesFactory.getErrorCodes}

  Message: Could not get Connection for extracting meta data; nested
exception is org.springframework.jdbc.CannotGetJdbcConnectionException:
Could not get JDBC Connection; nested exception is
java.sql.SQLException: Connection was closed in
SingleConnectionDataSource. Check that user code checks shouldClose()
before closing Connections, or set 'suppressClose' to 'true'

  Trace org.springframework.jdbc.support.MetaDataAccessException:

 
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcU
tils.java:197)

 
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcU
tils.java:224)

>>>
org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLE
rrorCodesFactory.java:214)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setD
ataSource(SQLErrorCodeSQLExceptionTranslator.java:133)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<ini
t>(SQLErrorCodeSQLExceptionTranslator.java:98)

 
org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(Jdb
cAccessor.java:99)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:197)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

 
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

  Message: Could not get JDBC Connection; nested exception is
java.sql.SQLException: Connection was closed in
SingleConnectionDataSource. Check that user code checks shouldClose()
before closing Connections, or set 'suppressClose' to 'true'

  Nested exception trace
org.springframework.jdbc.CannotGetJdbcConnectionException:

 
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSo
urceUtils.java:82)

 
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcU
tils.java:184)

 
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcU
tils.java:224)

>>>
org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLE
rrorCodesFactory.java:214)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setD
ataSource(SQLErrorCodeSQLExceptionTranslator.java:133)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<ini
t>(SQLErrorCodeSQLExceptionTranslator.java:98)

 
org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(Jdb
cAccessor.java:99)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:197)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

 
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

  Message: Connection was closed in SingleConnectionDataSource. Check
that user code checks shouldClose() before closing Connections, or set
'suppressClose' to 'true'

  Nested exception trace java.sql.SQLException:

 
org.springframework.jdbc.datasource.SingleConnectionDataSource.getConnec
tion(SingleConnectionDataSource.java:189)

 
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(Data
SourceUtils.java:113)

 
org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getC
onnection(TransactionAwareDataSourceProxy.java:109)

 
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(Data
SourceUtils.java:113)

 
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSo
urceUtils.java:79)

 
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcU
tils.java:184)

 
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcU
tils.java:224)

>>>
org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLE
rrorCodesFactory.java:214)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setD
ataSource(SQLErrorCodeSQLExceptionTranslator.java:133)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<ini
t>(SQLErrorCodeSQLExceptionTranslator.java:98)

 
org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(Jdb
cAccessor.java:99)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:197)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

 
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

DEBUG 09:59:19:838 Unable to translate SQLException with Error code '0',
will now try the fallback translator
{jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate}

DEBUG 09:59:19:838 Returning JDBC Connection to DataSource
{jdbc.datasource.DataSourceUtils.doReleaseConnection}

ERROR 09:59:19:846 Exception thrown processing result
{communicator.rest.RestletManager.handleRequest}

  Message: SqlMapClient operation; SQL [];   

--- The error occurred in
com/ecobee/foundation/ibatis/SqlMapThermostat.xml.  

--- The error occurred while applying a parameter map.  

--- Check the Thermostat.select_by_identifier-InlineParameterMap.  

--- Check the statement (query failed).  

--- Cause: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception: 

 

** BEGIN NESTED EXCEPTION ** 

 

java.net.SocketException

MESSAGE: Broken pipe

 

STACKTRACE:

 

java.net.SocketException: Broken pipe

            at java.net.SocketOutputStream.socketWrite0(Native Method)

            at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

            at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)

            at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)

            at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)

            at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)

            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)

            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

            at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

            at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1313)

            at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown
Source)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:585)

            at
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(Prepared
StatementLogProxy.java:62)

            at $Proxy2.execute(Unknown Source)

            at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:186)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:205)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:173)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:123)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:615)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:589)

            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:118)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:269)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:194)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

            at
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

            at
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

            at
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

            at
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

            at
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

            at
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

            at
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

            at
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

            at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

            at java.lang.Thread.run(Thread.java:595)

 

 

** END NESTED EXCEPTION **

 

 

 

Last packet sent to the server was 2 ms ago.; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in
com/ecobee/foundation/ibatis/SqlMapThermostat.xml.  

--- The error occurred while applying a parameter map.  

--- Check the Thermostat.select_by_identifier-InlineParameterMap.  

--- Check the statement (query failed).  

--- Cause: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception: 

 

** BEGIN NESTED EXCEPTION ** 

 

java.net.SocketException

MESSAGE: Broken pipe

 

STACKTRACE:

 

java.net.SocketException: Broken pipe

            at java.net.SocketOutputStream.socketWrite0(Native Method)

            at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

            at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)

            at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)

            at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)

            at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)

            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)

            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

            at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

            at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1313)

            at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown
Source)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:585)

            at
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(Prepared
StatementLogProxy.java:62)

            at $Proxy2.execute(Unknown Source)

            at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:186)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:205)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:173)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:123)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:615)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:589)

            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:118)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:269)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:194)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

            at
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

            at
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

            at
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

            at
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

            at
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

            at
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

            at
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

            at
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

            at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

            at java.lang.Thread.run(Thread.java:595)

 

 

** END NESTED EXCEPTION **

 

 

 

Last packet sent to the server was 2 ms ago.

  Trace org.springframework.dao.DataAccessResourceFailureException:

 
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translat
e(SQLStateSQLExceptionTranslator.java:113)

 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.tran
slate(SQLErrorCodeSQLExceptionTranslator.java:276)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:197)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

>>>
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

  Message:   

--- The error occurred in
com/ecobee/foundation/ibatis/SqlMapThermostat.xml.  

--- The error occurred while applying a parameter map.  

--- Check the Thermostat.select_by_identifier-InlineParameterMap.  

--- Check the statement (query failed).  

--- Cause: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception: 

 

** BEGIN NESTED EXCEPTION ** 

 

java.net.SocketException

MESSAGE: Broken pipe

 

STACKTRACE:

 

java.net.SocketException: Broken pipe

            at java.net.SocketOutputStream.socketWrite0(Native Method)

            at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

            at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)

            at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)

            at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)

            at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)

            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)

            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

            at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

            at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1313)

            at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown
Source)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:585)

            at
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(Prepared
StatementLogProxy.java:62)

            at $Proxy2.execute(Unknown Source)

            at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:186)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:205)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:173)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:123)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:615)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:589)

            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:118)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:269)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:194)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

            at
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

            at
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

            at
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

            at
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

            at
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

            at
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

            at
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

            at
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

            at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

            at java.lang.Thread.run(Thread.java:595)

 

 

** END NESTED EXCEPTION **

 

 

 

Last packet sent to the server was 2 ms ago.

  Nested exception trace
com.ibatis.common.jdbc.exception.NestedSQLException:

 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:185)

 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:123)

 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:615)

 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:589)

 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:118)

 
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:269)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:194)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

>>>
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

  Message: Communications link failure due to underlying exception: 

 

** BEGIN NESTED EXCEPTION ** 

 

java.net.SocketException

MESSAGE: Broken pipe

 

STACKTRACE:

 

java.net.SocketException: Broken pipe

            at java.net.SocketOutputStream.socketWrite0(Native Method)

            at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

            at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)

            at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)

            at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)

            at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)

            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)

            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

            at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

            at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1313)

            at
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown
Source)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:585)

            at
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(Prepared
StatementLogProxy.java:62)

            at $Proxy2.execute(Unknown Source)

            at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:186)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:205)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:173)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:123)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:615)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:589)

            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:118)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:269)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:194)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

            at
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

            at
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

            at
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

            at
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

            at
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

            at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

            at
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

            at
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

            at
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

            at
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

            at
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

            at
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

            at
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

            at
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

            at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

            at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

            at java.lang.Thread.run(Thread.java:595)

 

 

** END NESTED EXCEPTION **

 

 

 

Last packet sent to the server was 2 ms ago.

  Nested exception trace com.mysql.jdbc.CommunicationsException:

    com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)

    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)

    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

    com.mysql.jdbc.Connection.execSQL(Connection.java:3256)

 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
1313)

    com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:874)

    sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

    java.lang.reflect.Method.invoke(Method.java:585)

 
com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(Prepared
StatementLogProxy.java:62)

    $Proxy2.execute(Unknown Source)

 
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.
java:186)

 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQu
ery(GeneralStatement.java:205)

 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
WithCallback(GeneralStatement.java:173)

 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQuery
ForList(GeneralStatement.java:123)

 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:615)

 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMap
ExecutorDelegate.java:589)

 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessi
onImpl.java:118)

 
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(S
qlMapClientTemplate.java:269)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:194)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

>>>
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

DEBUG 09:59:19:850 Exception thrown processing result.
{communicator.rest.RestletManager.makeErrorResponse}

 INFO 09:59:22:499 Adding communicator for identifier 100
{communicator.rest.EndpointCommunicatorMap.add}

DEBUG 09:59:22:499 Opened SqlMapSession
[com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@2da5a6] for iBATIS
operation {orm.ibatis.SqlMapClientTemplate.execute}

DEBUG 09:59:22:500 Fetching JDBC Connection from DataSource
{jdbc.datasource.DataSourceUtils.doGetConnection}

DEBUG 09:59:22:500 Fetching JDBC Connection from DataSource
{jdbc.datasource.DataSourceUtils.doGetConnection}

ERROR 09:59:22:501 Exception thrown processing result
{communicator.rest.RestletManager.handleRequest}

  Message: Could not get JDBC Connection; nested exception is
java.sql.SQLException: Connection was closed in
SingleConnectionDataSource. Check that user code checks shouldClose()
before closing Connections, or set 'suppressClose' to 'true'

  Trace org.springframework.jdbc.CannotGetJdbcConnectionException:

 
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSo
urceUtils.java:82)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:183)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

>>>
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

  Message: Connection was closed in SingleConnectionDataSource. Check
that user code checks shouldClose() before closing Connections, or set
'suppressClose' to 'true'

  Nested exception trace java.sql.SQLException:

 
org.springframework.jdbc.datasource.SingleConnectionDataSource.getConnec
tion(SingleConnectionDataSource.java:189)

 
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(Data
SourceUtils.java:113)

 
org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getC
onnection(TransactionAwareDataSourceProxy.java:109)

 
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(Data
SourceUtils.java:113)

 
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSo
urceUtils.java:79)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClient
Template.java:183)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResul
t(SqlMapClientTemplate.java:220)

 
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapC
lientTemplate.java:267)

 
com.ecobee.foundation.ibatis.ThermostatDao.getThermostat(ThermostatDao.j
ava:38)

 
com.ecobee.communicator.rest.restlet.ThermostatRestlet.doGet(ThermostatR
estlet.java:49)

>>>
com.ecobee.communicator.rest.RestletManager.handleRequest(RestletManager
.java:85)

 
com.ecobee.communicator.server.ServerHandler.messageReceived(ServerHandl
er.java:30)

 
org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived(D
efaultIoFilterChain.java:732)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputIm
pl.flush(ProtocolCodecFilter.java:369)

 
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Protoco
lCodecFilter.java:169)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.j
ava:80)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterC
hain.java:38)

 
org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived(
DefaultIoFilterChain.java:812)

 
org.apache.mina.common.DefaultIoFilterChain$HeadFilter.messageReceived(D
efaultIoFilterChain.java:601)

 
org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived(Defa
ultIoFilterChain.java:399)

 
org.apache.mina.common.DefaultIoFilterChain.fireMessageReceived(DefaultI
oFilterChain.java:393)

 
org.apache.mina.common.AbstractIoProcessor.read(AbstractIoProcessor.java
:348)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:316)

 
org.apache.mina.common.AbstractIoProcessor.process(AbstractIoProcessor.j
ava:308)

 
org.apache.mina.common.AbstractIoProcessor.access$400(AbstractIoProcesso
r.java:43)

 
org.apache.mina.common.AbstractIoProcessor$Worker.run(AbstractIoProcesso
r.java:590)

 
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.j
ava:51)

 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:650)

 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va:675)

    java.lang.Thread.run(Thread.java:595)

DEBUG 09:59:22:501 Exception thrown processing result.
{communicator.rest.RestletManager.makeErrorResponse}.

 


Mime
View raw message