Обсуждение: no suitable driver

hi all..

i'm a beginner at using postgresql, especially in
linux. First of all, i want to ask about the
configuration at the jsp server. I use apache and
jakarta-tomcat-3.2.3.

What should i do first to connect the database at
postgresql to my jsp script using jdbc7.1-1.2.
I already use
 Class.forname(org.postgresql.Driver)
 jdbc:postgresql:databasename
 at my script.

We put the jdbc7.1-1.2.jar at
/usr/java/jdk1.3.1_01/jre/lib/ext/
and we set the classpath at /etc/profile

We put our jsp script at
/jakarta-tomcat-3.2.3/webapps/examples/jsp/

Is that right, i mean the place and the setting of the
file. Because we still have error when we call our
script ..http://127.0.0.1/examples/jsp/...

the msg errors are:

Internal Servlet Error :
javax.servlet.ServletException : No suitable driver
  at org.apache.jasper.runtime.....
  .....

Root Cause :
java.sql.SQLException : No suitable driver
   at
java.sql.DriverManager.getConnection(DriverManager.java:537)....
......

That'all..perhaps anyone can help me to solve the
problem...

Thanks..
vivi



__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

Vivi-

What does the URL that you are passing to Driver.getConnection look like?

This message almost always means that the URL has a problem.

see this link for a longer explanation:

http://www.fankhausers.com/postgresql/jdbc/#nosuitabledriver

regards,

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/



> Root Cause :
> java.sql.SQLException : No suitable driver
>    at
> java.sql.DriverManager.getConnection(DriverManager.java:537)....
> ......