manish_singh
17 years agoOccasional Contributor
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.
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.