File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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.
OCA 8 book
How To Ask Questions The Smart Way
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-2015