DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Listener Setting for Thin JDBC Connection?

  1. #1
    Join Date
    May 2002
    Posts
    22

    Red face

    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!

  2. #2
    Join Date
    May 2002
    Posts
    15
    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

  3. #3
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712

    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


  4. #4
    Join Date
    May 2002
    Posts
    22

    Talking

    aha....

    you're right.....!!!
    now I can play my database with java...
    it's so exciting....

    Thanks Ales.....
    let's eat fish!

  5. #5
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712

    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
  •  


Click Here to Expand Forum to Full Width