Not able to connect to the MYSQL using Streaming Integrator Tooling , getting driver error

[prabhatbhargav]

Hi Everyone,

I am facing issue in creating the performing File to table ETL using Streaming Integrator Tooling, mostly I believe it is because of the driver .

So here is my situation:

1. MYSQL installed on my system is 8.0.21
2. Driver I am using for it is : sqljdbc42 --> This is my first doubt that whether this is the correct driver which I shall be using or not.
   I have converted this driver to ogsi bundle and placed in /lib
3. I am trying to insert data from file to table, code I have written is below

@app:name('firstdeploy')
@app:description('from_the_examples')

@source(type = 'file', file.uri = "file:/C:\wso2\file\TEST.csv",
@Map(type = 'csv'))
define stream STUDENT_INFO(name string, ID INT, class string, dob object);

@PrimaryKey('ID')
@store(type='rdbms', jdbc.url="jdbc: mysql://localhost:3306/production ", username="wso2si", password="wso2" , jdbc.driver.name ="com.mysql.jdbc.Driver")
define table StudentDetails(name string, ID INT, class string, dob object);

from STUDENT_INFO
select name, ID, class, dob
update or insert into StudentDetails
on StudentDetails.ID == ID;

4. I haven't made any changes in deployment.yaml file --> Do I have to make changes over there? Since I am already defining the connection details in @store

5. On running this code error I am getting is:

• Failed to load driver class com.mysql.jdbc.Driver from HikariConfig class classloader org.eclipse.osgi.internal.loader.EquinoxClassLoader@3b096f0c[com.zaxxer.HikariCP:3.3.1(id=17)]
  [2020-09-06 01:15:34,233] ERROR {com.zaxxer.hikari.util.PropertyElf} - Failed to set property driverClassName on target class com.zaxxer.hikari.HikariConfig java.lang.reflect.InvocationTargetException
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:150)
  at com.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:59)
  at java.util.Hashtable.forEach(Hashtable.java:879)
  at com.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:54)
  at com.zaxxer.hikari.HikariConfig.(HikariConfig.java:134)
  at io.siddhi.extension.store.rdbms.RDBMSEventTable.initializeDatasource(RDBMSEventTable.java:1463)
  at io.siddhi.extension.store.rdbms.RDBMSEventTable.connect(RDBMSEventTable.java:1187)
  at io.siddhi.core.table.record.AbstractQueryableRecordTable.connectAndLoadCache(AbstractQueryableRecordTable.java:206)
  at io.siddhi.core.table.Table.connectWithRetry(Table.java:406)
  at io.siddhi.core.SiddhiAppRuntimeImpl.startWithoutSources(SiddhiAppRuntimeImpl.java:478)
  at io.siddhi.core.SiddhiAppRuntimeImpl.start(SiddhiAppRuntimeImpl.java:447)
  at org.wso2.carbon.siddhi.editor.core.internal.DebugRuntime.start(DebugRuntime.java:93)
  at org.wso2.carbon.siddhi.editor.core.internal.DebugProcessorService.start(DebugProcessorService.java:43)
  at org.wso2.carbon.siddhi.editor.core.internal.EditorMicroservice.start(EditorMicroservice.java:792)
  at org.wso2.carbon.siddhi.editor.core.internal.EditorMicroservice.startWithVariables(EditorMicroservice.java:812)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.wso2.msf4j.internal.router.HttpMethodInfo.invokeResource(HttpMethodInfo.java:187)
  at org.wso2.msf4j.internal.router.HttpMethodInfo.invoke(HttpMethodInfo.java:143)
  at org.wso2.msf4j.internal.MSF4JHttpConnectorListener.dispatchMethod(MSF4JHttpConnectorListener.java:218)
  at org.wso2.msf4j.internal.MSF4JHttpConnectorListener.lambda$onMessage$47(MSF4JHttpConnectorListener.java:129)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
  Caused by: java.lang.RuntimeException: Failed to load driver class com.mysql.jdbc.Driver in either of HikariConfig class loader or Thread context classloader
  at com.zaxxer.hikari.HikariConfig.setDriverClassName(HikariConfig.java:485)
  ... 30 more

[2020-09-06 01:15:35,115] ERROR {io.siddhi.core.table.Table} - Error on 'firstdeploy'. java.lang.reflect.InvocationTargetException . Error while connecting to Table 'StudentDetails'. java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
at com.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:165)
at com.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:59)
at java.util.Hashtable.forEach(Hashtable.java:879)
at com.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:54)
at com.zaxxer.hikari.HikariConfig.(HikariConfig.java:134)
at io.siddhi.extension.store.rdbms.RDBMSEventTable.initializeDatasource(RDBMSEventTable.java:1463)
at io.siddhi.extension.store.rdbms.RDBMSEventTable.connect(RDBMSEventTable.java:1187)
at io.siddhi.core.table.record.AbstractQueryableRecordTable.connectAndLoadCache(AbstractQueryableRecordTable.java:206)
at io.siddhi.core.table.Table.connectWithRetry(Table.java:406)
at io.siddhi.core.SiddhiAppRuntimeImpl.startWithoutSources(SiddhiAppRuntimeImpl.java:478)
at io.siddhi.core.SiddhiAppRuntimeImpl.start(SiddhiAppRuntimeImpl.java:447)
at org.wso2.carbon.siddhi.editor.core.internal.DebugRuntime.start(DebugRuntime.java:93)
at org.wso2.carbon.siddhi.editor.core.internal.DebugProcessorService.start(DebugProcessorService.java:43)
at org.wso2.carbon.siddhi.editor.core.internal.EditorMicroservice.start(EditorMicroservice.java:792)
at org.wso2.carbon.siddhi.editor.core.internal.EditorMicroservice.startWithVariables(EditorMicroservice.java:812)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.wso2.msf4j.internal.router.HttpMethodInfo.invokeResource(HttpMethodInfo.java:187)
at org.wso2.msf4j.internal.router.HttpMethodInfo.invoke(HttpMethodInfo.java:143)
at org.wso2.msf4j.internal.MSF4JHttpConnectorListener.dispatchMethod(MSF4JHttpConnectorListener.java:218)
at org.wso2.msf4j.internal.MSF4JHttpConnectorListener.lambda$onMessage$47(MSF4JHttpConnectorListener.java:129)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:150)
... 25 more
Caused by: java.lang.RuntimeException: Failed to load driver class com.mysql.jdbc.Driver in either of HikariConfig class loader or Thread context classloader
at com.zaxxer.hikari.HikariConfig.setDriverClassName(HikariConfig.java:485)
... 30 more

[2020-09-06 01:15:35,118] ERROR {io.siddhi.core.SiddhiAppRuntimeImpl} - Error starting Siddhi App 'firstdeploy', triggering shutdown process. java.lang.reflect.InvocationTargetException

Can someone please help