18

I am very new to DBeaver. From forum i got to know that driver need to update for cassandra 3+ to work with DBeaver. https://github.com/serge-rider/dbeaver/issues/167 I downloaded this new driver but unable to set the class path. Can anyone help me on this.Below is the current config i did for driver and cassandra.

enter image description here

samir
  • 345
  • 2
  • 6
  • 15
  • Now its working with below config. cassandra-jdbc-driver: http://www.dbschema.com/cassandra-jdbc-driver.html Driver Information : Driver Name: User Friendly Name Driver Type: Generic Java Driver Class: com.dbschema.CassandraJdbcDriver URL: jdbc:cassandra://{host}[:{port}]/{database} Required File(s): cassandra-driver.jar Default Port: 9042 Library File: cassandrajdbc1.1 – samir Sep 18 '16 at 15:13
  • could you please write the steps ? – The PowerHouse Oct 17 '18 at 14:28
  • Does this answer your question? [How do I connect to Cassandra with Dbeaver Community edition?](https://stackoverflow.com/questions/69027126/how-do-i-connect-to-cassandra-with-dbeaver-community-edition) – jaco0646 Dec 02 '21 at 18:54

4 Answers4

13

As I had some problems finding Cassandra driver after DBeaver install, I went through another way:

  • Cloned this GitHub project
  • Built the jar file (mvn package)
  • Added this jar file to the Driver Manager configuration, using the JDBC Class Name and JDBC URL values as described at project README:

enter image description here

manasouza
  • 1,189
  • 1
  • 14
  • 26
  • 2
    I used fat jar as mentioned in git project and it could connect to cassandra showing all keyspaces and their tables. But when it comes to showing data, there is error as, "Read data 'table_name' has encountered problem" – Saurabh Dec 07 '17 at 00:34
  • 4
    To assist others with copy&paste, the Class Name is `org.apache.cassandra2.cql.jdbc.CassandraDriver` and the URL Template is `jdbc:cassandra://{host}[:{port}]/{database}`. – jaco0646 Jun 26 '20 at 19:22
  • 1
    The jar file is available from the [releases](https://github.com/adejanovski/cassandra-jdbc-wrapper/releases) page so you don't have to build it yourself. – jaco0646 Mar 04 '22 at 21:45
12

Download and use dbeaver enterprise edition (for free as well, not open source though) which includes cassandra driver by default.

Blaubaer
  • 654
  • 1
  • 5
  • 15
11

Tested on DBeaver Community Edition 7.3.0.202011292131

  1. Go to https://downloads.datastax.com/#odbc-jdbc-drivers
  2. Select Simba JDBC Driver for Apache Cassandra
  3. Open DBeaver
  4. Database > Driver Manager
  5. New [![preview][1]][1] [1]: https://i.stack.imgur.com/MHzRY.png

6. Do not fill Class Name manually, after Add file click Find Class and select.

arturwwl
  • 609
  • 6
  • 9
  • 1
    that one worked for me. i only had to add a Connection properties: Under "Driver Properties", new, AuthMech set to 1 – jacktrade Jul 13 '21 at 11:45
  • AuthMech=1 does the trick – SwiftMango Aug 12 '22 at 00:30
  • I think this answer is defunct now. The download at https://downloads.datastax.com/#odbc-jdbc-drivers apears to only contain ODBC drivers now. There is no option that mentions "Simba". – Mike Miller Aug 04 '23 at 19:40
-2

Here is another solution you can use trial drivers and way to configure:

https://www.cdata.com/kb/tech/cassandra-jdbc-dbvr.rst

flik
  • 3,433
  • 2
  • 20
  • 30