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