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,
Your JDBC URL is not in correct form:
Please try like following instead:
View solution in original post