Problem connecting to pgsql database from NB

Hi everybody :)

Its my first time writing to the mailing list, firstly I would like to thank u all for all the support u provide us it has been fundamental in each step I give while developing my project.

Im new to all of this, its my first time working with Net Beans and PostgreSQL but Im willing to learn it all :)

Im developing a simple web app using NB 5.5.1 and through a servlet Im calling a class which accesses a pgsql database v8.2.4 and Im getting the following:

RAR5099 : Wrong class name or classpath for Datasource Object : {0}
java.lang.ClassNotFoundException: org.postgresql.ds.PGSimpleDataSource
        at org.apache.catalina.loader.WebappClassLoader.loadClass (WebappClassLoader.java:1511)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1292)
        at com.sun.gjc.common.DataSourceObjectBuilder.getDataSourceObject(DataSourceObjectBuilder.java :216)
        at com.sun.gjc.common.DataSourceObjectBuilder.constructDataSourceObject(DataSourceObjectBuilder.java:83)
        at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java :83)
        at com.sun.enterprise.resource.LocalTxConnectorAllocator.createResource(LocalTxConnectorAllocator.java:56)
        at com.sun.enterprise.resource.AbstractResourcePool.createResourceAndAddToPool(AbstractResourcePool.java :1263)
        at com.sun.enterprise.resource.AbstractResourcePool.createResources(AbstractResourcePool.java:596)
        at com.sun.enterprise.resource.AbstractResourcePool.initPool(AbstractResourcePool.java:186)
        at com.sun.enterprise.resource.AbstractResourcePool.internalGetResource(AbstractResourcePool.java:362)
        at com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:289)
        at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:248)
        at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:174)
        at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection (ConnectionManagerImpl.java:312)
        at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:222)
        at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection (ConnectionManagerImpl.java:152)
        at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:145)
        at com.sun.gjc.spi.DataSource.getConnection(DataSource.java:93)
        at org.AccessClientInfo.getClientInfo(AccessClientInfo.java:53)
        at org.ClientInfo.doGet(ClientInfo.java:33)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service (HttpServlet.java:820)
        at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java :278)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
        at org.apache.catalina.core.StandardContextValve.invokeInternal (StandardContextValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
        at org.apache.catalina.core.StandardPipeline.doInvoke (StandardPipeline.java:566)
        at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
        at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:536)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter (ProcessorTask.java:667)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java :844)
        at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
        at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
        at com.sun.enterprise.web.connector.grizzly.TaskBase.run (TaskBase.java:252)
        at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
RAR5038:Unexpected exception while creating resource
RAR5117 : Failed to obtain/create connection. Reason : Class name is wrong or classpath is not set for : org.postgresql.ds.PGSimpleDataSource
RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : org.postgresql.ds.PGSimpleDataSource]
java.sql.SQLException : Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : org.postgresql.ds.PGSimpleDataSource
StandardWrapperValve[ClientInfo]: Servlet.service() for servlet ClientInfo threw exception
java.lang.NullPointerException
        at org.ClientInfo.doGet(ClientInfo.java:38)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java :820)
        at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
        at org.apache.catalina.core.StandardContextValve.invokeInternal (StandardContextValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
        at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
        at org.apache.catalina.core.StandardPipeline.doInvoke (StandardPipeline.java:566)
        at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
        at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
        at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:536)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter (ProcessorTask.java:667)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
        at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java :844)
        at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
        at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
        at com.sun.enterprise.web.connector.grizzly.TaskBase.run (TaskBase.java:252)
        at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)



Im using Linux, I've already copied "postgresql-8.2-506.jdbc3.jar" driver to "/opt/SUNWappserver/domain/domain1/lib/ext" and also followed tutorials to create connection pools on Net Beans, but yet not working.

Here is part of my code:

public class AccessClientInfo
{
  private String client_id;
  private Client client;   

 
  public AccessClientInfo(String client_id)
  {
    this.client_id=client_id ;
  }
 
  private DataSource getJdbcConnectionPool() throws NamingException
  {
    Context c = new InitialContext();
   
    return (DataSource) c.lookup("java:comp/env/jdbc/connectionPool");
  }

  public Client getClientInfo()
  {
    Connection connection=null; //connection instance

    Client client=null; //instance of Client used to retain retrieved data
  
    try
    {
      //connect to database
      DataSource dataSource=getJdbcConnectionPool();
      connection=dataSource.getConnection();
     
      //prepare the SQL query
      String query="SELECT cname,address,phone,fax FROM ClientsInfo WHERE cid="+client_id;
      PreparedStatement stat=connection.prepareStatement(query);

      //set up the result set to retain all queried data
      ResultSet rs=stat.executeQuery();
     
      if(!(rs.next()))
        return null;
     
      String cname=rs.getString(1);
      String address=rs.getString(2);
      String phone=rs.getString(3);
      String fax=rs.getString(4);
       
      //declare an instance of SubjectName to match returned data with class' instance variables
      client=new Client(cname, address, phone, fax);
     
      connection.close();
    }
    catch(Exception err)
    {
      System.out.println(err.toString());
    }

    return client;
  }

I would appreciate if u could save me once again. And sorry for this long email :)



--
Flavio Monteiro