CODEWITHSUNDEEP
oracle-databasewebspheredatabase-connectiondatasource
Dio
Dio

Reputation: 21

Initializing Database Connections with SQL Code in WebSphere 8

Oracle WebLogic allows initializing database connections with SQL Code (s. http://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/jdbc_connection_pools.html#1127542). Is there any way to do this in WebSphere 8?

Upvotes: 0

Views: 425

Answers (2)

F Rowe
F Rowe

Reputation: 2064

Please see the Connection validation by SQL query column of the Application programming model row in the deprecation table for the recommended alternative. IBM support cannot provide you with a time frame for removal, as there is no fixed time frame for deprecated features to be removed. At a minimum, the feature will not be removed for 2 releases after deprecation. In this particular case, the feature was deprecated because the JDBC spec now defines similar capability.

Upvotes: 1

Gas
Gas

Reputation: 18030

Yes it is possible. See WebSphere Application Server data source properties page.

You need to check: Validate new connections and provide your SQL code in the: Validation by SQL string in the Data source properties.

Upvotes: 0

Related Questions