Skip to main content

Driver not found for MariaDb


tejas_surve
Roadie

I want to Connect MariaDb to the StreamSet by JDBC processors. MariaDB is similar to the MySQL to need to configure the connection, getting error not supported suitable driver found.So Please help me to find that driver for MariaDb

 

Bikram
Headliner
Forum|alt.badge.img+1
  • Headliner
  • June 8, 2023

@tejas_surve 

Can you please import the attached library and restart the DC and check if it helps.


tejas_surve
Roadie

I already tried with this driver 


tejas_surve
Roadie

I tried with 3.1.4

 


tejas_surve
Roadie

Not working @Bikram 


saleempothiwala
Headliner
Forum|alt.badge.img

@tejas_surve 

 

Check the version of your database and make sure you download the correct version of driver. Also, make sure your connect string is correct, any errors there can lead to an ambiguous error too


tejas_surve
Roadie

@saleempothiwala I am using MariaDB 10.11.3 using standard string for connection also, but we cannot find suitable driver. If You have any leads, please let me know.


saleempothiwala
Headliner
Forum|alt.badge.img

@tejas_surve 

please share your connect string, without any sensitive information ofcourse.


tejas_surve
Roadie

@saleempothiwala 

jdbc:mariadb://s*******************db:38*8/practice


saleempothiwala
Headliner
Forum|alt.badge.img

@tejas_surve 

This looks good. Can you share a screenshot of your external libraries folder where you have uploaded this driver.


tejas_surve
Roadie

@saleempothiwala Please check 

Now I am using mariaDB 10.7.8 


saleempothiwala
Headliner
Forum|alt.badge.img

Thanks for these @tejas_surve 

 

I will try and replicate.


saleempothiwala
Headliner
Forum|alt.badge.img

@tejas_surve 

I installed mariadb 10.11.3, used the same driver as @Bikram  shared.

I was able to connect to the database and see the data in sample table i had created.

 

make sure your data collector has access to the database. i am using dockers so i made sure my sdc docker and my mariadb docker are in the same docker network.

 

 


Reply