Also i have installed jdbc_streaming plugin using below command
logstash-plugin install logstash-filter-jdbc_streaming
it's installed successfully
Could some one help me to resolve the issue.
Hi Badger thanks for the reply attached screen shot for reference i have pasted the driver inside logstash and i have tried giving absolute path as suggested by you refer below code
I think if i give the absolute path of the driver it is saying that unable to load the driver refer above screenshot.
Logstash-version-7.2.0
SQLserver - 2014 express edition
SQL driver - mssql-jdbc-7.4.1.jre12-shaded.jar
java - javac 13.0.1
Even for jdbc input plugin if i give the absolute path it's not working. only if i paste the MSSql jdbc driver inside the logstash-7.2.0\logstash-core\lib\jars and make jdbc library as empty then only it's working fine. code given below.
If i give absolute path of the driver location it saying failed to load driver. in screen shot it print the result in power shell because i place the driver in \logstash-7.2.0\logstash-core\lib\jars
So my point is there is no issue with the driver because if i place it inside jars it's working fine but for abs path which i have provided is not working.
My driver folder is available in desktop attached screenshot.
@Mohan_vel - the error TypeError: failed to coerce jdk.internal.loader.ClassLoaders$AppClassLoader to java.net.URLClassLoader is a known issue and has been fixed in:
jdbc_static filter plugin version 1.0.7 (c.f Changelog).
jdbc_streaming filter plugin version 1.0.10. This is a related Github issue for this specific plugin and the Changelog.
The problem in both plugins is actually the same problem and it is explained here.
If you could update the affected plugin to the latest version, that will solve your issue. You could then try to use the jdbc_driver_library with the JDBC driver file path.
The workaround to this issue is to place the JDBC driver in the Logstash Java classpath - which you tried and it works.
@Mohan_vel You're welcome FYI - the issue was actually fixed in jdbc_streaming filter plugin version 1.0.10 which is shipped in Logstash 7.5.1. Upgrading the plugin or upgrading Logstash is the solution.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.