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.

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

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.

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.

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

Great!

In regards to your question, you are not quite correct, although that is usually how it works.

If you have a field called author in your database and a property called auth in your DataSource Step  the following works perfectly fine;

SELECT author as auth FROM tb_author

/niclas

Hi!

yes.. we know... All that is planned, but thanks for reminding :-)

regards!

/Ole
eviware.com

One more question.

I have setup datasource and with sql command im getting for ex. 200 rows..
in database setup frame.
 I need in my request method that it read from first row give responce and proceed to 2nd row give responce and so on till end...

so the step should be..
datasource(with select sql command)
user request
Data source loop(datasource step 'datasource' and target step 'user request'.
---------
how i can see the result ?Http log is not very clear..
where i can see the result of each request and responce.?

regards