How to configure the jdbc input plugin for mysql


I work in windows, and i need use input plugin for mysql, i have this:

jdbc {
jdbc_connection_string => "jdbc:mysql://"
jdbc_user => "ale"
jdbc_password => "ale"

jdbc_driver_library => "E:\Bacardi\mysql-connector-java-5.1.39.jar"
jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

statement => "SELECT * FROM prueba"
#jdbc_paging_enabled => "true"
#jdbc_page_size => "50000"

but i have this error Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?

I tried:

#jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

#jdbc_driver_class => ""
#jdbc_driver_class => "com.mysql.jdbc.Driver"

but it still gives me the same error. please someone help me?

Sorry my English. thnks

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.