ignite icon indicating copy to clipboard operation
ignite copied to clipboard

Issue: Missing JDBC Driver for Ignite 3

Open joicejacob opened this issue 10 months ago • 1 comments

I have successfully installed Apache Ignite 3 and am trying to connect to the Ignite cluster using JDBC. However, I could not find a suitable JDBC driver JAR file in the Ignite 3 distribution.

In previous versions (Apache Ignite 2.x), the JDBC driver classes org.apache.ignite.IgniteJdbcDriver and org.apache.ignite.IgniteJdbcThinDriver were available in ignite-core-2.x.x.jar. However, in Ignite 3, I could not locate a corresponding JAR or driver class for JDBC connectivity.

Steps to Reproduce

  1. Install Apache Ignite 3.
  2. Attempt to connect to the Ignite cluster using JDBC. Encounter an error: java.sql.SQLException: No suitable driver found for jdbc:ignite:thin://127.0.0.1:10800/

Expected Behavior A JDBC driver, similar to Ignite 2.x, should be available to allow applications to connect to Ignite 3 clusters using JDBC.

Actual Behavior The Ignite 3 distribution does not contain a JDBC driver JAR, and attempting to connect via jdbc:ignite:thin://127.0.0.1:10800/ results in a java.sql.SQLException.

Questions

  1. Is JDBC support included in Ignite 3? If so, which driver class should be used?
  2. Where can I find the necessary JDBC driver JAR for Ignite 3?
  3. If JDBC support has changed in Ignite 3, is there an alternative way to connect using SQL?

Any guidance on establishing a JDBC connection with Ignite 3 would be greatly appreciated. Thank you!

joicejacob avatar Feb 17 '25 07:02 joicejacob

JDBC is available in Ignite 3:

  • Maven https://central.sonatype.com/artifact/org.apache.ignite/ignite-jdbc
  • Fat JAR https://downloads.apache.org/ignite/3.0.0/

ptupitsyn avatar Feb 17 '25 11:02 ptupitsyn