my database connection class looks like

package com.c2rmnet.struts.database;

import org.apache.struts.action.Action;
import javax.servlet.http.HttpServletRequest;

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import javax.sql.DataSource;
import java.sql.ResultSet;



/**
 * @author [EMAIL PROTECTED]
 * 
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class DBConnection extends Action{
        ResultSet rs=null;
        String dia="";
        //HttpServletRequest request;
        public DBConnection(){}
        
        public DBConnection(HttpServletRequest request,String query){
                dia+=" inside DBConnection constructor ==>";
                                DataSource dataSource;
                                 Connection myConnection=null;
                                  Statement stmt=null;
                                  dia+="going to connection block==>";
        try{
              dia+=" getting datasource ==>";
               dataSource=getDataSource(request);
               dia+="getting connection==>";
                myConnection = dataSource.getConnection();
                dia+="preparing statement==>";
                stmt=myConnection.createStatement();
                dia+="getting result set==>";
                rs=stmt.executeQuery(query);
                }
        catch (Exception e){dia+=e.toString();}
        
        finally{
                try
                {
                        myConnection.close();}catch (Exception e)
                        {dia+=e.toString();}
                }
        }
        
        //public DBConnection(HttpServletRequest req){this.request=req;}
        
        public String getErrorStatus(){return(dia);}
        public ResultSet getResultSet(){return(rs);}

}


and i am calling the class in loginAaction.java like

 try{
 
  DBConnection db=new DBConnection(request,"Select * from company");
  company=db.getErrorStatus();
 }catch(Exception e){company+=e.toString();}


and i am getting an error when the dbconnection class tries on getting the datasource

The error string im getting looks like
   inside DBConnection constructor ==>going to connection block==> getting datasource 
==>java.lang.NullPointerException


    
   can you tell any solution
Thanking u,
  vineesh

Reply via email to