Re: Why I cannot use the sample program?

Find the listener.ora file for your database. It will be on the database server machine.
Look at the entry for MySid.
1521 is a default port for Oracle.

hth,
cindy

ftp wrote:

> 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:@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:@host:port:sid","scott","tiger");
> to
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@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 - 12:23:11 CDT