Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oracle DB- Putdatabase record processor connection issue

Solved Go to solution
Highlighted

Oracle DB- Putdatabase record processor connection issue

New Contributor

Dear Community,


I am not able to insert data in my oracle database.

I am getting below issue :-

Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:oracle:thin@//hostname:1521/Databasename';

Driver name : oracle.jdbc.driver.OracleDriver

Driver location : /opt/jdbc/ojdbc6.jar

I have also given the user name and password correctly.

May be the url syntax is wrong. I am not able to correct it. COuld you please provide me a pictorial image to get the correct syatnx of the DBCP connection pool for Oracledb

Could you please help me here.

My host name is a remote hostname. and Database name is the schema (owner of the table) in which i am going to insert the data,

Also do i need to mention the service name anywhere here,

Thanks,

Ankit SIngh

7428344123

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Oracle DB- Putdatabase record processor connection issue

Super Mentor

@Ankit Singhal

Your JDBC URL is not in correct form:

jdbc:oracle:thin@//hostname:1521/Databasenae


Please try like following instead:

jdbc:oracle:thin:@hostname:1521:Databasename

View solution in original post

1 REPLY 1
Highlighted

Re: Oracle DB- Putdatabase record processor connection issue

Super Mentor

@Ankit Singhal

Your JDBC URL is not in correct form:

jdbc:oracle:thin@//hostname:1521/Databasenae


Please try like following instead:

jdbc:oracle:thin:@hostname:1521:Databasename

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here