This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Exception in thread "main" java.sql.SQLException: No suitable driver
JDBC connection to Oracle 8.0.5
Compatibility Problem???
WSAD and JSQLConnect Driver
problem - db2 database configuration in datasource