Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set current_schema in Connection Pool

monteagudosJun 28 2007 — edited Jun 29 2007

We are developing an application that connects to DB with a user who is owner of the data,
but proper privileges have benn granted.

To acces data (that are in other schema) we have reference the object as 'OWNER.TABLE_NAME'.

An alternative would be to use the instruction “Alter session Set current_schema=OWNER” before any instruction.

Is it possible to execute this instruction when initiating Connection Pool?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2007

Added on Jun 28 2007

#java-database-connectivity-jdbc

3 comments

1,361 views