A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
this week in the
Cam i set catalog on connection with oracle
Joined: Jan 10, 2007
Dec 04, 2007 13:51:00
lets say i have a connection that i get from data source.
The connection is to user XXX.
can i change the user in run time?
In my sql i point the data source to localhost:3306 and set the schema (catalog) in run time, can i do something like this in oracle?
author & internet detective
Joined: May 26, 2003
Dec 04, 2007 17:36:00
No. The connection is tied to a specific user. To change user, you need to get a new connection.
This is similar to how you have to reconnect to login with a different user id at the sql plus command line.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Cam i set catalog on connection with oracle
New to WebSphere and need help
Please help with DataSource problem
EJB connection pools vs. Individual Oracle logins
Creating connection pool and data source dynamically
Obtain reference of database connection pool within EJB stateless bean for OC4J
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014