• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connectivity in WSAD

 
trivikram Kumar
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • 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,
 
Alex Prawira
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Would you show us the code ?

Thanks
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34656
366
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic