#330 Postgis fails to connect for 1.6.3 (rev. 3576)

Windows
closed-fixed
nobody
postgis (1)
5
2013-11-03
2013-08-26
John L. Poole
No

Postgis fails to connect for 1.6.3 (rev. 3576)

I downloaded and installed OpenJUMP-Installer-1.6.3-r3576-PLUS.exe on 8/25/2013. I select "File-SQL run Datastore Query" and I am presented with the "Run Datasotre Query" dialog. I click the database icon to create a new connection, I get the "Connection Manager" dialog and I click "Add". I then fill in the dialog "Add Connection" with 1) name "Test", 2) leave deafult picklist item of "PostGIS", 3) a recognized server (also tried the IP of my server), 4) "5432", 5) a known database, 6) confirmed user account, 7) confirmed password. After clicking "OK", I then select my newly created entry in Connection Manager and then I click "Connect".

I get a window titled "PSQL Exception" with "The connection attempt failed (PSQL Exception)". The Java stack trace reflected in the "Details" child window will be attached hereto.

Related

Bugs: #330

Discussion

1 2 3 > >> (Page 1 of 3)
  • John L. Poole
    John L. Poole
    2013-08-26

    Adding attachment of "Details" Java stack trace.

     
    Last edit: John L. Poole 2013-08-26
  • John L. Poole
    John L. Poole
    2013-08-26

    I confirmed that connections are being accepted for my specified username/passwords by creating a separate connection account in Pgadmin and then logging into the database therein.

     
  • mentaer
    mentaer
    2013-08-26

    by the way, thanks for the details error description. We will have a look.

     
  • mentaer
    mentaer
    2013-08-26

    So this means that John runs on Windows (7?) and Java 7? and has his default set to ip6? (jesus...)

     
  • John L. Poole
    John L. Poole
    2013-08-26

    I downloaded and installed OpenJUMP-Installer-20130825-r3684-PLUS.exe and performed the same operations described initially. Result: failed to connect. Attached is the java stack trace.

     
  • mentaer
    mentaer
    2013-08-26

    Hi John, thanks for testing again with the latest.

    Do you have a chance to test on a different computer? (as the link ede sent seems to indicate that this is a very specific java/computer configuration problem)

     
  • John L. Poole
    John L. Poole
    2013-08-26

    My environment has:
    JAVA_HOME=C:\Program Files\Java\jdk1.7.0_21
    I do not have a Java instance referenced in my PATH variable.

    A suggestion: have in the Help menu an item. e.g. "Environment Print-out", to spit out an environment print-out of whatever variables would be important to track a given instance. Then you could suggest in the printout that the contents be included in all bug submissions.

     
1 2 3 > >> (Page 1 of 3)