Null pointer exception

[talha06]

Hello to everyone,

I take an annoying exception while taking values from database..

Here's my code, it gives the exception at line 22(I put a sign)..

Thanx in advance..

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import com.mysql.jdbc.Statement;

public class deneme {
	public static void main(String args[]) {
		try{
			String[] adlar = null;
			int indis= 0;
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ogrdb","root", "");
			Statement st = (Statement) con.createStatement();
			String sorgu = "select AdSoyad from ogr";
			ResultSet rs = st.executeQuery(sorgu);
			while(rs.next()) {
				if(rs.getString("AdSoyad") != null) {
		====>	  adlar[indis] = rs.getString("AdSoyad");
				  System.out.println("DB'den cekilen: " + adlar[indis]);
				  indis++;
				}
			}
			rs.close();
			st.close();
			con.close();
		} catch(Exception e) {
			e.printStackTrace();
		}
}
}

[Fubarable]

Do you see anything wrong with this?

String[] adlar = null;
// .... code deleted
adlar[indis] = rs.getString("AdSoyad"); // null pointer exception here

Myself, I'd use perhaps an ArrayList here.

[talha06]

can someone help me to fix this exception? :confused:

[Fubarable]

can someone help me to fix this exception? :confused:

???

I thought that I just did. Again, you are setting a String array to null and then trying to use this array. You shouldn't be surprised that this throws a null pointer exception.

solution: don't try to use a null array. Use an arraylist and be sure to initialize it before trying to use it.

If you need to read up on ArrayLists, then please check out the Sun tutorials.

[talha06]

OK I got it.. Thanx a lot dear 'Fubarable'..

With regards..
Talha

[Fubarable]

You're welcome. Glad you got it to work.