Tuesday, February 25, 2014

JDBC My Obsevation

MY NOTES::::


How to know tns name, local host name?

ANS: In installed oracle folder, \server\network\ADMIN\tnsnames.ora

We Have HOST :Naresh , localhost
                Port: 1521
Service Name: XE,  or ORCL

JDBC Connections code:
Class Name: sun.jdbc.odbc.JdbcOdbcDriver
                     oracle.jdbc.driver.OracleDriver
Url : jdbc:odbc:testDataSource
       jdbc:oracle:thin:@localhost:1521:XE




No comments :

Post a Comment