Ready4API
Occasional Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Not able to use update query in data sink- ReadyAPI
Hi richie , Thanks or your time. I got the actual issue but not sure how to fix it. Will need your help. Whenever i am defining parameter to pass in query it is throwing me error. if i remove the property vale reference and delete parameters created it doesn't throw me error either with single quote or double quote. Please find my query below which is throwing error: update test_out set status=${DataSink#status} where destination={DataSink#destination} Once the properties are there in the window even if i pass hard coded values it throws me java.lang error but after deleting properties created it works fine for hard coded values. Should i be using quotes to pass these parameterized values? Your help is relly appreciated. Attaching what i created as properties. Thanks! RK3KViews0likes5CommentsNot able to use update query in data sink- ReadyAPI
Not able to use update query in data sink. It always throws error "java.lang.exception:SQL error occured". Below is the query i am using(MySql DB): update table_out set status="Trans" where destination="12568" Currently i am blocked due to this. Please help!Solved3.2KViews0likes7CommentsRe: Not able to establish the connection
Hi omatzura AnandKiran How to pass parameters for strings. i am getting the same error "java.lan.exception:An sql error occured". My query in Data sink Update table_abc set status='complete' where destination='61412345678' . Also i want to send parametrized value to update from property attributes. Your help will be deeply appreciated.785Views0likes0Comments