From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Nuno Zimas <nzimas(at)gmail(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: user can't access own database after creation |
Date: | 2015-12-02 20:39:47 |
Message-ID: | CADK3HH+dwQ5qG5KCnNGZM-5Z+=ocSx9yqS9K_Vxr7CMm=k9h0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)postgresintl(dot)com
www.postgresintl.com
On 2 December 2015 at 15:35, Nuno Zimas <nzimas(at)gmail(dot)com> wrote:
>
> On 2 Dec 2015, at 20:18, Dave Cramer <pg(at)fastcrypt(dot)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(at)postgresintl(dot)com
> www.postgresintl.com
>
> On 2 December 2015 at 14:57, John R Pierce <pierce(at)hogranch(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2015-12-02 20:40:34 | Re: user can't access own database after creation |
Previous Message | John R Pierce | 2015-12-02 20:39:04 | Re: user can't access own database after creation |