• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No suitable driver found for jdbc:oracle

 
Ilo Nato
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi. Trying to make connection between Oracle db (Oracle 10g express) and java. But so far no good results.
i am getting this error. No suitable driver found for jdbcracle....

It is like this when you click button it fills the table with data (doing it for only test.)

Here is the code


I think the problem is DB name but i am not sure.
I just made the tables in Oracle. i couldnt see any Database name or like...

Any help is appreciated.
regards
 
amit punekar
Ranch Hand
Posts: 544
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Uncomment the "Class.forName" line.
This would load the JDBC driver if it is appropriately put in the CLASSPATH.

Regards
amit
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
amit punekar wrote:Hi,
Uncomment the "Class.forName" line.
This would load the JDBC driver if it is appropriately put in the CLASSPATH.

Regards
amit


Plus



you should specify the SID after port.

But the problem is actually driver manager can not find oracle driver.
 
Ilo Nato
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It works now.
I had to add ojdbc14.jar to library of the project.
And have the Class.forName("oracle.jdbc.driver.OracleDriver"); in try and catch.

Thanks all..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic