I've built PostgreSQL 8.3 devel with VC++ 2005, done all the db initialization process (creating the data dir using initdb, registering it as a service using pg_ctl, etc) and tested by connecting to it through pgAdmin III, I even built a C extension and ran it as a SP in the pgAdmin SQL console.
I then restored a backup with the database of my under-development java application in the hope that it would connect to this db transparently (I have of course changed the jdbc driver to match the 8.3devel version).
When I tried to run my web java application, I received the following PSQLException: ""Protocol error. Session setup failed"
What could be happening?
Note: I've attached the tomcat stack trace to the error.
Thanks,
Marcelo.
HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: org.postgresql.util.PSQLException: Erro de Protocolo. Configuração da sessão falhou. at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:470) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:98) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:382) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.genexus.db.driver.GXConnection$1.run(Unknown Source) at com.genexus.platform.NativeFunctions11.executeWithPermissions(Unknown Source) at com.genexus.db.driver.GXConnection.connectJDBCDriver(Unknown Source) at com.genexus.db.driver.GXConnection.connect(Unknown Source) at com.genexus.db.driver.GXConnection.<init>(Unknown Source) at com.genexus.db.driver.GXConnection.<init>(Unknown Source) at com.genexus.db.driver.ReadWriteConnectionPool.createConnection(Unknown Source) at com.genexus.db.driver.ConnectionPool.checkOut(Unknown Source) at com.genexus.db.driver.DataSourceConnectionPool.checkOut(Unknown Source) at com.genexus.db.ServerUserInformation.getConnection(Unknown Source) at com.genexus.db.ServerDBConnectionManager.getConnection(Unknown Source) at com.genexus.db.DefaultConnectionProvider.getConnection(Unknown Source) at com.genexus.db.DataStoreProviderBase.getConnection(Unknown Source) at com.genexus.db.SentenceProvider.getPreparedStatement(Unknown Source) at com.genexus.db.ForEachCursor.preExecute(Unknown Source) at com.genexus.db.DataStoreProvider.execute(Unknown Source) at ppobtemmensagemsistema.execute_int(ppobtemmensagemsistema.java:49) at ppobtemmensagemsistema.execute(ppobtemmensagemsistema.java:31) at hhexibemensagemsessaoexpirada_impl.e1211Z2(hhexibemensagemsessaoexpirada_impl.java:335) at hhexibemensagemsessaoexpirada_impl.strup11Z0(hhexibemensagemsessaoexpirada_impl.java:304) at hhexibemensagemsessaoexpirada_impl.start11Z2(hhexibemensagemsessaoexpirada_impl.java:197) at hhexibemensagemsessaoexpirada_impl.ws11Z2(hhexibemensagemsessaoexpirada_impl.java:202) at hhexibemensagemsessaoexpirada_impl.webExecute(hhexibemensagemsessaoexpirada_impl.java:57) at com.genexus.webpanels.GXWebObjectBase.doExecute(Unknown Source) at hhexibemensagemsessaoexpirada.doExecute(hhexibemensagemsessaoexpirada.java:19) at com.genexus.webpanels.GXWebObjectStub.callExecute(Unknown Source) at com.genexus.webpanels.GXWebObjectStub.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:419) at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source) com.genexus.webpanels.GXWebObjectStub.callExecute(Unknown Source) com.genexus.webpanels.GXWebObjectStub.doGet(Unknown Source) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:419) org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:133) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
