Re: Help me please.

From: ftp <shyan_at_cse.cuhk.edu.hk>
Date: 24 Oct 2001 18:09:03 GMT
Message-ID: <9r703v$aua$1@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:09:03 CDT