| 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!
|
 |
 |
|
|
subject: Websphere studio Can't find the jdbc driver!
|
|
|