Connectivity of postgreSQL database to a JSP page

I tried executing a jsp file which gets the connection
to the postgresql to test if the driver is working.It
connects to the Driver but while reterieving the
information from the database it shows the jframe and
give gives the following exception :

init:
deps-jar:
Compiling 1 source file to
/home/cipa/sun/frame1/build/classes
compile-single:
run-single:
SQL Exception
java.sql.SQLException: No suitable driver

Plz solve out this problem and send suggesstions on
my email id : sun2walsunil(at)yahoo(dot)co(dot)in(dot)

________________________________________________________________________
Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony

Hi,

We need more information to solve this puzzle. However, you can be
guaranteed
that the driver works as many people are successfully using it in servlets.

Have you checked the documentation at jdbc.postgresql.org ?

at a minimum we need the url, and the snippet of code.

Dave

sunil sunsunwal wrote:

>I tried executing a jsp file which gets the connection
>to the postgresql to test if the driver is working.It
>connects to the Driver but while reterieving the
>information from the database it shows the jframe and
>give gives the following exception :
>
>
>
>
>init:
>deps-jar:
>Compiling 1 source file to
>/home/cipa/sun/frame1/build/classes
>compile-single:
>run-single:
>SQL Exception
>java.sql.SQLException: No suitable driver
>
>
>
>Plz solve out this problem and send suggesstions on
>my email id : sun2walsunil(at)yahoo(dot)co(dot)in(dot)
>
>
>________________________________________________________________________
>Yahoo! India Matrimony: Find your life partner online
>Go to: http://yahoo.shaadi.com/india-matrimony
>
>---------------------------(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)
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561

2005/5/4, sunil sunsunwal <sun2walsunil(at)yahoo(dot)co(dot)in>:
> I tried executing a jsp file which gets the connection
> to the postgresql to test if the driver is working.It
> connects to the Driver but while reterieving the
> information from the database it shows the jframe and
> give gives the following exception :
>
> init:
> deps-jar:
> Compiling 1 source file to
> /home/cipa/sun/frame1/build/classes
> compile-single:
> run-single:
> SQL Exception
> java.sql.SQLException: No suitable driver
Hello:

The driver postgresql-8.0-311.jdbc3.jar must be located in /tomcat/common/lib/
this can be downloaded from:
http://jdbc.postgresql.org/download/postgresql-8.0-311.jdbc3.jar for
postgresql 8.X

More info here:
http://developer.apple.com/internet/opensource/postgres.html

Bye.

--
Nahum Castro González
León, Guanajuato, México