StreamSets

StreamSets

Connect with experts and peers to elevate technical expertise, solve problems and share insights.

 View Only
Expand all | Collapse all

Driver not found for MariaDb

  • 1.  Driver not found for MariaDb

    Posted Thu June 08, 2023 09:18 AM

    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

     



  • 2.  RE: Driver not found for MariaDb

    Posted Thu June 08, 2023 08:49 PM

    <user-mention data-id="1185">@tejas_surve</user-mention> 

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



  • 3.  RE: Driver not found for MariaDb

    Posted Mon June 12, 2023 04:57 AM

    I already tried with this driver 



  • 4.  RE: Driver not found for MariaDb

    Posted Mon June 12, 2023 04:58 AM

    I tried with 3.1.4

     



  • 5.  RE: Driver not found for MariaDb

    Posted Mon June 12, 2023 08:29 AM

    Not working <user-mention data-id="206">@Bikram</user-mention> 



  • 6.  RE: Driver not found for MariaDb

    Posted Tue June 13, 2023 11:30 AM

    <user-mention data-id="1185">@tejas_surve</user-mention> 

     

    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



  • 7.  RE: Driver not found for MariaDb

    Posted Wed June 14, 2023 04:54 AM

    <user-mention data-id="68">@saleempothiwala</user-mention> 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.



  • 8.  RE: Driver not found for MariaDb

    Posted Wed June 14, 2023 07:55 AM

    <user-mention data-id="1185">@tejas_surve</user-mention> 

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



  • 9.  RE: Driver not found for MariaDb

    Posted Wed June 14, 2023 08:19 AM

    <user-mention data-id="68">@saleempothiwala</user-mention> 

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



  • 10.  RE: Driver not found for MariaDb

    Posted Wed June 14, 2023 11:09 AM

    <user-mention data-id="1185">@tejas_surve</user-mention> 

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



  • 11.  RE: Driver not found for MariaDb

    Posted Thu June 15, 2023 08:32 AM

    <user-mention data-id="68">@saleempothiwala</user-mention> Please check 

    Now I am using mariaDB 10.7.8 



  • 12.  RE: Driver not found for MariaDb

    Posted Thu June 15, 2023 08:39 AM

    Thanks for these <user-mention data-id="1185">@tejas_surve</user-mention> 

     

    I will try and replicate.



  • 13.  RE: Driver not found for MariaDb

    Posted Fri June 16, 2023 09:16 AM

    <user-mention data-id="1185">@tejas_surve</user-mention> 

    I installed mariadb 10.11.3, used the same driver as <user-mention data-id="206">@Bikram</user-mention>  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.