Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Oracle DB- Putdatabase record processor connection issue

avatar
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

avatar
Master 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

avatar
Master 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