----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hi,
Finally managed to get over the problem , here goes the solution in brief:
1. I edited jserv.properties as "root" and added one more line to it "
wrapper.classpath=_location of my jdbc.jar files_".
That's it & it started working- thanks for the clue folks!
bye
Anshu.
--- Anshu <[EMAIL PROTECTED]>
> wrote:
>----------------------------------------------------------------
>BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
>WHEN YOU POST, include all relevant version numbers, log files,
>and configuration files. Don't make us guess your problem!!!
>----------------------------------------------------------------
>
>Hi,
>
>I am using RH Linux 6.2 with following:
>Apache/1.3.12 (Unix)
> ApacheJServ/1.1.1
> postgresql 6.5.3-6
>
>My problem is that the code given in heading A works but when I try to use it in a
>servlet ( heading B) it fails to make connection to database.
>
>"Case A -works "
>import java.sql.*;
>public class data{
> public data(){
> String url="jdbc:postgresql://localhost:5432/pan01";
> try{
> Class.forName("postgresql.Driver");
> Connection c= DriverManager.getConnection(url,"yyyyyy","xxxxxxx");
> }catch (Exception e)
> {System.out.println(e.getMessage());}
> }
>
> public static void main(String args[]){
> data dat=new data();
> }
>}
>
>"Case B -does not work"
>import java.io.*;
>import javax.servlet.*;
>import javax.servlet.http.*;
>import java.sql.*;
>public class sample extends HttpServlet{
> public void doGet(HttpServletRequest req,HttpServletResponse res)throws
>ServletException, IOException{
> try {
> res.setContentType("text/html");
> PrintWriter out = res.getWriter();
> Class.forName("postgresql.Driver");
> String url = "jdbc:postgresql://localhost:5432/pan01";
>Connection con=
>DriverManager.getConnection(url,"yyyyyy","xxxxxxx");
> }catch (Exception e){
> res.setContentType("text/html");
> PrintWriter out = res.getWriter();
> out.println("This is not working ");
> }
> }
>}
>
>If you have any idea why is it happening please let me know.
>Thanks!
>Anshu
>
>_____________________________________________________________
>TheFreeSite.com: Home of the Web's best freebies.
>http://www.thefreesite.com
>
>
>--
>--------------------------------------------------------------
>Please read the FAQ! <http://java.apache.org/faq/>
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Search Archives:
><http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
>Problems?: [EMAIL PROTECTED]
_____________________________________________________________
TheFreeSite.com: Home of the Web's best freebies.
http://www.thefreesite.com
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
