Thread: Connectivity of postgreSQL database to a JSP page

Connectivity of postgreSQL database to a JSP page

From
sunil sunsunwal
Date:
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@yahoo.co.in.


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

Re: Connectivity of postgreSQL database to a JSP page

From
Dave Cramer
Date:
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@yahoo.co.in.
>
>
>________________________________________________________________________
>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@postgresql.org)
>
>
>
>

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


Re: Connectivity of postgreSQL database to a JSP page

From
Nahum Castro
Date:
2005/5/4, sunil sunsunwal <sun2walsunil@yahoo.co.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