From: | Nuno Zimas <nzimas(at)gmail(dot)com> |
---|---|
To: | Steven Schlansker <stevenschlansker(at)gmail(dot)com> |
Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, 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:52:52 |
Message-ID: | 5B0A4EBE-9006-45A1-ACF0-0803D275AFDA@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Thanks, Steve. How silly of me :(
Still falling to compile, though.
root(at)aida2next /u/2next# javac TestUrl.java
TestUrl.java:10: error: unreported exception SQLException; must be caught or declared to be thrown
Connection con = java.sql.DriverManager.getConnection("jdbc:postgresql://10.10.10.100","postgres","smartdoc");
^
TestUrl.java:11: error: unreported exception SQLException; must be caught or declared to be thrown
con.createStatement().execute("select 1");
^
TestUrl.java:11: error: unreported exception SQLException; must be caught or declared to be thrown
con.createStatement().execute("select 1");
^
3 errors
> On 2 Dec 2015, at 20:50, Steven Schlansker <stevenschlansker(at)gmail(dot)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(at)gmail(dot)com> wrote:
>
>>
>> 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
>>> 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 | Steven Schlansker | 2015-12-02 20:53:43 | Re: user can't access own database after creation |
Previous Message | Dave Cramer | 2015-12-02 20:52:16 | Re: user can't access own database after creation |