• Post Reply Bookmark Topic Watch Topic
  • New Topic

Websphere studio Can't find the jdbc driver!

 
Yashnoo lyo
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
  • 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)
 
Jeff Grant
Ranch Hand
Posts: 169
  • Mark post as helpful
  • send pies
  • 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
  • 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:
 
Axel Janssen
Ranch Hand
Posts: 2166
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Thank you Axel!
I successful! You are right!Thank you very much!
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!