Contributions
JDBC SQL Server Connection drops out
I have a set of scripts that I use to bulk load a demonstration system. It connects to a SQL Server database, and retrieves a recordset that it then processes through in a loop. Full processing can be over a number of hours. However, I often find that the loop crashes because of a lost SQL connection. I have two questions as a result: 1. How can I keep the SQL connection open, so that the Data Loop does not fail? 2. If #1 is not possible, are there any suggestions as to how I might loop back to restart the SQL Connection? Many thanks for your considerations ...Solved1.3KViews0likes1CommentRe: Changing Excel Data Source file name based on Environment change
Found my own answer. In case anyone else is wondering, what I did was create a Custom Property "sourceFile". Then in the Excel data source definition, I was able to reference that Custom Property by putting "${#Project#sourceFile}" in the file name property. I also assume (although have not yet tested) that I would be able to change the Worksheet name in the same way. Hope others find this useful.6 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.7KViews1like2CommentsChanging Excel Data Source file name based on Environment change
I wish to use the same scripts but across a number of environments. I would like each environment to use a different Excel data file to populate the data source. However, I can not see how this can be achieved? I have been able to change web service connection points and JDBC connections, but can not see how to change the file name for an Excel Data Source. I would even be happy to change the tab name, rather than the file name, but this does not seem possible either.Solved6 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.7KViews0likes3Comments