Contributions
Re: How to use GetData in SQL in DataSource
Sorry, forum deletedthe secondhalf of my message. it errors out: Can’t get the connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘${PreparedProperty1#Variable19 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.3KViews0likes0CommentsHow to use GetData in SQL in DataSource
Hello, I'm trying to use GetData in SQL Query. If I use an expression ... WHEREColumn1 = “${TestStep1#Variable1it errors out: Parsing error. Failed to parse SQL query. Invalid SELECT statement. Unexpected token ‘{’ at line. If I use an expression ... WHEREColumn1 = “${PreparedProperty1#Variable1}” it errors out: Can’t get the connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘${PreparedProperty1#Variable1}’. How to use GetData in SQL in DataSource?9 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.3KViews0likes1CommentRe: Switching to Form view and back to XML view deletes field tags that were blank.
Hi Tanya, Thank you for your prompt reply. I installed the maitenance build using the link you provided. After installationan instance of regularReady API was launched automatically. I encountered absolutely the same issueas Idescribed yesterday. Structure <abc: State></abc: State> didn't make any difference. This tag was deleted anyway. Then I manually ran another instance of Ready API Snapshot from Windows menu.The behavior was slightly different: an Error showed up with following text: Do you want to recreate a default message from the schema? I clicked No andall the fields dissapeared from Form view butxml file wasn't blanked out. Running my service createdan error. Then I closed current Ready API Snapshotinstance and launched another one. This time I answered Yes to the error message. Itset all the fields to "?" value butkept the structure in both Form and XML views. I think I will stick with regularReady APIrather thanSnapshot. IfI don't switch to Form view,Ready APIallowsme to run services based on an XML file.9 years agoPlace ReadyAPI QuestionsReadyAPI Questions3KViews0likes1CommentSwitching to Form view and back to XML view deletes field tags that were blank.
MyXML file contains following structure: <!--Optional:--> <abc: State/> <!--Optional:--> <abc: PostalCode/> <!--Optional:--> <abc: Country/> After switching to Form view and back to XML the same area looks like that: <!--Optional:--> <!--Optional:--> <!--Optional:--> Is it a bug?9 years agoPlace ReadyAPI QuestionsReadyAPI Questions3KViews0likes8Comments