PMarriott
New Contributor
Joined 12 years ago
User Profile
User Widgets
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.4KViews0likes1CommentRe: 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.1.8KViews1like2CommentsChanging 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.Solved1.8KViews0likes3Comments