Connection failure. You must change the Database Settings.

Anonymous — Thu, 07 Jan 2016 16:33:09 GMT

Hi Everyone,
i have the same Error Message with Talend.
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: org.postgresql.util.PSQLException: The connection attempt failed.
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
      at org.postgresql.Driver$ConnectThread.getResult(Driver.java:341)
      at org.postgresql.Driver.connect(Driver.java:264)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 9 more
Caused by: java.net.UnknownHostException: :
      at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
      at java.net.Socket.connect(Socket.java:589)
      at java.net.Socket.connect(Socket.java:538)
      at java.net.Socket.<init>(Socket.java:434)
      at java.net.Socket.<init>(Socket.java:211)
      at org.postgresql.core.PGStream.<init>(PGStream.java:62)
      at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
      at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
      at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
      at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
      at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
      at org.postgresql.Driver.makeConnection(Driver.java:386)
      at org.postgresql.Driver.access$100(Driver.java:47)
      at org.postgresql.Driver$ConnectThread.run(Driver.java:301)
      ... 1 more

Re: Connection failure. You must change the Database Settings.

Anonymous — Mon, 11 Jan 2016 03:13:30 GMT

Hi Matze-TLH,
On which official version got this issue? Did you create postgresql connection in metadata? The DB parameter is Ok with you? Can you connect to your postgresql DB successfully without using Talend tool now?
Best regards
Sabrina

topic Re: Connection failure. You must change the Database Settings. in Talend Studio

Connection failure. You must change the Database Settings.

Re: Connection failure. You must change the Database Settings.