java.sql.SQLException: Invalid URL: Driver type not specified

[Ashutosh Arya]

Hi I am trying to connect to database using properties file:

   OracleConnectionPoolDataSource oracleconnectionpooldatasource = new OracleConnectionPoolDataSource();
            String hostName = resource.getString("HostName");
            String userName = resource.getString("UserName");
            String password = resource.getString("Password");
            password = Security.EncryptOrDecrypt(password, "Decrypt");
            System.out.println("***userName****"+userName);
            System.out.println("***hostName****"+hostName);
            System.out.println("***password****"+password);
            String sid = resource.getString("SID");
            String port = resource.getString("Port");
            String url = (hostName + ":" + port + ":" + sid);
            oracleconnectionpooldatasource.setURL(url);
            oracleconnectionpooldatasource.setUser(userName);
            oracleconnectionpooldatasource.setPassword(password);
            oCache.setMaxLimit(Integer.parseInt(resource.getString("conMaxSize")));
            oCache.setMinLimit(Integer.parseInt(resource.getString("conMinSize")));
            oCache.setCacheTimeToLiveTimeout(Integer.parseInt(resource.getString("cacheTimeToLiveTimeout")));
            oCache.setThreadWakeUpInterval(Integer.parseInt(resource.getString("threadWakeUpInterval")));
            oCache.setCacheInactivityTimeout(Integer.parseInt(resource.getString("cacheInactivity")));
            oCache.setConnectionPoolDataSource(oracleconnectionpooldatasource);  

But getting java.sql.SQLException: Invalid URL: Driver type not specified error.

Our server is iPlanet 6.

Please guide that what can be the problem?

Thanks in advance

Aashu

[Steven Schwab]

Assuming you are using Oracle, your connection url is incorrect.

Please see http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#05_03 as well as the question below it for how you need to form the connection url.