My Oracle Support Banner

how to change the date format using initSQL from weblogic console (Doc ID 2238653.1)

Last updated on JANUARY 31, 2020

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.

Goal

How to enable the feature of Initializing Database Connections with SQL Code

As documented in "https://docs.oracle.com/middleware/1212/wls/JDBCA/jdbc_datasources.htm#JDBCA159", WebLogic Server runs SQL code using Init SQL attribute on the JDBC Data Source: Configuration: Connection Pool page in the Administration Console whenever it creates a database connection for the data source, which includes at server startup, when expanding the connection pool, and when refreshing a connection.

But this feature did not work for the below query

The same feature is working for Oracle forms and Reports

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.