Hello,
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)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
