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?