Re: Why I cannot use the sample program?

"ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message news:9pv9s7$28m$1_at_eng-ser1.erg.cuhk.edu.hk...
> In http://technet.oracle.com/doc/java.815/a64685/getsta3.htm#1001200
> there is a sample program to show the JDBC version.
> 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:_at_host:port:sid","scott","tiger");
>
> // Create Oracle DatabaseMetaData object
> DatabaseMetaData meta = conn.getMetaData ();
>
> // gets driver info:
> System.out.println("JDBC driver version is " + meta.getDriverVersion());
> }
> }
>
>
> However, I cannot run this program successfully. The following eror
> message appears:
>
> java.sql.SQLException: Io exception: Invalid number format for port number
> 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)
>
>
> I have tried to change
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:_at_host:port:sid","scott","tiger");
> to
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:_at_localhost:1888:MySid","scott","tiger");
> but still fail.
> How can I know the port nubmer?
> What should I do?
> --

[Quoted] [Quoted] The port number is the port number defined in tnsnames.ora, usually 1521

Sigh.... Why would Oracle provide documentation if no one actually reads it.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 09 2001 - 19:09:23 CEST