Error updating database. Cause: org.postgresql.util.PSQLException: An I/O e
rror occurred while sending to the backend.
The error may exist in com/cennavi/Mybatis/Mapper/ProjectInfoExt_BasicMapper
.java (best guess)
The error may involve com.cennavi.Mybatis.Mapper.ProjectInfoExt_BasicMapper.
Update-Inline
The error occurred while setting parameters
SQL: update projectinfoext set longitude=112.868339,latitude=28.194399,loca
tion='112.868339,28.194399',precisionlevel=3,geom=st_geomfromtext ('point(112.86
8339 28.194399)',4326) where 1=1 and tbprjid=18259
Cause: org.postgresql.util.PSQLException: An I/O error occurred while sendin
g to the backend.
; An I/O error occurred while sending to the backend.; nested exception is org.p
ostgresql.util.PSQLException: An I/O error occurred while sending to the backend
.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTra
nslate(SQLStateSQLExceptionTranslator.java:107)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPos
sible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(Sq
lSessionTemplate.java:446)
at com.sun.proxy.$Proxy69.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:
294)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
at com.sun.proxy.$Proxy76.Update(Unknown Source)
at com.cennavi.Service.ProjectInfo_Basic.UpdateProjectInfoExt(ProjectInf
o_Basic.java:69)
at com.cennavi.Controller.ProjectInfo_Basic.UpdateProjectExt(ProjectInfo
_Basic.java:84)
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvok
e(InvocableHandlerMethod.java:189)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeF
orRequest(InvocableHandlerMethod.java:138)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocabl
eHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingH
andlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingH
andlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapt
er.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(Dispatch
erServlet.java:1038)
at org.springframework.web.servlet.DispatcherServlet.doService(Dispatche
rServlet.java:942)
at org.springframework.web.servlet.FrameworkServlet.processRequest(Frame
workServlet.java:1005)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServ
let.java:908)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkSer
vlet.java:882)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53
)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(
RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(For
mContentFilter.java:92)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInterna
l(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java
:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig
ht.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract
Protocol.java:834)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo
int.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas
e.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sendin
g to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:335)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedSt
atement.java:143)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.j
ava:132)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr
eparedStatement.java:67)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(
PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(R
outingStatementHandler.java:74)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.jav
a:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.jav
a:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSq
lSession.java:198)
at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(Sq
lSessionTemplate.java:433)
... 60 more
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBuffer
edInputStream.java:140)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBuf
feredInputStream.java:109)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedIn
putStream.java:67)
at org.postgresql.core.PGStream.receiveChar(PGStream.java:306)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1952)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:308)
... 75 more
