[news.eclipse.newcomer] Re: Question about setting up access and using a

[IchBin <weconsul@xxxxxxx>]

KDsCalling wrote:
> I have a feeling I have missed something pretty important.  Do I need to 
> have apache and tomcat installed and running before I install eclipse?
> I have attempted to use NitroX's DBXplore plugin to view my database. 
> The error is "driver class com.inet.tds.TdsDriver not available to the 
> class loader".  Then I attempted to use the database explorer that is 
> part of the eclipse ide.  I received the same message.
>
> So here is where I am trying to go.  I would like to create a JSP that 
> can access a database to fill one of it's fields.  Is that possilbe to 
> do inside of the IDE for testing purposes or do I need to just create it 
> in the IDE and then move it into a externally running Tomcat?
>
> And by the way, is there a 'how to set up and use eclipse for dummies' 
> paper floating around the internet someplace?
>
> Thank you,
> Katherine
>
> IchBin wrote:
> > KDsCalling wrote:
> >
> > > Good Afternoon,
> > >
> > >     I have been working with eclipse for about 2 weeks.  I have spent 
> > > the last 3 days trying to set up access to our database to use to 
> > > populate a jsp page.  Whenever I try to add a database connection it 
> > > gives me an error message saying it cannot find the JDBC driver.  I 
> > > think the zip file containing the driver is not in the correct 
> > > place.  Can anyone help?  Does it need to be under the eclipse 
> > > directory?  Where?
> > >
> > > Thank you,
> > > Katherine
> > Not sure what server you are using.. Tomcat? For Tomcat move the jar 
> > file to 'Tomcat\common\lib'
> >
> > For Eclipse just open properties for the project and select 'Java 
> > Build Path' and add you jar file there.

As far as using the Eclipse Database explorer you may want to look at 
this tutorial
http://www.eclipse.org/webtools/community/tutorials/RDBTutorial/RDBTutorial.html

I do not use it nor NitroX's DBXplore. I use the plugin SQLExplorer from 
http://sourceforge.net/projects/eclipsesql

No matter what, naturally you have to specify the location and jar file 
that contains your JDBC class driver when you configure any database 
plugin.

As for Tomcat you may want to look at Eclipses wtp project 
http://www.eclipse.org/webtools/

or another plugin just for Tomcat at 
http://www.sysdeo.com/eclipse/tomcatplugin

--


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA 
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor,  Regular Guy (1952-)