VikramAditya
asked on
ORACLE8i access through java
I have oracle8i database configured on a RedHat linux 6.0 machine having a valid IP address.How can I remotely connect and access the database through java program incorporating the Jdbc API.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<interested>
One important thing I want to make sure is understood.
On the client machine, although I said you should have an oracle client installation including java drivers, the truth is that if you don't need the oracle client itself you can still have program the java working by only using the java drivers.
The java drivers are a set of .class files that you should include in your CLASSPATH, and they implement the SqlNet(and Net8) protocol by themselves so you don't really need the whole client.
All you have to make sure is that you have a connection to the database server (ping) and that the database on the other side, is up and a LISTENER is set up on the server to listen on the port you specify in you java program.
On the client machine, although I said you should have an oracle client installation including java drivers, the truth is that if you don't need the oracle client itself you can still have program the java working by only using the java drivers.
The java drivers are a set of .class files that you should include in your CLASSPATH, and they implement the SqlNet(and Net8) protocol by themselves so you don't really need the whole client.
All you have to make sure is that you have a connection to the database server (ping) and that the database on the other side, is up and a LISTENER is set up on the server to listen on the port you specify in you java program.