Menu
▾
▴
#1 How to configure Oracle JDBC-access?
I'm trying to connect to a Oracle-DB on another
computer and somehow the connection couldn't be
established.
From the Oracle Drive I've selected the 'ojdbc14.jar' and
the Driver Class Name is 'oracle.jdbc.OracleDriver'.
I create a new alias with the Oracle-driver with the
sample URL 'jdbc:oracle:thin:<HOST>:1521:<SID>'.
At the next step I try to connect to with my UID and
PWD but nothing happens. No connection is established,
no error, no warning, no logging, nothing at all.
I'm using Eclipse 2.1, JDK 1.4, Oracle 9.2.
How to configure, so the connection works?
Logged In: YES
user_id=556246
1) Look in the the driver view. Has the Oracle Thin Driver a check
icon? If it has an error icon it means that the driver is not
properly set.
2) Have you seen the logs of JFaceDbc? They can be seen by
clicking on the button in the toolbar. I've tested JFaceDbc only
with Oracle 8.1.7. I'm using the same driver (ojdbc14.jar).
Logged In: YES
user_id=703323
1) In the Driver table I only see enabled the JDBC ODBC Bridge
AND the newly added Oracle Driver. So, the Oracle Thin Driver
is NOT enabled! How to check how to set it properly?
1a) With the newly added ojdbc14.jar, what URL is the proper
one?
2) No, I haven't see the logs of JFaceDbc. Where can I find
them? I can also not find a button in the toolbar. Perhaps
wrong installation, but I extracted everything in one directory.
Logged In: YES
user_id=556246
I'm using the oracle thin driver. I've attached to it the jar file
ojdbc14.jar. My example url is:
jdbc:oracle:thin:@<server>[:<1521>]:<database_name>
The selected driver is "oracle.jdbc.OracleDriver"
The real url is
jdbc:oracle:thin:@host:1521:sid
Check if your alias uses the right driver.
Logged In: YES
user_id=703323
Don't know if I understand the proper way and let's check
what I've done:
- The listed Oracle Thin Driver is crossed out
- I added in the Extra Class Path ojdbc14.jar
- I selected the suggested "oracle.jdbc.OracleDriver"
In the real url I have given the proposed url with subtitution of
the Host and SID.
TNSPING on the SID works quite fine.
If I specify a wrong server, SID then I have the same effect
as specifing correctly, namely no Errors, no Warnings, nothing.
Where I can I find some logs?
Logged In: YES
user_id=556246
In the main view of JFaceDbc, when there are no connections,
there are only two active buttons. One of them is for opening the
logs.
Logged In: YES
user_id=841665
Hi,
i solve the problem with an old version (8.1.7) of the "Oracle
Thin driver". Download the old driver ("classes12.zip" from
the "Oracle Technology Network". Secondary you must
download the "Oracle Thin Driver Patch" for the 81.x Driver.
See the Readme.txt in the "Patch-Zip"-File for further
Information. Patch the "classes12.zip" package.
If you have done the patching, add the new driver to the
classpath. Restart your Eclipse and try it again.
The trick is: You can use the Driver "8.1.7" (with Patch) to a
9i Database !!!
Now JFaceDBc is working fine :-)
Tarlon
Logged In: YES
user_id=113949
I have the same problem after installing the oracle client.
Logged In: YES
user_id=113949
Be carefull: jfacedbc works only with JDK1.4. During
installation the oracle client change the jdk (in the PATH) to
JDk 1.3.1