are you using app-engine ? it doesnt support everything your normal jdk would do (e.g no network connection), that's why your db-connection fails. try without app-engine
On Sat, Apr 20, 2013 at 11:00 AM, <[email protected]> wrote: > Hello, > > I try to set up a small GWT application which should do a simple SQL query > to Postgres SQL 9.2. Tests are based on > GWT demo GreetingService. Server side greeting service has now following > constructor: > > public GreetingServiceImpl() { > System.out.println("Konstruktor"); > try { > > Class.forName("org.postgresql.Driver"); > > } catch (ClassNotFoundException e) { > > System.out.println("Where is your PostgreSQL JDBC Driver? " > + "Include in your library path!"); > e.printStackTrace(); > return; > > } > try { > connection = DriverManager.getConnection("jdbc:postgresql:// > 192.168.42.42:5432/eclipse","eclipse", "***"); > } catch (SQLException e) { > e.printStackTrace(); > System.out.println("Verbindung zur Datenbank ist > fehlgeschlagen"); > } > } > > This ends up with following exception: > > INFO: Dev App Server is now running > Konstruktor > org.postgresql.util.PSQLException: Der Verbindungsversuch schlug fehl. > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) > at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) > at > org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136) > at > org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) > at > org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) > at > org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) > at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) > at org.postgresql.Driver.makeConnection(Driver.java:393) > at org.postgresql.Driver.connect(Driver.java:267) > at java.sql.DriverManager.getConnection(DriverManager.java:579) > at java.sql.DriverManager.getConnection(DriverManager.java:221) > at > li.ip6.server.GreetingServiceImpl.<init>(GreetingServiceImpl.java:37) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at java.lang.Class.newInstance0(Class.java:374) > at java.lang.Class.newInstance(Class.java:327) > at org.mortbay.jetty.servlet.Holder.newInstance(Holder.java:153) > at > org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:428) > at > org.mortbay.jetty.servlet.ServletHolder.getServlet(ServletHolder.java:339) > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) > at > com.google.appengine.api.socket.dev.DevSocketFilter.doFilter(DevSocketFilter.java:74) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:123) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:63) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:125) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.appengine.tools.development.DevAppServerServersFilter.doDirectRequest(DevAppServerServersFilter.java:369) > at > com.google.appengine.tools.development.DevAppServerServersFilter.doDirectServerRequest(DevAppServerServersFilter.java:352) > at > com.google.appengine.tools.development.DevAppServerServersFilter.doFilter(DevAppServerServersFilter.java:115) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) > at > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418) > at > com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:94) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) > at > com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:421) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) > at org.mortbay.jetty.Server.handle(Server.java:326) > at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) > at > org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938) > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:755) > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > at > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) > *Caused by: java.net.SocketException: Operation failure: > setSocketOptions: Not yet implemented* > at > com.google.appengine.api.socket.SocketApiHelper.translateError(SocketApiHelper.java:92) > at > com.google.appengine.api.socket.SocketApiHelper.translateError(SocketApiHelper.java:105) > at > com.google.appengine.api.socket.SocketApiHelper.makeSyncCall(SocketApiHelper.java:71) > at > com.google.appengine.api.socket.AppEngineSocketImpl.setSocketOptionAsBytes(AppEngineSocketImpl.java:213) > at > com.google.appengine.api.socket.AppEngineSocketOptions$BooleanCheckFunction.apply(AppEngineSocketOptions.java:161) > at > com.google.appengine.api.socket.AppEngineSocketOptions$Option.validateAndApply(AppEngineSocketOptions.java:341) > at > com.google.appengine.api.socket.AppEngineSocketOptions$Option.validateAndApply(AppEngineSocketOptions.java:356) > at > com.google.appengine.api.socket.AppEngineSocketImpl.setOption(AppEngineSocketImpl.java:133) > at > com.google.appengine.api.socket.AppEngineSocketImpl.setOption(AppEngineSocketImpl.java:157) > at java.net.Socket.setTcpNoDelay(Socket.java:940) > at org.postgresql.core.PGStream.changeSocket(PGStream.java:103) > at org.postgresql.core.PGStream.<init>(PGStream.java:61) > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) > ... 55 more > Verbindung zur Datenbank ist fehlgeschlagen > > Obviously Postgres driver tries something which GWT does not like: > > *Caused by: java.net.SocketException: Operation failure: > setSocketOptions: Not yet implemented** > > *A simple test program w/o GWT works. > > Any hints? > > Christian > > -- > You received this message because you are subscribed to the Google Groups > "Google Web Toolkit" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at > http://groups.google.com/group/google-web-toolkit?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-web-toolkit?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
