Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Cramer
Subject Re: user can't access own database after creation
Date
Msg-id CADK3HH+dwQ5qG5KCnNGZM-5Z+=ocSx9yqS9K_Vxr7CMm=k9h0A@mail.gmail.com
Whole thread Raw
In response to Re: user can't access own database after creation  (Nuno Zimas <nzimas@gmail.com>)
Responses Re: user can't access own database after creation
Re: user can't access own database after creation
Re: user can't access own database after creation
Re: user can't access own database after creation
List pgsql-jdbc
Tree view
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


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.


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



pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: user can't access own database after creation
Next
From: Dave Cramer
Date:
Subject: Re: user can't access own database after creation