Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
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..
Hello,
I believe if you follow this documentation from KCS, you will have greater success connecting.
Hope this helps!
Tori
Thanks a lot for the reference documentation. I could connect to the database now.
Appreciate your help.
Ashok, do you get a specific error message? Have you tried setting the connectionValidationString to SELECT SYSDATE from DUAL?
Thanks Aaanjan. The issue is resolve now.