Postgresql Connection with Database in Java fail

Question

I try to connect from my Android app to my postgresql server running on Windows 7. Both is running on my computer with a special IP. I try

String url = "jdbc:postgresql://xx.xx.xx.xx:5432/postgis20";
connect = DriverManager.getConnection(url,"postgres","xxxx");

The app is running in a simulator on my pc. Connect contains after the procedure null and Exceiption I get is The connection attempt failed. So what I do wrong with the connection? If I try to connect via the SQL Shell everything is working fine and I use the same parameter. SSL is set to no.

I also tried to use instead of my ip localhost or 127.0.0.1 but that has the same result.

I changed the permission settings to allow the access to the internet. But now I get the following error: org.postgresql.util.PSQLException: Something unusual has occured to cause the driver to fail. Please report this exception.

Irgendw Pointer · Accepted Answer · 2013-05-22 06:33:02Z

4

To use jdbc on Android it is necessary to use the StrictMode. That can be done by using the following code lines:

StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);

answered May 22, 2013 at 6:33

Irgendw Pointer

1,8506 gold badges32 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kennedy Mathinya Over a year ago

Hi , where do I place this code , in connection class or MainActivity ?

Collectives™ on Stack Overflow

Postgresql Connection with Database in Java fail

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related