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 command line - 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 appreciate some 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 psql commands & 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(at)postgresql(dot)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