search

confluentinc / demo-scene

👾Scripts and samples to support Confluent Demos and Talks. ⚠️Might be rough around the edges ;-) 👉For automated tutorials and QA'd code, see https://github.com/confluentinc/examples/
https://developer.confluent.io
Apache License 2.0
1.5k stars 896 forks source link

ibm-demo: db2 jdbc connect did not work. #224

Closed ora0600 closed 3 years ago

ora0600 commented 3 years ago

DB2 connector failed after installing via make connectdb2source

Error in connect logs: INFO Unable to connect to database on attempt 1/3. Will retry in 10000 ms. (io.confluent.connect.jdbc.util.CachedConnectionProvider) com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.29.24] Exception java.net.ConnectException: Error opening socket to server ibmdb2/172.18.0.3 on port 50,000 with message: Connection refused (Connection refused). ERRORCODE=-4499, SQLSTATE=08001 at com.ibm.db2.jcc.am.b7.a(b7.java:338) at com.ibm.db2.jcc.am.b7.a(b7.java:435) at com.ibm.db2.jcc.t4.a0.a(a0.java:462) at com.ibm.db2.jcc.t4.a0.(a0.java:97) at com.ibm.db2.jcc.t4.a.b(a.java:367) at com.ibm.db2.jcc.t4.b.newAgent_(b.java:2251) at com.ibm.db2.jcc.am.Connection.initConnection(Connection.java:855) at com.ibm.db2.jcc.am.Connection.(Connection.java:800) at com.ibm.db2.jcc.t4.b.(b.java:364) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:243) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:200) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:491) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:117) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at io.confluent.connect.jdbc.dialect.GenericDatabaseDialect.getConnection(GenericDatabaseDialect.java:234) at io.confluent.connect.jdbc.util.CachedConnectionProvider.newConnection(CachedConnectionProvider.java:83) at io.confluent.connect.jdbc.util.CachedConnectionProvider.getConnection(CachedConnectionProvider.java:52) at io.confluent.connect.jdbc.JdbcSourceConnector.start(JdbcSourceConnector.java:92) at org.apache.kafka.connect.runtime.WorkerConnector.doStart(WorkerConnector.java:186) at org.apache.kafka.connect.runtime.WorkerConnector.start(WorkerConnector.java:211) at org.apache.kafka.connect.runtime.WorkerConnector.doTransitionTo(WorkerConnector.java:350) at org.apache.kafka.connect.runtime.WorkerConnector.doTransitionTo(WorkerConnector.java:333) at org.apache.kafka.connect.runtime.WorkerConnector.doRun(WorkerConnector.java:141) at org.apache.kafka.connect.runtime.WorkerConnector.run(WorkerConnector.java:118) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.base/java.net.PlainSocketImpl.socketConnect(Native Method) at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242) at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.base/java.net.Socket.connect(Socket.java:609) at com.ibm.db2.jcc.t4.x.run(x.java:49) at java.base/java.security.AccessController.doPrivileged(Native Method) at com.ibm.db2.jcc.t4.a0.a(a0.java:444)

rmoff commented 3 years ago

@gianlucanatali can you help with this one?

ora0600 commented 3 years ago

He does Thank you

Robin Moffatt @.***> schrieb am Di. 17. Aug. 2021 um 15:48:

@gianlucanatali https://github.com/gianlucanatali can you help with this one?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/confluentinc/demo-scene/issues/224#issuecomment-900314877, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJE5PAGRAJ2J4TOSBOEWFCTT5JSETANCNFSM5CJ3ENJQ .

--

https://www.confluent.io

Confluent Data in Motion

Carsten Mützlitz

Senior Solution Engineering Consultant

+49 (151) 6144-1179 @.***

Follow us: Blog https://confluent.io/blog?utm_source=footer&utm_medium=email&utm_campaign=ch.email-signature_type.community_content.blog • Slack https://slackpass.io/confluentcommunity • Twitter https://twitter.com/ConfluentInc • YouTube https://youtube.com/confluent

https://www.kafka-summit.org/

gianlucanatali commented 3 years ago

Default port changed in the latest version of DB2 (wow!) https://www.ibm.com/support/pages/db2-db2-server-tcpip-port-numbers @jhogan-confluent and I are on this, will be fixed soon