Hi Ole, I was trying to update my data table using JDBC option in DATA SINK but i am getting an as no suitable driver is found .. I have also attached a screen shot along with my post kindly go through it
Hi Ole, Yes I have loaded the jar in the specified folder why I escalated this problem because I am able to store the data in MYSQL without any problem using JDBC driver . But if i use the same connection string in Data Sink i came across this problem . I have used the following strings in my test
Driver :"com.mysql.jdbc.Driver" Connection string which i used :sql = Sql.newInstance("jdbc:mysql://localhost:3306/anand", "root", "evipass",
yes; every property in the DataSink is set as a parameter in the update, and since you don't have any (specified with a '?' in the SQL), you are getting this. Either remove the result property or add a parameter to your SQL statement!
Hi Ole, I have tried what you said but got an erro like
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE "RESULT"=24' at line 4
the update syntax which i used is UPDATE DATA SET X= 2, Y=3, WHERE "RESULT"=24;