4 Replies Latest reply on Jul 7, 2016 4:13 PM by aganeshappa RSS
    aganeshappa Newbie

    Connecting to oracle database

    Hi All,

     

    I want to connect to oracle 10g database and am using the below connection string and driver class name, I know i am missing something here. Can you please advise me on this.

     

    JDBC Driver Class Name- oracle.jdbc.driver.OracleDriver

    JDBC Connection String - jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LENOVOUSER.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))

    connectionValidationString- SELECT NOW()


    Thanks for the help..