Re: Help me please.

Aaaaaaaaaarrrrrrrrrrghhhh

Connection conn =
DriverManager.getConnection("dbc:oracle:thin:@localhost:1521:sid","username" ,"password");

should read
Connection conn =
DriverManager.getConnection("*J*dbc:oracle:thin:@localhost:1521:sid","userna me","password");

without the asterixes of course and in lower case either your typing or your eyesight is very very troubled.

PLEASE PLEASE verify *CAREFULLY* your own code and don't post *EVERY* error you get
or buy glasses or follow a typing course, as this is the *second* time in *very short* succession you are asking for assistance in typing errors

Regards

Sybrand Bakker
Senior Oracle DBA

"ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message news:9r703v$aua$1_at_eng-ser1.erg.cuhk.edu.hk...
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>
> > "ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
> > news:9r6q1v$7d2$3_at_eng-ser1.erg.cuhk.edu.hk...
> >> I copy the folloiwng program from oracle hompage
> >> http://technet.oracle.com/doc/java.815/a64685/getsta3.htm#1001200
> >>
> >> 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:oracle:thin:@:1588localhost:sid","username
> > ","password");
> >>
> >> // Create Oracle DatabaseMetaData object
> >> DatabaseMetaData meta = conn.getMetaData ();
> >>
> >> // gets driver info:
> >> System.out.println("JDBC driver version is " +
meta.getDriverVersion());
> >> }
> >> }
> >>
> >> sid is the sid of my database. username and password is the login
username
> >> and password.
> >> I haven't changed the port nubmer. Is it true that the default port is
> >> 1588?
> >>
> >> When I run the program, the following error occur:
> >> java.sql.SQLException: Io exception: The Network Adapter could not
> >> establish the connection
> >> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
> >> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
> >> at
> >> oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
> >> at
> >>

oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
> >> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
> >> at java.sql.DriverManager.getConnection(Compiled Code)
> >> at java.sql.DriverManager.getConnection(DriverManager.java:126)
> >> at JDBCVersion.main(JDBCVersion.java:11)
> >>
> >> How can I solve the problem?
> >>
> >> Very urgent, if possible, please reply me by e-mail.
> >> Thank you very much!
> >>
> >> --
>
>
> Sorry for any inconvenient. However, in my situation, time is a very
> importanat factor. I cannot waste a lot of time to see the documentation.
> My requirement is that I can connect to Oracle, no other things.
> I'm not a DBA or DBO to Oracle. I'm just a student. I must setup my Oracle
> as quicly as possible in order to start my real work. Installation of
> Oracle is only a preparation step in my project. I don't want to waste a
> lot of time on it.
> Hoping that all of you can understand me.
> Sorry for any inconvenient.
>
> At last, I use OCI driver in stead of thin driver to connect to the
> database.
> Can anyone tell me why I can't use thin driver?
> What's wrong in this line?
> Connection conn =
>

DriverManager.getConnection("dbc:oracle:thin:@localhost:1521:sid","username" ,"password");
>
> > Could you *PLEASE* stop posting your questions to every Oracle
newsgroup, or
> > crosspost if you think you really need to do it. You're wasting bandwith
and
> > you won't get a bigger and better audience as most people responding
here
> > monitor all groups. Also, when you post in succession, no one will see
the
> > answers in other newsgroups and see the request has already been
answered.
>
> > Regards,
>
> > Sybrand Bakker
> > Senior Oracle DBA
>
>
>
>
> --
Received on Wed Oct 24 2001 - 13:50:33 CDT