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 CADK3HHLNG-4inrxN+O+B0OCXmutQt4SA+gmSgCL9zj4metQ1jA@mail.gmail.com
Whole thread Raw
In response to Re: user can't access own database after creation  (Steven Schlansker <stevenschlansker@gmail.com>)
List pgsql-jdbc
Yes, sorry it was ripped out of some groovy code which does not require ;


On 2 December 2015 at 15:50, Steven Schlansker <stevenschlansker@gmail.com> wrote:
That's easily fixed by adding the missing ';' just as the error indicates :)

On Dec 2, 2015, at 12:48 PM, Nuno Zimas <nzimas@gmail.com> wrote:

>
> Hi Dave,
>
> I’m getting an error.
>
> root@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@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
>>>
>>
>>
>


pgsql-jdbc by date:

Previous
From: Steven Schlansker
Date:
Subject: Re: user can't access own database after creation
Next
From: Nuno Zimas
Date:
Subject: Re: user can't access own database after creation