• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Websphere studio Can't find the jdbc driver!

 
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When I test my displayoracle.jsp in websphere studio it says can't find the oracle driver!The web page can't display.But I copy the oracle driver:classes.zip to the websphere lib!And How can I setting Websphere to find my Oracle driver?!
Thank you!
/////////////////////////////////////////////////
[No suitable driver]:java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:563)
at java.sql.DriverManager.getConnection(DriverManager.java:194)
at ownbean.gbook.executeQuery(gbook.java:20)
 
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
With Tomcat, you need to copy classes12.jar, not classes12.zip. I have never used Websphere though..
That might be your problem right there. Just search your Oracle directory for classes12.jar, it should be there.
p.s. Don't forget to restart your server after you copy that into the lib folder!
[ February 28, 2003: Message edited by: Jeff Grant ]
 
Yashnoo lyo
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you Jeff:
But I use Websphere as my server and not Tomcat.I already copy the classes.zip to the websphsere lib and set the startserver.bat.Even I can see the classes.zip through the websphere console when I start it!But it Says:[No suitable driver]:java.sql.SQLException: No suitable driver !??? Why?I probably don't set anywhere! :roll:
 
Ranch Hand
Posts: 2166
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
lyo.
1. open serverperspective.
2. There must be an expandable folder, server configuration.
3. Open your server-configuration with double clicking
4. A document with lots of tabs opens in the work-pane. Goto pane datasource.
5. Choose your JDBC provider
6. Choose your Datasource.
7. restart server
 
Yashnoo lyo
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you Axel!
I successful! You are right!Thank you very much!
reply
    Bookmark Topic Watch Topic
  • New Topic