cancel
Showing results for 
Search instead for 
Did you mean: 

Mysql database not connecting

Occasional 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.
15 REPLIES 15
Highlighted
Super Contributor

Re: Mysql database not connecting

Hi,

of course this should work.. the coming 1.7.5 has much improved error messages for database connections, but for now lets try:

1) only have one jdbc driver in the lib directory
2) when trying to connect check the console window for error messages
3) also, be sure that mysql is set up to listen for remote connections.. you can check this by opening a command-prompt and trying to telnet to mysql with "telnet :3306" where you will get an error if the server is not accepting or available due to some network reason..

please let me know if the above helps!

regards,

/Ole
eviware.com
Highlighted
Occasional Contributor

Re: Mysql database not connecting

It is not at all working 
i removed one driver now.and still it is showing nothing no error nothing .
hm about telnet i need to check .
but my db connection is working good in netbeans.
as i i need this database step ,I am not using netbean plugin for soapui.

Give me some more suggestions what can be done?
btw my system is VISTA business.

Regards
Highlighted
Super Contributor

Re: Mysql database not connecting

Hi,

hmm..  if it works in netbeans then it should work here as well. Can you mail me a screenshot of the datasource step window and the console window after you have tried to test? (ole@eviware.com)

regards,

/Ole
eviware.com
Highlighted

Re: Mysql database not connecting

One small comment: the telnet connection string should be

telnet servername 3306 (for example telnet 3306).

You connection string looks fine. I Would possibly like to look at the select string.  usually there is no error log in soapUI, but there is one in the console window.

Do you think you could send us either a screenshot from the step or a copy of the project file. We will make this work.
Product Guy for Ready! API, SoapUI and all things API
Highlighted

Re: Mysql database not connecting

One small comment:

Did you put it in lib/ext?

correct paths are

soapUI-Pro\bin\ext
or
soapUI-Pro\jre\lib\ext

/niclas
Product Guy for Ready! API, SoapUI and all things API
Highlighted
Occasional Contributor

Re: Mysql database not connecting

Sorry im confused .the path should be

soapUI-Pro\jre\lib\ext\mysql-connector-java-5.0.6-bin
or

soapUI-Pro\jre\lib\mysql-connector-java-5.0.6-bin

I will send u my screen shots soon.
Highlighted
Super Contributor

Re: Mysql database not connecting

Hi,

you can also try

soapUI-Pro\bin\ext\mysql-connector-java-5.0.6-bin

regards,

/Ole
eviware.com
Highlighted
Occasional Contributor

Re: Mysql database not connecting

Sorry,I found what mistake i was doing.
Thanks for ur advice..
Actually i didnt reallise earlier that the colum. property name should be the same as the table colum name in database table.(am i right)?

Regards
Highlighted
Super Contributor

Re: Mysql database not connecting

oh ok 🙂

I'll add an error message for this as well.. (ie if there are no matching properties/columns)..

Don't hesitate to post again if you run into any more issues!

regards,

/Ole
eviware.com
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors