Datasink problems writing to MySQL or DB2
Hello, I am trying to use datasink to write some data to either MySQL or DB2. I have tried all ways ie. Like prepared statements, hard coded. Nothing seems to work. The datasink fails (icon becomes...
Forum Discussion
I managed to write to a mysql database using jdbc in the setup script (both insert and update) using prepared statements but still no luck with datasink.
With DB2 it's a little trickier. I can write to DB2 using hard coded values.
If I use prepared statement and press the green arrow on the setup script - nothing happens, nothing get written to the DB. If I press the green arrow on the test the following exception is logged in soapUI log and test log: java.lang.UnsatisfiedLinkError: COM.ibm.db2.jdbc.app.DB2PreparedStatement.SQLBindChar(IIJILjava/lang/String;IJ[JIIZ)I
Hope that helps.
Regards,
Tom
With DB2 it's a little trickier. I can write to DB2 using hard coded values.
If I use prepared statement and press the green arrow on the setup script - nothing happens, nothing get written to the DB. If I press the green arrow on the test the following exception is logged in soapUI log and test log: java.lang.UnsatisfiedLinkError: COM.ibm.db2.jdbc.app.DB2PreparedStatement.SQLBindChar(IIJILjava/lang/String;IJ[JIIZ)I
Hope that helps.
Regards,
Tom
