Specify default schema for JDBC pool in weblogic/oracle

oracle jdbc weblogic
Roman Goyenko picture Roman Goyenko · Apr 17, 2013 · Viewed 9.5k times · Source

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?

Answer

Roman Goyenko picture Roman Goyenko · Apr 17, 2013

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.

Related questions

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does …

Read More
Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More
No more data to read from socket error

We are using Oracle as the database for our Web application. The application runs well most of the time, but we get this "No more data to read from socket" error. Caused by: java.sql.SQLRecoverableException: No more data to …

Read More