Forum Discussion
TomK
16 years agoContributor
Somehow I managed to make the datasink work.
I was able to insert and update mySQL using prepared statements
And was able to insert and update DB2 but had to use a different Connection String (which forces the use of a different driver). I used this version of the string: "jdbc:db2://server:port/database:user=xxx;password=xxx;"
If the server and port are omitted then the CLI driver is used which throws the following exception when using a prepared statement:
Wed Jun 25 16:22:42 BST 2008:ERROR:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
So all is sorted really.
Regards,
Tom
I was able to insert and update mySQL using prepared statements
And was able to insert and update DB2 but had to use a different Connection String (which forces the use of a different driver). I used this version of the string: "jdbc:db2://server:port/database:user=xxx;password=xxx;"
If the server and port are omitted then the CLI driver is used which throws the following exception when using a prepared statement:
Wed Jun 25 16:22:42 BST 2008:ERROR:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
So all is sorted really.
Regards,
Tom