java.sql.SQLException: Invalid Oracle URL specified

Question

I am getting java.sql.SQLException: Invalid Oracle URL specified error when running my java application from eclipse. I am using Oracle version 10. classes12.jar is used for the oracle driver oracle.jdbc.OracleDriver Please help me resolving this issue

Solution

You appear to be missing a colon; as per the JDBC API reference and developer's guide, the syntax is:

jdbc:oracle:driver_type:[username/password]@database_specifier

So yours should be:

jdbc:oracle:oci8:@cssm