product-sp
product-sp copied to clipboard
wso2
Not able to connect to the MYSQL using Streaming Integrator Tooling , getting driver error
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:
- MYSQL installed on my system is 8.0.21
- 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
- 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;
-
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
-
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.
[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
