Not able to establish the connection
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 kin...
Forum Discussion
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;
Can you tell m where did i went wrong
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;
Can you tell m where did i went wrong
