-
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("jdbcracle: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)
)
)
***********************************************
let's eat fish!
-
can you tell me more about you jdbc driver and jre
Just wanna get more and more professional with oracle
Just wanna a job relateed with oracle
-
No special setting is needed for the thin driver.
My guess is that you put the database name instead of computer name/IP address in the connect string:
conn = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@tmsd2:1521:TMSD2");
Try:
conn = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@imron:1521:TMSD2");
or write the IP address of the imron computer there.
Ales
-
aha....
you're right.....!!!
now I can play my database with java...
it's so exciting....
Thanks Ales.....
let's eat fish!
-
Enjoy!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|