How to Make JDBC Connection to Oracle 11g Release 2

By April 15, 2011 at 12:29 am · How To

Oracle 11g Release 2 of the JDBC connection seems to be different, if you receive the following exception: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor. Then you must use the following connections:

email

DeeKay has been working in Java, JEE and opensource technology since 7 years and has same years of experience in software development. His area of interest is TDD, Scala langauge, Java, JEE techologies.

Related Posts

Popular Posts

  • madhu

    “jdbc: odbc: thin: @ HOSTNAME: PORTNUMBER / SID”;

    We can replace this statement with the best suitable sting as

    “jdbc: odbc: thin: //@ localhost:1521 / XE”;

    this will work for oracle 11g xe in a best way. the default SID for oracle 11g express edition is: XE.

    If not you can see the SID at your system service.

    open services in your computer, select OracleServiceXE . right click, select properties,

    in general tab look for “path to executable”. it will show you as…

    “c:oraclexeapporacleproduct11.2.0serverbinORACLE.EXE XE” the last word in this line is your SID.