Re: user can't access own database after creation - Mailing list pgsql-jdbc

On 2 Dec 2015, at 20:39, Dave Cramer <pg@fastcrypt.com> wrote:

this isn't compiled, but it has no dependencies to compile and only one to run

import java.sql.Connection

/**
 * Created by davec on 2014-03-28.
 */
class TestUrl
{
  public static void main(String []args)
  {
    Connection con = java.sql.DriverManager.getConnection("jdbc:postgresql://yourhost","youruser","password");
    con.createStatement().execute("select 1");
  }
}

save it in a file called TestUrl.java

compile it with javac TestUrl.java

run it with java -cp postgresql.jar:./ TestUrl

change the names above to suit

Dave Cramer

davec@postgresintl.com

www.postgresintl.com

On 2 December 2015 at 15:35, Nuno Zimas <nzimas@gmail.com> wrote:

On 2 Dec 2015, at 20:18, Dave Cramer <pg@fastcrypt.com> wrote:

Can you try a very simple JDBC program to see if you can connect ?

Dave Cramer

Could you please suggest one already compiled?

I’m not a java programmer and it’s been hell on rather to compile even the simplest java source file due to dependency issues.

davec@postgresintl.com

www.postgresintl.com

On 2 December 2015 at 14:57, John R Pierce <pierce@hogranch.com> wrote:

On 12/2/2015 11:55 AM, Nuno Zimas wrote:

psql always connects successfully no matter what.
As for JDBC, we get the same results with or without ssl=true explicitly appended to the URL.
What truly baffles me is that ye exact same java application works with no hiccups against a quasi-vanilla pgsql backend i’ve installed on windows 10.
So far, the only visible difference I found is in the values for LC_COLLATE and LC_TYPE, which is V on the remote pgsql instances and English_United States.1252 on the local pgsql instance.
Not sure how tis would affect accessing the DBs, though.

can you connect using psql on the windows system to the ubuntu hosted database?



--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc