I have tried using the db2jcc.jar and I successfully establish connection to db2 but now I am trying to use the jt400.jar I have tried to use the driver com.ibm.db2.jdbc.app.DB2Driver but I keep getting the class not found exception. I tried using the com.ibm.as400.access.AS400JDBCDriver but I can't establish connection. Can anyone help me or provide a sample code with the connection string connecting to a db2 with jt400.jar. Class.forName('com.ibm.as400.access.AS400JDBCDriver'); Properties prop = new Properties(); prop.setProperty('user', 'current'); prop.setProperty('password', 'current'); con = DriverManager.getConnection('jdbc:as400://server/database', prop). Most of the IBM Data Server Driver for JDBC and SQLJ properties apply to all database products that the driver supports. Common IBM Data Server Driver for JDBC and SQLJ properties for DB2 servers Some of the IBM Data Server Driver for JDBC and SQLJ properties apply to DB2® for z/OS® and DB2 for Linux, UNIX, and Windows only. All the properties for the 9.7 (Latest) db are here. Vote 27 down vote. With DB2 JDBC type 4 driver (com.ibm.db2.jcc.DB2Driver), I'm using this URL to connect. Good free vpn for mac. I'm struggling to get Confluent's kafka connector to connect to DB2. I am running an ubuntu instance inside docker for testing pruposes. The solution needs to be deployed to kubernetes, so docker it is. I have installed the Confluent platform using apt-get and adding their repos. All services are running, kafka, zookeeper, schema and kafka rest. I have created my kafka connect properties file as described in this article: I assumed that this will work the same for DB2. Thank you very much everyone. The jars we use for our sqoop jobs did the trick. They have the same name, but a different size. Apparently they were also downloaded from the IBM site. The Progress DataDirect stuff did not work at all, btw. Here is my final db2.properties file for my connector. Note the correct JDBC connection URL: name=test-db2-jdbc- connector.class=io.confluent.connect.jdbc.JdbcSourceConnector connection.url=jdbc:db2://db2-server:50000/test_bpm:schema=schemaName;user=db2admin;password=pwd-here-then-semicolon; – Jun 22 at 12:31.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |