Forum Discussion

Chiam_c's avatar
Chiam_c
Occasional Contributor
8 years ago

can i run multiple jbdc queries with only one constant connection

I may be doing this the wrong way but here is some background.

 

I am useing soapui to create a validation script that connects to our data bases and returns various information on different devices all on a single contract.  so the script does 5 different jbdc test steps per account and each test step retrieves specific information about the account.  

 

The problem: i have been advised that this validation is causing system issues where each time it runs a jbdc query it connects to the database and then does the query , then disconnects.  Each connection is only active for maybe a 10th of a second but it the sheer number of them that is causeing an issue for the database admins.  If this were just a single account this would not be much of an issue but normaly this is done over 200 to 20000 accounts.  That is a lot of connections/disconnections.  Other than condensing all those steps into a single query and thus a single step is there a way to open single connection at the start of a project, run the queries (as this is an iterative process) and then close the single connection after i have checked every account on the list?

 

thank you for your assistance in this.

No RepliesBe the first to reply