0xDBE (Natasha) DB 142.4463.2 - OS X Yosemite - Error with PostgreSQL
Hi.
When i found this IDE i hav been very happy.
But when i try to start....
Os X Yosemite 10.10.5 - with all updates. Java installed and updated.
IDE is started. But when i try connect to POstgresql i have error
Connection to PostgreSQL - dbname@IP_adress failed
java.sql.SQLException: Ошибка при попытке подсоединения.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:249)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:127)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:41)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:414)
at org.postgresql.Driver.connect(Driver.java:282)
in RemoteDriverImpl.connect(RemoteDriverImpl.java:27)
in RemoteUtil.access$100(RemoteUtil.java:36)
in RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:229)
at com.sun.proxy.$Proxy91.connect(Unknown Source)
in LocalDataSource.getConnection(LocalDataSource.java:256)
Caused by: java.net.UnknownHostException: [IP_adress]
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:223)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:431)
at java.net.Socket.connect(Socket.java:527)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:121)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:127)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:41)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:414)
at org.postgresql.Driver.connect(Driver.java:282)
in RemoteDriverImpl.connect(RemoteDriverImpl.java:27)
Please sign in to leave a comment.
Very interesting issue.
When i add connections data
I cee jdbc:postgresql://[IP_adress]:5432/dbname
I am just edit rows to jdbc:postgresql://IP_adress:5432/dbname
And after this all connected sucessful.
Hello Alex,
Square brackets mean that the host has not yet been specified and should be substituted to hostname/ip address after you modify it. Do you see different behavior?
Yes. When i insert all data and click to "Test connections" the breakets "[]" still be present, and i have error.
So, i am just edit rows manualy (delete "[]") and after this all working fine.
Where do you enter the data: in URL text box or in Host text box? Could you describe steps to reproduce? Note that if you enter it manually in URL text box IDE does not erases the brackets.
Sorry.
In URL field.
Looks like validation logic needs to be enchanced. Filled the https://youtrack.jetbrains.com/issue/DBE-1535 . Thanks for spotting!