Oracle DB- Putdatabase record processor connection issue

[#1]

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

[#2 · Accepted solution]

@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