Metelda Ganugapanta

Hi Joe
Thanks for your help.
I have set the classpath and changed the port number too.
It is working now.
Metelda

Hi all
I have followed the above link "Oracle 9i JDBC Developer's Guide and Reference "
I have not downloaded the file "ojdbc14.jar" since it is already in the
"oracle9201\jdbc\lib".
Now I am trying to find out the DriverVersion.
I am compiling this file
import java.sql.*;
import oracle.jdbc.driver .*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc racle:thin:@localhost:2030:mary","scott","tiger");
// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData();
// gets driver info:
System.out.println("JDBC driver version is"+ meta.getDriverVersion());
I am getting an error
package "oracle.jdbc.driver.*;" does not exist.
Also I am not sure about the port number and SID.That was the number I noted down when I downloaded Oracle.
Can anyboby please help me ?
Thanks
Metelda

Hello Jamie
Thanks very much for your reply.
So,all I have to download is "ojdbc14.jar" .
Thanks for the additional link you provided.
Metelda

Hi
I am new to jdbc. I have Orale9.2.0.1 and jdk1.4.0 installed on my Windows XP machine.
I want to install a driver from the following website.
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html
There are 3 files to be downloaded.
ojdbc14.jar
ojdbc14_g.jar
ocrs12.zip.
I have not downloaded them yet.
Am I doing correctly?
Is this a java Thin Driver that I am downloading ?
Is this JDBC2.0 or JDBC3.0 ?How would I know ?
Thanks
Metelda

Hi Bill
I changed "start" to "run".
Tomcat is working now.
It is using port"8010".
I am really happy now.
Thanks you Bill and Thank you Mike for your help.
Metelda

Hi Mike
Thanks very much for your response.
I changed that line from "port=80" to "port=8010" (port=10 even ).
But it did not work.
Can you please tell me if I have done correctly.
Metelda

Hi Mike
Can you please tell me which other port than "80" do I have to use ??
As you said "http://localhost:8080" is not working.
Thanks for your response.
Metelda

Hi Bill
Thanks for your reply.
When I run from command line (i.e. startup) 'it just opens another window still disappears'.
when I shutdown I am getting these errors.
Catalina.stop:java.net.ConnectException:connection refused:connect
at java.net.PlainSocketImpl.SocketConnect(Native Method)
.... doConnect(....)
..... connect(.... like this .
I just don't know what to do.
Can anybody help me ?
Thanks
Metelda

Hi Oliver
Thanks for your reply.
when I say "http://localhost" or "http://localhost:80" or "http://127.0.0.1" it is giving the same web page.
Can you please tell me what is meant by "checking the log "?
Where do I have to check ?
Thanks
Mary

Hi Everyone
I was working with Tomcat a year ago. It worked well then. When I double clicked "startup.bat" today it comes upto here
Starting Service-Tomcat Stand Alone
Tomcat/4.1
Then with so many errors which I could not even see ,the screen disappears.
when I type "http://localhost" I am getting a page like this
ORACLE HTTP SERVER COMPONENTS
Apache
Jserv
....
etc.
I am not able to access any files with the link "http://localhost/servlet/Hello.html" (which are in the root directory)
Can anybody please help me ?
Thanks
Metelda

Thanks very much for your help,Pavel.
Thanks very much ,Sujatha.

Hi Everyone
I am new to JDBC.
I have Oracle 8.1.7
j2sdk1.4.0 installed on my Windows XP machine.
Can anyone get me the links I have to go through to connect to Oracle.
Do I have to download any drivers specifically???
Everything is so confusing for me.
Is there any detailed procedure anywhere?
I have been searching for information for a while
and I just now read that Oracle 8.1.7 supports only jdk1.2.x. If that is the case ,Do I need Oracle 9i?
Thanks
Metelda