NullPointerException

[Satyajeet Kadam]

When i execute this query by giving email explicity it executes fine but from application i receive Null poibter exception
please help

   
 System.out.println("Before Query");
rs=admin.executeQuery("select ref_company_id from ts_user"
+"where ts_user.email='"+ email +"'"); 
 

  
Before Query
java.lang.NullPointerException

[Paul Sturrock]

Whatever admin is must be null.

[Satyajeet Kadam]

thanks for your reply, i have already done that
see my entire code,

my entire code

   
 
public void createAdmin(AdminActionForm createActionForm,String email1)
{
Connection con=null;

String emailid=email1;
System.out.println("From Create Admin EMail if of CEO=="+emailid);

Statement cadmin=null;
PreparedStatement stmtad = null,stmtCom = null;
[B]Statement admin=null;[/B]
int countCompany=0;
ResultSet rscout,rs=null;



 try
{
con=ds.getConnection();
cadmin=con.createStatement();
/*
 * saving admin details
 *
 * */
 System.out.println("Before Query");
 [B]//st.executeQuery("select email from ts_companyinfo where email='"+emailid+"'");
 // rs=admin.executeQuery("select ref_company_id from ts_user where ts_user.email='"+ emailid +"'"); 
 rs=admin.executeQuery("select ref_company_id from ts_user where ts_user.email=emailid");[/B]
while(rs.next())
  {
  System.out.println("satya"+rs.getInt("ref_company_id"));
  }
  
  
  
 stmtCom=con.prepareStatement(AdminConstants.SEL_COUNT_REGISERED_TSADMIN);
 rscout= stmtCom.executeQuery();
 rscout.next();
 countCompany=rscout.getInt("user_count");
 System.out.println("countCompany=="+countCompany);
 stmtad.setString(1,createActionForm.getTsadmName());
 stmtad.setString(2,createActionForm.getTsadmEmailid());
 stmtad.setInt(3,countCompany+1);
 stmtad.setString(4,createActionForm.getTsadmPassword());
 stmtad.executeUpdate();
 }
catch(Exception e)
{
e.printStackTrace();

}
finally
{


}


}


}


 

console

  
email of CEO =[e-mail]
From Create Admin EMail if of CEO==[e-mail]
[B]Before Query
java.lang.NullPointerException[/B]        at com.sipl.siixt.ts.admin.AdminManager.createAdmin(AdminManager.java:66
)
        at com.sipl.siixt.ts.admin.AdminAction.execute(AdminAction.java:61)
        at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:419)
  

[Paul Sturrock]

Whatever you are doing on line 66 of AdminManager must be refering to a null object. I can't say for sure - since I don't know what is happening on that line - but my guess is you have not assigned a value to admin. Looking though your code this does seem to be the case. You seem to have a variable called cadmin which you use to refer to a Statement instance. I don't see anywhere that you do the same for your variable admin.