Re: user can't access own database after creation

Hi Dave,

I’m getting an error.

root(at)aida2next /u/2next# javac TestUrl.java
TestUrl.java:1: error: ';' expected
import java.sql.Connection
^
1 error

> On 2 Dec 2015, at 20:39, Dave Cramer <pg(at)fastcrypt(dot)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(at)postgresintl(dot)com <mailto:davec(at)postgresintl(dot)com>
> www.postgresintl.com <http://www.postgresintl.com/>
> On 2 December 2015 at 15:35, Nuno Zimas <nzimas(at)gmail(dot)com <mailto:nzimas(at)gmail(dot)com>> wrote:
>
>> On 2 Dec 2015, at 20:18, Dave Cramer <pg(at)fastcrypt(dot)com <mailto: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 <mailto:davec(at)postgresintl(dot)com>
>> www.postgresintl.com <http://www.postgresintl.com/>
>> On 2 December 2015 at 14:57, John R Pierce <pierce(at)hogranch(dot)com <mailto: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 <mailto:pgsql-jdbc(at)postgresql(dot)org>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc <http://www.postgresql.org/mailpref/pgsql-jdbc>
>>
>
>