You can translate the question and the replies:

How can you expire all connections at once?

Is there a way to expire the existing connections to the database? We've run into an issue where extra roles are granted while we still have a connection to the database and I wanted to force expire the connections in an effort to pick up the new roles.
user
15-10-2014 16:49:35 -0400
code

2 Answers

Are you referring to the connections from the connection pool of a JDBC/ODBC data source? If that is the case you can edit and recreate the data source as it is, that will close all the connections in the pool and will create new ones when the data source is created again.
Denodo Team
15-10-2014 20:18:18 -0400
code
Yes, the connections in the JDBC/ODBC connection pool. Thank you for the answer... If we need to do this on a regular basis I'll write a script using the "CREATE OR REPLACE" syntax. Thanks!
user
16-10-2014 13:17:47 -0400
You must sign in to add an answer. If you do not have an account, you can register here