No suitable driver found for jdbc:oracle:thin:@localhost:1521:Indu

[indu yeturu]

hello all,

am getting this error when am trying to connect to database with connection.properties file

Driver = oracle.jdbc.driver.OracleDriver
URL = jdbc:oracle:thin:@localhost:1521:Indu
username = scott
pw = indu    

but it works perfectly if am not using properties file in class ...

               Class.forName("oracle.jdbc.driver.OracleDriver");
			   con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:Indu","scott","indu");   

class12.jar is there in classpath.
why the difference is coming, and please help me in solving this !

[Smitesh Shinde]

Hi Indu,
Seems to be problem with reading of properties file.

[indu yeturu]

 
                Locale loc = Locale.getDefault();
		ResourceBundle bundle = ResourceBundle.getBundle("config.DB_connection",loc);
                        String url = bundle.getString("URL");
			String user = bundle.getString("username");
			String pw = bundle.getString("pw");
                        con = DriverManager.getConnection(url,user,pw);

   

here, it is connecting to properties file i think... is there any error?

[Jan Cumps]

Print out all of the values of the info you get from the property file to check.

System.out.println(url);
System.out.println(user);
System.out.println(pw);

Does it show what you expect?

(not shure: Can you have spaces between property and equal sign, or between equal sign and value?)

[indu yeturu]

i have printed all the values, which are same as in javaclass. and I removed the spaces between the = sign and the value , but still getting the same exception

[Jan Cumps]

I don't see "Class.forName(...);" in your property file example.

[indu yeturu]

oh! thank you somuch . I forgot to include class.forName(...) in jsp's and servlets.... now, it is working fine..

     String driver = bundle.getString("Driver");
				Class.forName(driver);    

just , have a look on this, and correct me if my way is wrong ...
is this the correct way to write connection details property file ??

my properties file is ::

Driver=oracle.jdbc.driver.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521:Indu
username=scott
pw=indu