Hi Gurus....
Is there any special setting for Listener in order to respon
thin JDBC connection?
(since thin JDBC use direct socket connection, without sql*net load)
I still unable to establish the connection:
Thanks a lot in Advance...
Imron(Jakarta)
1. the error looks:
#####################################
java.sql.SQLException: Io exception: The Network Adapter could not establish the
connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:263)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va, Compiled Code)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at oracleJava.(oracleJava.java:23)
at oracleJava.main(oracleJava.java:54)
######################################
2. java Code:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@tmsd2:1521:TMSD2");
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3. Listener setting
*********************************************
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = imron)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = imron)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TMSD2)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = TMSD2)
)
)
***********************************************
