JDBC connection problems
Hi all, I searched through the forums and people have posted similar issues but no resolution was posted to those. Hence I'm posting again. I'm trying to connect to DB2 via JDBC from soapUI (tri...
Forum Discussion
I have managed to narrow it down to that this driver may not support username and passord in the URL.
I have used another driver (db2jcc) which supports the user and password in the string and now I'm getting:
Mon Jun 16 06:30:19 BST 2008:ERROR:An error occured [[ibm][db2][jcc][10103][10941] Method executeQuery cannot be used for update.], see error log for details
This is the SQL I'm using:
"SELECT * FROM YESNONA"
I'm really frustrated with this. I would want to purchase soapUI pro and get started with my testing, but I really can't do any testing with a DB connection.
Any help would be very much appreciated.
I have used another driver (db2jcc) which supports the user and password in the string and now I'm getting:
Mon Jun 16 06:30:19 BST 2008:ERROR:An error occured [[ibm][db2][jcc][10103][10941] Method executeQuery cannot be used for update.], see error log for details
This is the SQL I'm using:
"SELECT * FROM YESNONA"
I'm really frustrated with this. I would want to purchase soapUI pro and get started with my testing, but I really can't do any testing with a DB connection.
Any help would be very much appreciated.