Forum Discussion

m_atty's avatar
m_atty
Occasional Contributor
6 years ago

Close JDBC connections following JDBC datasource step

Hi all,   We have built a set of test cases that follow the steps below:   1. JDBC DataSource Step - this step connects to our database and pulls back a set of data that we will use in our re...
richie's avatar
richie
Community Hero

hi,

 

what RDBMS is it?  I know Oracle has a kill session SQL command (I've used it before) - you can run this in theJDBC step (although the user you are using in your connection will need appropriate privileges to enable you to run the kill session command successfully)

 

I had a quick search for SQL Server and found the following here

 

I found the following for DB2 here

 

dont know if any of this helps, but I have done it outside SoapUI using SQL for DB2, ,SQL Server and Oracle although its been a while

 

cheers,

 

rich

m_atty's avatar
m_atty
Occasional Contributor
6 years ago

Hi Richie, and thanks for the reply.


Apologies, I should have mentioned that. It's an Oracle database.

 

From what I can tell, in the JDBC step I can only enter one query/command. So I'd have to create a new JDBC step to run the KILL SESSION command, which would kill that session and leave the first one open.