Home » Developer & Programmer » JDeveloper, Java & XML » Broken Database Connection
Broken Database Connection [message #128758] Wed, 20 July 2005 08:18 Go to next message
dmwallac
Messages: 20
Registered: July 2005
Junior Member
Is it possible to establish a database connection in jdeveloper, to an oracle database, without providing the ip address and port information?

I have tried everything I can think of and still always I am asked for these. This is what tnsnames.ora is for. Are there other drivers (or connection types) that take advantage of tnsnames that maybe I could install and see from jdeveloper? I don't provide ip/port for sql*plus and it connects fine.

If I know the instance name of the database, as an application developer, I should not have to know or care what server or port it is on. Our DBAs recently relocated some database instances while consolidating servers and broke my application because of that information being hard-coded. Their response: We updated tnsnames, why isn't your app using that!

Please help the newbie!
Re: Broken Database Connection [message #128768 is a reply to message #128758] Wed, 20 July 2005 09:29 Go to previous messageGo to next message
kmmfoo
Messages: 38
Registered: June 2005
Location: massachusetts
Member
The problem you report suggests that you are using the "thin driver" to connect to your oracle database. Typically your connect string looks something like

"jdbc:oracle:thin:@hostname:1521:instancename"

Using that approach has a few benefits, namely that you don't need the oracle client installed, and you have total control of the target address from within the connect string.

The other approach is called the "OCI driver". In that case your connect string looks something like

"jdbc:oracle:oci:@entry_from_tnsnames"

The "OCI" approach uses TNSNAMES to figure out where the target database is located.

There are a few other repercussions of switching drivers -- mostly which libraries you include in your project -- so you should check out the oracle documentation for more info.

HTH...
Re: Broken Database Connection [message #128997 is a reply to message #128768] Thu, 21 July 2005 08:18 Go to previous messageGo to next message
dmwallac
Messages: 20
Registered: July 2005
Junior Member
Thanks. That sounds like what I am looking for. I am not sure if my jdeveloper environment is setup properly, though, for using OCI.

I have the Oracle9 client on my machine and my ORACLE_HOME is set for that. I have classes111.jar and classes12.jar on my classpath. But when I try to use jdbc:oracle:oci:@... or even jdbc:oracle:oci8:@... I get the following error:

java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path

It looks like jdeveloper expects Oracle 10. This seems especially weird when I specify oci8. Any ideas?
Re: Broken Database Connection [message #129214 is a reply to message #128997] Fri, 22 July 2005 09:02 Go to previous messageGo to next message
kmmfoo
Messages: 38
Registered: June 2005
Location: massachusetts
Member
To clarify, I've never did no OCI connections myself. However I did a quick google search on your most recent error message, and it pointed to this article:

http://www.oracle.com/technology/sample_code/tech/streams/streamsmessaging/install.html

specifically a "Troubleshooting" section with a pointer to some other suggestions.

HTH...

Re: Broken Database Connection [message #133342 is a reply to message #129214] Thu, 18 August 2005 10:03 Go to previous message
dmwallac
Messages: 20
Registered: July 2005
Junior Member
As a follow-up to this discussion.

My installation of JDeveloper was expecting Oracle10, but my local Oracle client was 9. I fixed the problem by renaming my JAR files in jdbc\lib under JDeveloper (to .xxx) and then copying in the files from \jdbc\lib under my Oracle9 installation. That fixed it.

Hope this helps anyone with a similar problem.
Previous Topic: Loading JDBC Driver for MS SQL Server in Oracle!
Next Topic: how to compare thousands of pairs of XML-documents???
Goto Forum:
  


Current Time: Fri Mar 29 07:53:19 CDT 2024