NewB: Servlet/cmd:Classpath confusion

(Thread Was: Howto tell if jdbc is compiled-in?)


Thanks Peter...

My setup is RH7.0 - Apache1.3.20 - Tomcat4.0.1 - PostgreSQL 7.1

I tested some basic sample servlets and they're working ok however when I try to run Nick's example code from the
commandline - I get the 'NoClassDefFoundError' (which apparantly points to problems with the jdbc .jar not in the
classpath). Nevertheless, even when I run the command line argument to specify the classpath, I get the same error. 

Nick mentions problems of this kind for users running Tomcat - as I don't understand what's causing the problem, I'd
appreciatesome further explanation if possible.  This is just for my own understanding - as the setup as is, is working
ok.

Secondly, I'm new to databases - postgreSQL is my first experience in this field, and I think I need a 'cheatsheet' on
psqlcommands & syntax for beginners (such as SELECT TABLE_NAME FROM USER_TABLES; - not sure if that actually works)
etc. Can anyone suggest any links or further reading on this? 

Again Many thanks
/j-p.



On Tue, 12 Feb 2002, Peter V. Cooper wrote:

> JP, I am running Linux RH 7.2, Apache (came with RH7.2 - don't know the
> number), Tomcat 3.2.3
> and postgresql 7.2. All seems to be working fine. I have not stress tested
> it yet or put it in
> a live site. A beta site is next. Can't vouch for anything above 3.2.3 on
> Tomcat as I had problems
> with 3.2.4 and backed it down a level. Others on this list have mentioned
> Tomcat 4.X. Chime up.
> I still know of a site that has problems with a persistent connection to
> the database over a wan
> timing out but have been unable to flush out answers here. My config needs
> only the JVM,DB, and JDBC driver on the same machine for now. Lan later and
> Wan even further out. By then I
> should have or program a solution. Good luck - the above config seems to
> work fine.
>
> At 03:03 PM 2/12/2002 -0100, john-paul delaney wrote:
>
> >Thanks Nick... I had already bookmarked the site to try out your test
> >code, once I have all components installed.
> >
> >BTW, I'm interested in java servlets running under Apache Tomcat, using
> >postgreSQL as the back-end store.  Can anyone recommend any sites that
> >discuss this combination?
> >
> >regards
> >/j-p.
> >
> >
> >On Tue, 12 Feb 2002, Nick Fankhauser wrote:
> >
> > > As the other folks mentioned, you only need to obtain the .jar file &
> > put it
> > > in your classpath to support jdbc. All the "with jdbc" switch does for you
> > > is to build this file. So- it's easiest to just download the file from
> > > http://jdbc.postgresql.org/download.html. If you're just starting, you may
> > > find this web page useful:
> > >
> > > www.fankhausers.com/postgresql/jdbc
> > >
> > > -Nick
> > >
> >
> >
> >-----------------------
> >  JUSTATEST Art Online
> >   www.justatest.com
> >
> >
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>


-----------------------
 JUSTATEST Art Online
  www.justatest.com