12

We use the same user for multiple projects and I want to have a different default schema for different connection pools. Is there a way to specify the default schema in the weblogic JDBC configuration?

Improve this question

1 Answer 1

Reset to default
22

Ok, I figured it out myself:

If you go to Data Source-> Configuration -> Connection Pool -> click Advanced,

There is Init SQL there that will be executed for initialization of newly created physical db connection, we can put:

SQL ALTER SESSION SET CURRENT_SCHEMA=animals

to make the default schema.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Note: The SQL is mandatory! (Check "Init SQL" at docs.oracle.com/middleware/1221/wls/FMWCH/pagehelp/…)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.