How do I configure Db2 on Cloud as source in Apache Zeppelin?
I am trying to use my Db2 on Cloud instance hosted on IBM Cloud with an Apache Zeppelin notebook. I tried to follow the JDBC setup instructions, but it resulted in "class not found" error.
I used com.ibm.db2:jcc:11.5.8.0 as Maven artifact in the dependency settings and com.ibm.db2 as default driver.
I run this cell:
%Db2
select count(*) from syscat.tables
which results in this error message:
java.lang.ClassNotFoundException: com.ibm.db2 at java.net.URLClassLoader.findClass(URLClassLoader.java:382) at java.lang.ClassLoader.loadClass(ClassLoader.java:418) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) at java.lang.ClassLoader.loadClass(ClassLoader.java:351) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:264) at org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPool(JDBCInterpreter.java:501) at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:512) at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:539) at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:747) at org.apache.zeppelin.jdbc.JDBCInterpreter.internalInterpret(JDBCInterpreter.java:935) at org.apache.zeppelin.interpreter.AbstractInterpreter.interpret(AbstractInterpreter.java:55) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:110) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:849) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:741) at org.apache.zeppelin.scheduler.Job.run(Job.java:172) at org.apache.zeppelin.scheduler.AbstractScheduler.runJob(AbstractScheduler.java:132) at org.apache.zeppelin.scheduler.ParallelScheduler.lambda$runJobInScheduler$0(ParallelScheduler.java:46) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)
Any tips?
The problem was the setting for the default driver. It needs to be com.ibm.db2.jcc.DB2Driver. I found the solution in the setup instructions for Big SQL with Apache Zeppelin.
- Enabling MySQL general query log with JDBC
- Managing JDBC Connections using Java Virtual Threads
- What is the difference between hibernate.jdbc.fetch_size and hibernate.jdbc.batch_size?
- GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
- Postgres - ERROR: prepared statement "S_1" already exists
- How do I retrieve a row from a SQLite database through Java's jdbc using a string variable?
- Where is the H2 database stored?
- Databricks & JdbcTemplate query error when parameter is a boolean
- How to connect and query Neo4j Database on Apache Drill?
- No operations allowed after connection closed.Connection was implicitly closed by the driver. C3P0
- h2 database: avoid usage of backticks in queries in version 2.0.202
- No more data to read from socket error
- Spark JDBC: Incorrect syntax in spark.read
- JDBC with VSCode class not found
- How to connect Snowflake with PySpark with Google Colab?
- How to install JDBC driver in servlet based project without facing java.lang.ClassNotFoundexception
- Does creating and closing database connections each time I need them have any effect on application performance?
- How do I get the connection inside of a Spring transaction?
- How to download Mysql jdbc jar file on centos
- How to create an oracle.sql.ARRAY object?
- Alternative to connection.setAutoCommit(false) since it doesn't work for JdbcTemplate
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
- Error Connecting MongoDB with JDBC: CommandNotFound for 'sqlGetResultSchema'
- How to get all the rows affected by a UPDATE query in JDBC?
- How can I let Hibernate merge consecutive INSERT statements into multi-valued INSERT
- org.hibernate.exception.JDBCConnectionException: Unable to open JDBC Connection
- Cannot establish a connection to jdbc:oracle:thin:@localhost:1521:XE
- java.sql.SQLException: - ORA-01000: maximum open cursors exceeded
- How do I identify if a class contains a foreign key field?