ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Parkinson" <pa...@avaning.com>
Subject RE: Broken pipe exception
Date Wed, 12 Dec 2007 15:23:19 GMT
Hi Vadivelu:

 

No firewall in this case, the server is running on the same machine as
the db server (MySQL on Debian).

 

But I'll check out the datasource settings, and see about recycling dead
connections - off to investigate spring docs - I'm assuming it'll be
there.

 

Cheers,

 

parki...

 

 

________________________________

From: Vadivelu, Hariharan (IE10)
[mailto:Hariharan.Vadivelu@honeywell.com] 
Sent: Wednesday, December 12, 2007 9:21 AM
To: user-java@ibatis.apache.org
Subject: RE: Broken pipe exception

 

It must be because you have a firewall which is dropping all stale
connections between app and database.

 

You should be having some setting in datasources to recycle dead
connections or the ones dropped by firewall.

 

________________________________

From: Brian Parkinson [mailto:parki@avaning.com] 
Sent: Wednesday, December 12, 2007 9:15 AM
To: user-java@ibatis.apache.org
Subject: Broken pipe exception

 

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