Hello
I am using
- postgresql 9
- postgresql-9.0-801.jdbc4.jar
- tomcat 6
- vaadin 6.6.3
I try to connect to the database with a tomcat JNDI datasource which is configured as folllow:
<Context docBase="/usr/share/tomcat6-dproject-test" debug="0" reloadable="true">
<Manager pathname="" />
<Resource
name="jdbc/dproject"
auth="Container"
type="javax.sql.DataSource"
username="xxx"
password="xxx"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://myhost:5432/mydb"
validationQuery="SELECT 1"
initialSize="1"
maxActive="100"
maxIdle="50"
maxWait="60000"
removeAbandoned="true"
logAbandoned="true" />
</Context>
Everytime I upload a new version of my vaadin app everything seems to work fine But after a day or two when I try to login I always get the progress indicator which never times out and of course the whole application is stopped
Aug 5, 2011 11:23:24 AM com.digicpictures.dproject.Dproject tryToLogIn
INFO: LOGIN ATTEMPT
username: myusername
password: mypassword
org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.commons.dbcp.PoolableConnectionFactory.validateObject(PoolableConnectionFactory.java:635)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1165)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:79)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.digicpictures.dproject.Dproject.tryToLogIn(Dproject.java:289)
at com.digicpictures.dproject.Dproject.access$0(Dproject.java:276)
at com.digicpictures.dproject.Dproject$1.buttonClick(Dproject.java:232)
at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:490)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1193)
at com.vaadin.ui.Button.fireClick(Button.java:526)
at com.vaadin.ui.Button$ClickShortcut.handleAction(Button.java:661)
at com.vaadin.event.ActionManager.handleAction(ActionManager.java:233)
at com.vaadin.event.ActionManager.handleAction(ActionManager.java:228)
at com.vaadin.event.ActionManager.handleActions(ActionManager.java:198)
at com.vaadin.ui.Panel.changeVariables(Panel.java:356)
at com.vaadin.ui.Window.changeVariables(Window.java:1084)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariableBurst(AbstractCommunicationManager.java:1299)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariables(AbstractCommunicationManager.java:1219)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleUidlRequest(AbstractCommunicationManager.java:735)
at com.vaadin.terminal.gwt.server.CommunicationManager.handleUidlRequest(CommunicationManager.java:296)
at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
SQLException: SQLState(08006)
- What is wrong with my code?
- Where can I found more help ?
- How can I solve this issue?
please see my previous post for more details
Peter
PS: if I can successfully login after that I have no problems with my app