Why I cannot use the sample program?

From: ftp <shyan_at_cse.cuhk.edu.hk>
Date: 9 Oct 2001 16:50:15 GMT
Message-ID: <9pv9s7$28m$1_at_eng-ser1.erg.cuhk.edu.hk>

In http://technet.oracle.com/doc/java.815/a64685/getsta3.htm#1001200 [Quoted] 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?

-- 

Received on Tue Oct 09 2001 - 18:50:15 CEST