Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No suitable driver problem

 
seema prakash
Ranch Hand
Posts: 59
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, This is my first servlet program. I wanted to try to
connect to oracle database. I have tomcat5.5.9 , JDK1.4,
oracle9i installed. I have copied the ojdbc14.jar file in
the common/lib folder. But I get the error as
SQLException: No suitable driver SQLState: 08001 VendorError: 0
I'm not sure why this occurs. I have learnt that ojdbc14
has the appropriate oracle driver. Please help.
The servlet code is as follows

 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Acording to this, if the driver fails to load, the exception will be reported but the code will continue to run. One problem may be failing to load the Class which then reports 'not suitable driver' when you go looking for it.
 
seema prakash
Ranch Hand
Posts: 59
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi David O'Meara,
Thanks for the reply. But, that part of the code is executed, since I get the "Class found" statement on the browser.
 
seema prakash
Ranch Hand
Posts: 59
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I got it working. It was the problem with the double quotes for url ...
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oh of course
Nice catch, thanks for reporting back.

Dave
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic