Hi John,
I don't understand why your fix solve the problem, because the properties (
java.net.preferIPv4Stack=true and java.net.preferIPv6Addresses=false
) are already set in the code just before getting the connection, so
that it should
not be necessary to pass these system parameters in the batch.
To be able to make further tests, I added a log info just before getting
the connection. It
shows ipv4 and ipv6 parameters values.
Could you test these info with/without passing parameters to the jvm in
the batch.
I also wonder why it works on my environment
- windows 7 / windows 10
- OpenJUMP 1.9+
- local windows postgresql database / remote linux postgresql database
and not on yours.
Michaël
Le 23/02/2016 06:17, John L. Poole a écrit :
Just a "heads up": here I am in 2016 using OpenJUMP-1.9.0-r4795 againt
PostgreSQL 9.5 with PostGIS and ran into the same problem and found
this ticket and fixed my problem by adding around line 214 in
bin/oj_windows.bat:
rem -- 2/22/2016 jlpoole: added:
rem -Djava.net.preferIPv4Stack=true
-Djava.net.preferIPv6Addresses=false
rem
rem -- essential options, don't change unless you know what you're doing --
set JAVA_OPTS=%JAVA_OPTS% -Dlog4j.configuration="%LOG4J_CONF%" -Dlog.dir="%LOG_DIR%"
-Djump.home="%JUMP_HOME%" %JAVA_MEM% -Djava.net.preferIPv4Stack=true
-Djava.net.preferIPv6Addresses=false
------------------------------------------------------------------------
*[bugs:#330] <http://sourceforge.net/p/jump-pilot/bugs/330/> Postgis
fails to connect for 1.6.3 (rev. 3576)*
*Status:* closed-fixed
*Labels:* postgis
*Created:* Mon Aug 26, 2013 02:43 PM UTC by John L. Poole
*Last Updated:* Tue Nov 18, 2014 04:27 PM UTC
*Owner:* nobody
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.
------------------------------------------------------------------------
Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/jump-pilot/bugs/330/
To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
