Re: Help me please.

"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!
>
> --

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 - 12:22:53 CDT