In between i tried ur option but its not working as..
made select statement
select '<name>'+name+'</name>' from table ...
then in the coloum name its is added '<name>'+name+'</name>' in a same way (not in results) .I add property in datasource the same as the colum '<name>'+name+'</name>' (as it is must otherwise i will not get the value).
and when i get the null field then it is showing ${'<name>'+name+'</name>'} so i guess that will not work ..:-(

If it can be done with groove script then can u clear a bit picture in my mind how it can be done with on field or something like that...

Regards

Manish

The thing is,I also want that my logic in endpoint will not read that element when it is null or with (${DataSource#name} at present case).

How that logic can be made that before request is sent to the server ,Data is checked by a logic in SOAPUI and then that XML elements from soap request are disabled when it find (${DataSource#name}).

FOR example if data contains '$' in xml element then disable it .?

btw i try what u have said but it would be a long work:-( as my sql statement contain 20 tables with 300 data fields.


Regards

My problem..
 
Im making test for our webservices.Im doing it with my jdbc datasource .
In my test case
I hav put all the properties from the datasource in my request method.
 
But some field are optional and for that i put in my corrosponding database fields blanks(null).
When im running the test,At the property where the corrosponding data in null in database, It is sending the ${propery field..} to my request.In my response im getting errors(number format exp or date time exp..)coz it is now seeing the ${property field} instead null.
 
My Question is How it can be done that elements in the soap request are removed when the corrosponding field is null in database and only request with filled fields proceed???
 
I think this the the best way to solve this problem(or if there is other way??) but can someone tell how it can be done?
 
Regards
Manish

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

Just suggestions..

There should be browsing sytem instead of typing the driver name

and connection string interface should be improved

And u should also put flash based tutorials with voice like i have seen with other tools..

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

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.

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

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.