File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes data base alias name Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "data base alias name" Watch "data base alias name" New topic

data base alias name

durga prasad

Joined: Nov 14, 2002
Posts: 3
Please help me out to get answer to my production problem.
My code(JDBC) gets database connection from oracle database. But if I change the database to alias name it does not recognise the database.
I am using JDK 1.3 and oracle 8.0; Is it problem with version of JDBC i am using? Is JDBC version of JDK 1.3 support alias names for the database?
Please reply soon.

Chandresh Patel

Joined: Jul 05, 2002
Posts: 14
I think you are missing some comfiguration. Please clarify how you are getting connection. is URL wrong?

durga prasad

Joined: Nov 14, 2002
Posts: 3
nope. Connection woks with actual database name but not with the alias name. I learnt that oracle thin driver doesn't support this kind of failover and hence I tried with thick driver(OCI) but I did not get the result!! Thanks
I agree. Here's the link:
subject: data base alias name
It's not a secret anymore!