JDBC connection problems

Guys..

I found solution

your DNS should look like this

jdbc:db2://HOSTNAME:60000/DEM3SY20:user=USER_NAME;password=PASS_VALUE;

NEVER miss ; or ;

Hi Tom!

2 questions for you:

1) Can you see in the soapui log that the driver jar is being loaded at startup?
2) What is the exact error message you are getting? (details in the error-log?)

regards,

/Ole
eviware.com

1) Can you see in the soapui log that the driver jar is being loaded at startup?
Yes
Fri Jun 13 11:03:28 BST 2008:INFO:Added [file:/C:/Program%20Files/eviware/soapUI-Pro-2.0.2/bin/ext/db2java-8.jar] to classpath

2) What is the exact error message you are getting? (details in the error-log?)
Fri Jun 13 11:03:45 BST 2008:ERROR:java.sql.SQLException: No suitable driver found for jdbc:db2://xxxxxx.uk.gl3:000000/XXXXXX

Hi Tom,

are there any other error messages in the console log? Could it be that the db2 driver requires some other dependencies also to be loaded?

regards,

/Ole
eviware.com

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.

While copying driver information on saop UI, be cautious... extra spaces might cause problem in identifying driver.  So remove any extra spaces when you filled driver information in data source form

Hi,

thanks for pointing this out, we'll make this a bit more error-proof in the next release..

regards!

/Ole
eviware.com

I don't think I had any extra spaces in there.

Managed to figure out the following.

IBM DB2 Type 2 driver does not work from Datasource step as it does not support user and password attributes in the URL.

so this driver won't work: COM.ibm.db2.jdbc.app.DB2Driver (db2java.jar) from Datasource step. (It works from a groovy script)

Instead IBM DB2 Type 4 driver (db2jcc.jar) does work:

com.ibm.db2.jcc.DB2Driver and connection URL:

jdbc:db2:[//server:port/]database:user=XXX;password=XXX;

Also quotes around the SQL in the SQL field cause an exception to be thrown.

Hi all,

I downloaded DB2 driver from

https://www14.software.ibm.com/webapp/i ... ethod=http

placed driver file in /ext folder, restarted soapu pro.

I used connection string as : jdbc:db2://IP:port/db-name&user=apptest&password=testpwd

Do I need to separate userid &password by ; or & ?

ERROR MESSAGE am getting is :

Can't get the Connection for specified properties; com.ibm.db2.jcc.a.rm: [jcc][t4][10205][11234][4.0.100] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815

another error message is

Can't get the Connection for specified properties; com.ibm.db2.jcc.a.rm: [jcc][t4][10205][11234][4.0.100] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815