Re: POSTGRES JBDC PROBLEM - Mailing list pgsql-jdbc

From Bjørn T Johansen
Subject Re: POSTGRES JBDC PROBLEM
Date
Msg-id 42073E8A.1060004@havleik.no
Whole thread Raw
In response to Re: POSTGRES JBDC PROBLEM  ("Iain" <iain@mst.co.jp>)
List pgsql-jdbc
Or you could just place the jar file under $TOMCAT/common/lib and it should work... >(

BTJ

Iain wrote:
> Hi,
>
> This is stretching my memory as I havn't touched tomcat for a while, but
> I think that you should place the jar file in the tomcat deployment
> directory with all the other jar files and class files that your
> application uses.
>
> In short, tomcat manages it's own class paths - or ateast it does so for
> the applications deployed under it. Placing the jar file in the places
> you did will never work as I understand it.
>
> I hope that makes sense, and morover, I hope it helps,
> regards
> Iain
>
>
> ----- Original Message ----- From: "Chandra Mouli S" <scmouli23@gmail.com>
> To: <pgsql-jdbc@postgresql.org>
> Sent: Monday, February 07, 2005 3:17 PM
> Subject: [JDBC] POSTGRES JBDC PROBLEM
>
>
>> Hi,
>> SUB: Problem in JDBC with POSTGRESQL
>>
>> I have installed POSTGRESQL 8.0 beta on my WINDOWS XP SP2.
>>
>> It is perfectly working and I had created a database 'Student' with
>> table 'Details'
>>
>> The server is configured on PORT NO: 5432.
>>
>> I had unblocked the port no in IN-BUILT FIREWALL, to receive all
>> requests.
>>
>>
>>
>> This is my Servlet program:
>>
>> *******************************************************
>>
>>
>> import javax.servlet.*;
>> import javax.servlet.http.*;
>> import java.io.*;
>> import java.sql.*;
>>
>> public class Stud extends HttpServlet {
>>
>> public void doPost(HttpServletRequest req, HttpServletResponse res)
>> throws
>>
>> ServletException,IOException {
>>
>> try {
>>
>> int rNo=Integer.parseInt(req.getParameter("RegNo"));
>> String Qry="select * from details where RNo=" + rNo;
>> Connection con=null;
>> Statement st=null;
>> ResultSet rs=null;
>>
>> res.setContentType("text/html");
>>     PrintWriter pw =res.getWriter();
>>
>>
>> pw.println("<html>");
>>     pw.println("<body>");
>> pw.println("hellO");
>>
>> try
>> {
>> pw.println("STEP 1 ");
>>      Class.forName("org.postgresql.Driver");
>>
>> } catch(ClassNotFoundException cnfe)
>> {
>> pw.println("Exception CLASS NOT FOUND");
>> System.err.println("Count not find the Driver class");
>> cnfe.printStackTrace();
>> }
>>
>>
>>
>> con=DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/Student","scott",
>>
>> "tiger");
>>  st=con.createStatement();
>>  rs=st.executeQuery(Qry);
>> rs.next();
>> int No=Integer.parseInt(rs.getString(1));
>> String Name=rs.getString(2);
>>
>>     pw.println(No);
>> pw.println(Name);
>>
>> pw.println("</body>");
>>     pw.println("</html>");
>> con.close();
>> st.close();
>> }
>> catch(Exception e) {
>> PrintWriter pw =res.getWriter();
>> pw.println(e);
>> }
>>
>>
>> }
>> }
>> ******************************************************************************************
>>
>>
>>
>> I had downloaded the latest postgresql driver
>> 'postgresql-8.0-310.jdbc3.jar ' from postgres.org
>>
>>
>> I had tried all these:
>>
>> 1) set the classpath to this particular jar file.
>>
>> 2) located the javahome directory thro
>> HKEY_LOCAL_MACHINE/SOFTWARE/JavaSoft/Java
>> Runtime Environment/*/JavaHome entry in registry  and placed my jdbc
>> jar file in that directory.
>>
>> ie c:\jre1.5.0_01\lib and \ext
>>
>> 3) placed my jdbc jar file in
>>   c:\jdk1.5.0_01\lib, c:\jdk1.5.0_01\jre\lib and \ext.
>>
>>
>> I my running TOMCAT SERVER 5.0 and when I invoke the servlet after
>> passing the
>> parameter values from a HTML page,
>>
>> the following result in a new page is generated:
>>
>>
>> hellO STEP 1 Exception CLASS NOT FOUND java.sql.SQLException: No
>> suitable driver
>>
>>
>>
>> The JVM is failing to locate the POSTGRESQL driver -  thro the
>>
>> Class.forName("org.postgresql.Driver"); command.
>>
>> The execution is not going beyond this command and hence the problem
>> is strictly with locating
>>
>> and using the POSTGRESQL driver for JDBC.
>>
>>
>> Hence I would like anyone of u to help me getting out of this trouble
>> as soon as possible.
>> I am in a tight project and because of this everything is pending.
>>
>> Please explain me in details all the problem in using JDBC for
>> POSTGRES in a WINDOWS PLATFORM.
>>
>>
>> If possible tell me place to get a correct POSTGRESQL JDBC driver...
>> all sites just point me to
>>
>> the jdbc.postgres.org page.
>>
>>
>>
>> Please help me as soon as possible.
>>
>>
>>
>> Yours truly,
>> Chandra Mouli.S
>> INDIA.
>>
>> scmouli23@gmail.com
>> scmouli23@yahoo.com
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-jdbc by date:

Previous
From: "Iain"
Date:
Subject: Re: POSTGRES JBDC PROBLEM
Next
From: "Kenneth Hutchinson"
Date:
Subject: Crystal Reports / PostgreSQL