Problem accessing database from servlet

[Anshu]

----------------------------------------------------------------
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]