Thread: servlets and JDBC (postgresql 7.2)

servlets and JDBC (postgresql 7.2)

From
Frederick Klauschen
Date:
I would like to establish a postgresql database
connection from within a Java Servlet, using
the Apache Tomcat server.
Unfortunately, I get the error: "No suitable driver
found"
When trying to connect a Java application to the
same database (same settings (same classpath)),
everything works fine.
Is there something special about JDBC and servlets,
that might have caused this error?

Thanks,
Frederick



__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



Re: servlets and JDBC (postgresql 7.2)

From
Nookala Satish Kumar
Date:
Hi Frederick,

Copy the postgresql JDBC driver "postgresql.jar" file
to the TOMCAT-HOME/common/lib directory. Restart your
tomcat server. That's it.

Regards,
Satish.

--- Frederick Klauschen <fklauschen@yahoo.com> wrote:
> I would like to establish a postgresql database
> connection from within a Java Servlet, using
> the Apache Tomcat server.
> Unfortunately, I get the error: "No suitable driver
> found"
> When trying to connect a Java application to the
> same database (same settings (same classpath)),
> everything works fine.
> Is there something special about JDBC and servlets,
> that might have caused this error?
>
> Thanks,
> Frederick
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
>


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



Re: servlets and JDBC (postgresql 7.2)

From
Vernon Wu
Date:
I have the same setting here: pgSQL and Tomcat 4.0.x without any problem. You might want to check your setting and
version of PostgreSQL and its JDBC. I can't help without detailed information?

6/23/2002 12:32:33 PM, Frederick Klauschen <fklauschen@yahoo.com> wrote:

>I would like to establish a postgresql database
>connection from within a Java Servlet, using
>the Apache Tomcat server.
>Unfortunately, I get the error: "No suitable driver
>found"
>When trying to connect a Java application to the
>same database (same settings (same classpath)),
>everything works fine.
>Is there something special about JDBC and servlets,
>that might have caused this error?
>
>Thanks,
>Frederick
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! - Official partner of 2002 FIFA World Cup
>http://fifaworldcup.yahoo.com
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>






Re: servlets and JDBC (postgresql 7.2)

From
John Hicks
Date:
In-Reply-To:
<20020624154045.62155.qmail@web12301.mail.yahoo.com>

Satish--

I have my driver (jdbc7.1-1.2.jar) in TOMCAT-HOME/lib/.
Things seem to be working OK.

Can you tell me what's supposed to be the difference
between common/lib and lib?

Thanks,

--John Hicks



--- Nookala Satish Kumar <javasatish@yahoo.com>wrote:
Hi Frederick,

Copy the postgresql JDBC driver "postgresql.jar" file
to the TOMCAT-HOME/common/lib directory. Restart your
tomcat server. That's it.

Regards,
Satish.

--- Frederick Klauschen <fklauschen@yahoo.com> wrote:
> I would like to establish a postgresql database
> connection from within a Java Servlet, using
> the Apache Tomcat server.
> Unfortunately, I get the error: "No suitable driver
> found"
> When trying to connect a Java application to the
> same database (same settings (same classpath)),
> everything works fine.
> Is there something special about JDBC and servlets,
> that might have caused this error?
>
> Thanks,
> Frederick
>



Re: servlets and JDBC (postgresql 7.2)

From
tony
Date:
On Tue, 2002-06-25 at 08:24, John Hicks wrote:
> In-Reply-To:

> I have my driver (jdbc7.1-1.2.jar) in TOMCAT-HOME/lib/.
> Things seem to be working OK.
>
> Can you tell me what's supposed to be the difference
> between common/lib and lib?

What version of Tomcat are you running? The location changed between 3.x
and 4.0. It will change again between 4.0 and 4.1x ->.

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html




Re: servlets and JDBC (postgresql 7.2)

From
Toby Doig
Date:
> > Can you tell me what's supposed to be the difference
> > between common/lib and lib?

as i understand it, /common/lib is where you stick libraries (jars etc)
that you want your applications (webapps) to be able to make use of. so
anything in this folder should be accessible in your servlets across all
contexts, unlike putting it in the WEB-INF/lib of a particular context
which makes it only available to that context.
the /lib is where you stick stuff yto make it available to the tomcat
server itself, but unless you're developing tomcat then i doubt you'd need
this. however, the reason this works is because since its available to
tomcat its available to your contexts as well. its a hierarchy.

i must confestt that i do the same as you, i stick stuff in /lib since
i've experienced wierdness putting it in common/lib.

toby




Re: servlets and JDBC (postgresql 7.2)

From
Rainer Klute
Date:
>I have my driver (jdbc7.1-1.2.jar) in TOMCAT-HOME/lib/.
>Things seem to be working OK.
>
>Can you tell me what's supposed to be the difference
>between common/lib and lib?

The latter is in applications' classpath, the former is *also* in
Tomcat's classpath. You will need this if you want to use PostgreSQL
for user authentication via the JDBCRealm.

Best regards
Rainer Klute

                           Rainer Klute IT-Consulting GmbH
  Dipl.-Inform.
  Rainer Klute             E-Mail:  klute@rainer-klute.de
  Körner Grund 24          Telefon: +49 172 2324824
D-44143 Dortmund           Telefax: +49 231 5349423