• 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

JDBC connectivity in WSAD

 
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to connect to the database using the sun:jdbc dbc river.
Its giving the Class Not Found Exception error.
I also tried setting the DataSource under server.
I do not find this particular driver there.
Do I need to set it somewhere else???
Could not get the solution.
I am trying to access the database from a servlet.

Thanks,
 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Would you show us the code ?

Thanks
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
By default WSAD uses the IBM JDK, which does not include the optional Sun classes like the JDBC-ODBC bridge. You can either find another driver or configure it to use the Sun JDK.

Dave
 
trivikram Kumar
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for your response.
Yeah..I would post the code.
Could you please tell me how to configure WSAD to use SUN JDK?
In WSAD its working if I write the code in a standalone application and run it as a java application.

Thanks in advance..
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Could you please tell me how to configure WSAD to use SUN JDK?
I no longer use WSAD, but I can tell you how to do it in Eclipse and hopefully it will be similar.

On the Menu, Select Run > Run...
In the window that pops up, select the run target on the left, then the JRE tab on the right. Select 'Alternate JRE'. I'm asusming you have not already added an alternate JRE. If you have, it will be available in the drop-down.

To add a new JRE, select 'Installed JREs', then 'Add'.
Fill in the details for the new JRE. Call it something like SUN 1.4.2 or similar. When you get back to the drop down, select the one you added. If you hit 'Run' on that window the app should now be run using the Sun JDK.

Dave
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
WSAD allows you to substitute the JRE for a program running with a main method. It does not allow you to substitute the JRE running on the server.

What database are you using? Usually the vendor provides a driver that is self contained.
 
I’m tired of walking, and will rest for a minute and grow some wheels. This is the promise of this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic