Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Why I cannot use the sample program?
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:56 CDT
![]() |
![]() |