FileMaker jdbc input error

Hi
I am running Logstash with FileMaker JDBC connection as the input.
Here is the config file I am using:
input {
jdbc {
jdbc_driver_library => "C:\fmjdbc.jar"
jdbc_driver_class => "com.filemaker.jdbc.Driver"
jdbc_connection_string => "jdbc:filemaker://SERVER/DATABASE"
jdbc_user => "Username"
jdbc_password => "Password"
schedule => "* * * * *"
statement => "SELECT * FROM Table_Name;"
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "My_Index"
}
stdout { codec => json }
}

I am getting the following error:
Unable to connect to database. Tried 1 times {:error_message=>"Java::JavaSql::SQLException: No suitable driver found for jdbc:filemaker://SERVER/DATABASE"}
{ 2010 rufus-scheduler intercepted an error:
2010 job:
2010 Rufus::Scheduler::CronJob "* * * * *" {}
2010 error:
2010 2010
2010 Sequel::DatabaseConnectionError
2010 Java::JavaSql::SQLException: No suitable driver found for jdbc:filemaker://SERVER/DATABASE
2010 java.sql.DriverManager.getConnection(java/sql/DriverManager.java:689)
2010 java.sql.DriverManager.getConnection(java/sql/DriverManager.java:247)
2010 java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)
2010 org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:423)
2010 org.jruby.javasupport.JavaMethod.invokeStaticDirect(org/jruby/javasupport/JavaMethod.java:355)

I tried to connect to FileMaker with DbVisualizer, by providing the same .jar file and driver class name and it worked.
Can you please help?

Solved

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