Forum Discussion

manish_singh's avatar
manish_singh
Occasional Contributor
17 years ago

Mysql database not connecting

I am having a big problem after trying so many times im am not able to connect with mysql database running on our server.
As Our company is Searching the WS testing software and I have to recommend them.and after using many software i am going for this coz of better GUI and low cost.
My prob.
Im connecting with following command in my datasource with JDBC

Driver - com.mysql.jdbc.Driver
Connecting String - jdbc:mysql://servername:3306/DataBasename?user=user&password=pass.

I use basic sql command' select ... from  tablename '
 
I press test but it shows nothing (show in side got 0 rows in ..ms)

i put one property against one fetching col.

What i did till now ..
I use the both drivers 'mysql-connector-java-3.0.17-ga-bin' and 'mysql-connector-java-5.0.6-bin' in my lib directory of SOAPUI.(first hoped i atleast one should work).

I restarted it . checked again but didnt work

I checked the database and port ,host,database  are working good.

It is very painful that it is not showing any error or warning when we r using database.
Help me what can be done in this situation as DB connection is very important for our ws application otherwise i need to search something else.

15 Replies