No Suitable Driver Found for jdbc:Cache://ipaddress:port/namespace
Hi Guys,
I am trying to pull data from CacheDB and push into elasticsearch using logstash. In the configuration file i am giving the following. But it is throwing error No Suitable Driver Found for jdbc:Cache://ipaddress:port/namespace. Could anyone please help to resolve this ? I tried both JDK17 and JDK18 but no luck.
My Config file is as follows
input {
jdbc {
clean_run => true
jdbc_driver_library => "C:\InterSystems\Cache\dev\java\lib\JDK17\cache-jdbc-2.0.0.jar"
jdbc_driver_class => "com.intersys.jdbc.CacheDriver"
jdbc_connection_string => "jdbc:Cache://Ipaddress:1972/PC61T"
jdbc_user => "dialup"
jdbc_password => "***"
schedule => "* * * * *"
statement => "SELECT * FROM AEADOCTOR "
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "cachesql"
}
stdout { codec => rubydebug }
}