Skip to main content
A
aganeshappa11-Visitor
1-Visitor
July 6, 2016
Question

Connecting to oracle database

  • July 6, 2016
  • 2 replies
  • 3615 views

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..


2 replies

T
ttielebein5-Regular Member
5-Regular Member
July 6, 2016

Hello,

I believe if you follow this documentation from KCS, you will have greater success connecting.

Hope this helps!

Tori

A
aganeshappa11-VisitorAuthor
1-Visitor
July 7, 2016

Thanks a lot for the reference documentation. I could connect to the database now.

Appreciate your help.

A
Aanjan5-Regular Member
5-Regular Member
July 7, 2016

Ashok, do you get a specific error message? Have you tried setting the connectionValidationString to SELECT SYSDATE from DUAL?

    A
    aganeshappa11-VisitorAuthor
    1-Visitor
    July 7, 2016

    Thanks Aaanjan. The issue is resolve now.

    Terms & ConditionsAccessibility statement