How to solve NullpointerException

[saravanan rajendran]

hi, i hardly trying this using fileInputStream retrieve a xls file from particular directory like /var/www/html/sara/book1.xls i getting nullpointer exception

problem:

conn = DriverManager.getConnection("jdbc dbc river={Microsoft Excel Driver ( *.xls)};DBQ=" + dis);//file name i given has dis this only giving nullpointer exception please see my below code you will get full flow


please see below code:

 
File file = new File("/var/www/html/sara/book1.xls");
out.println(file);
    FileInputStream fis = null;
    BufferedInputStream bis = null;
    DataInputStream dis = null;
   out.println("welcome1");
 
    try {
out.println("welcome1231");
      fis = new FileInputStream(file);

      // Here BufferedInputStream is added for fast reading.
      bis = new BufferedInputStream(fis);

      dis = new DataInputStream(bis);

      // dis.available() returns 0 if the file does not have more lines.

      while (dis.available() != 0) {

      // this statement reads the line from the file and print it to
        // the console.
       //System.out.println(dis.readLine());


 
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

conn = DriverManager.getConnection("jdbc  :-o	  dbc  :mrgreen:  river={Microsoft Excel Driver ( *.xls)};DBQ=" + dis);//for filename i given dis getting nullpointer exception 
 
st = conn.createStatement();
String query = "Select * from [Sheet1$]" ;
rs = st.executeQuery( query );
while( rs.next() )
{
 String name=rs.getString(1);
 String loc=rs.getString(2);
try
{

Class.forName
("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "meetme", "meetme");
st = conn.createStatement();
st.executeUpdate("Insert INTO sample1(`name` , `location`)VALUES('"+ name +"' ,'"+ loc +"')");
rs1=st.executeQuery("select * from sample1");
if(rs1.next())
{
out.println(name);
}
}
catch(Exception e)
{
out.println(e);
}
}//while
}//try
catch( Exception e )
{
out.println(e);
}
}//while close
// dispose all the resources after using them.
      fis.close();
      bis.close();
      dis.close();
}//try close
catch( Exception e )
{
out.println(e);
}

I am very thank full if you solved that problem please help me

JCE: Please use code tags in the future
[ August 07, 2008: Message edited by: Joe Ess ]