StreamSets

StreamSets

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


#DataIntegration
#Data
 View Only
Expand all | Collapse all

Driver not found for MariaDb

  • 1.  Driver not found for MariaDb

    Posted 06/08/23 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 06/08/23 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 06/12/23 04:57 AM

    I already tried with this driver 



  • 4.  RE: Driver not found for MariaDb

    Posted 06/12/23 04:58 AM

    I tried with 3.1.4

     



  • 5.  RE: Driver not found for MariaDb

    Posted 06/12/23 08:29 AM

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



  • 6.  RE: Driver not found for MariaDb

    Posted 06/13/23 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 06/14/23 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 06/14/23 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 06/14/23 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 06/14/23 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 06/15/23 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 06/15/23 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 06/16/23 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.