• 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
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

JDBC CONNECTION PROBLEM with servlets

 
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I set this path in my classpath of system.
C:\oracle\ora92\jdbc\lib\classes12.zip
I am getting this error :
Exception: oracle.jdbc.driver.OracleDriver
Exception: null
How can i set the above path in webshpere.
1) I set that in window->preferences->java->classpath as DB2JAVA = "C:\oracle\ora92\jdbc\lib\classes12.zip". I am getting the same error.
2) In the same location i added new ORCLJAVA variable with same path, no use.
suggest me.
Thanks
Lakshmi
 
Ranch Hand
Posts: 365
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It looks like you are refering to wsad here and its testing environment? What version are you using?
If this is the case, then you must set the run time class path. One way to do this is to put a .jar file in your WEB-INF/lib directory. Since that is not feasible here I will tell you the other way. Since you are using JDBC and the Driver will be reflected at runtime there is no need to set the project build path to include this. However, you do need to set the classpath of the server so that it will recognized the Driver at runtime. Go to the server perspective and make sure the server configuration window is open. If not go to Window-->Show View and open it. Double click on the server/configuration your project is running on and then select the paths tab. Here you can set the classpath to point to your Oracle stuff. Obviously you will need to save and restart.
Hope this helps.
 
Lakshmi siri
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks William,
It worked for me.
-Lakshmi
 
reply
    Bookmark Topic Watch Topic
  • New Topic