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
