Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Why I cannot use the sample program?

Why I cannot use the sample program?

From: ftp <shyan_at_cse.cuhk.edu.hk>
Date: 9 Oct 2001 16:50:36 GMT
Message-ID: <9pv9ss$28m$2@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:@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 - 11:50:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US