File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Websphere studio Can't find the jdbc driver! Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JSP
Reply Bookmark "Websphere studio Can Watch "Websphere studio Can New topic
Author

Websphere studio Can't find the jdbc driver!

Yashnoo lyo
Ranch Hand

Joined: Feb 17, 2003
Posts: 152
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)


When I face C# and Java I choose Java.
Jeff Grant
Ranch Hand

Joined: Dec 19, 2001
Posts: 169
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

Joined: Feb 17, 2003
Posts: 152
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

Joined: Jan 08, 2001
Posts: 2164
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

Joined: Feb 17, 2003
Posts: 152
Thank you Axel!
I successful! You are right!Thank you very much!
 
IntelliJ Java IDE
 
subject: Websphere studio Can't find the jdbc driver!
 
Threads others viewed
Hope Mr Parthasarathy madhira or other friend help me to solve this problem
jdbc connection to ms sql (urgent)
URLCLassLoader
java.lang.ClassCastException error
Prolems connecting to the Oracle database
developer file tools