Re: Postgress Connection error

Kind of off topic but your postgresql server has security constraints.
Postgresql needs to be opened up so the app server can connect to it
via inet.

Ed


On Sun, Apr 29, 2012 at 6:10 PM, Vrushali Patil <vrush.iitian@gmail.com> wrote:
> Hi,
> I am getting error when I am trying to connect to Postgresql database
> from my program. The code I have written is on server side. And I have
> added postgres.sql.jar in run configurations build path. I am not able
> to figure out the solution. I have tried using other java classes like
> BaseDatasource, etc but getting errors there too.
>
> Program -
>
> public Connection makeDatabaseConn(){
>                                try{
>                                        Class.forName("org.postgresql.Driver");
>
>                                String url = "jdbc:postgresql://localhost:5432/my_db";
>                                con = DriverManager.getConnection(url, "postgres",
> "password");
>                                con.setAutoCommit(true);
>
>                                }catch( Exception e )
>                            {
>                                      e.printStackTrace();
>                                    }
>
>                         return con;
>
>                        }
>
>
> Error -
>
> org.postgresql.util.PSQLException: Your security policy has prevented
> the connection from being attempted.  You probably need to grant the
> connect java.net.SocketPermission to the database server host and port
> that you wish to connect to.
>        at org.postgresql.Driver.connect(Driver.java:282)
>        at java.sql.DriverManager.getConnection(Unknown Source)
>        at java.sql.DriverManager.getConnection(Unknown Source)
>        at
> com.csre.mtp.agro.Sensorwebapp.server.PollingServiceImpl.makeDatabaseConnection(PollingServiceImpl.java:
> 252)
>        at
> com.csre.mtp.agro.Sensorwebapp.server.PollingServiceImpl.populateDatabase(PollingServiceImpl.java:
> 204)
>        at
> com.csre.mtp.agro.Sensorwebapp.server.PollingServiceImpl.readfsxml(PollingServiceImpl.java:
> 177)
>        at
> com.csre.mtp.agro.Sensorwebapp.server.PollingServiceImpl.getdata(PollingServiceImpl.java:
> 86)
>        at
> com.csre.mtp.agro.Sensorwebapp.server.PollingServiceImpl.getMeasurements(PollingServiceImpl.java:
> 60)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>        at java.lang.reflect.Method.invoke(Unknown Source)
>        at
> com.google.appengine.tools.development.agent.runtime.Runtime.invoke(Runtime.java:
> 112)
>        at
> com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:
> 569)
>        at
> com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:
> 208)
>        at
> com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:
> 248)
>        at
> com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:
> 62)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
> 511)
>        at org.mortbay.jetty.servlet.ServletHandler
> $CachedChain.doFilter(ServletHandler.java:1166)
>        at
> com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:
> 35)
>        at org.mortbay.jetty.servlet.ServletHandler
> $CachedChain.doFilter(ServletHandler.java:1157)
>        at
> com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:
> 60)
>        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:
> 122)
>        at org.mortbay.jetty.servlet.ServletHandler
> $CachedChain.doFilter(ServletHandler.java:1157)
>        at
> com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:
> 97)
>        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:
> 78)
>        at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
> 152)
>        at com.google.appengine.tools.development.JettyContainerService
> $ApiProxyHandler.handle(JettyContainerService.java:369)
>        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.security.AccessControlException: access denied
> ("java.net.SocketPermission" "localhost" "resolve")
>        at java.security.AccessControlContext.checkPermission(Unknown Source)
>
> --
> You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group.
> To post to this group, send email to google-web-toolkit@googlegroups.com.
> To unsubscribe from this group, send email to google-web-toolkit+unsubscribe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/google-web-toolkit?hl=en.
>

--
You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group.
To post to this group, send email to google-web-toolkit@googlegroups.com.
To unsubscribe from this group, send email to google-web-toolkit+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-web-toolkit?hl=en.