Solved

NullPointerException ???

Posted on 2004-04-18
4
269 Views
Last Modified: 2010-03-31
Hi.. I keep getting NullPointerException and can't seem to figure out what is wrong with my code? Anybody have any ideas? Thanks in advance

=-=-= stdout -=-=-=-
Exception in thread "main" java.lang.NullPointerException
        at accountServicesInterface.getAllEntries(accountServicesInterface.java:24)
        at accountServicesInterface.main(accountServicesInterface.java:79)

=-=-= java code -=-=-
package com.bedlam.accountServices.common;

import com.bedlam.accountServices.database.*;
import com.bedlam.accountServices.common.LogWriter;

import java.sql.*;

public class accountServicesInterface {
  private Database db;
  private Table table;
  private String tableName;

  public accountServicesInterface(String tableName) {
    db = new Database();
    Table table = db.getTable(tableName);
    this.tableName = tableName;
  }

  public Row getEntry(String crit) throws SQLException {
    return table.getRow(crit);
  }

  public RowSet getAllEntries(String crit) throws SQLException {
    return table.getRows(crit);
  }

  public int generateRandomID() {
    if (tableName.equals("UserClient"))
      return (int)(Math.random()*15000);
    else
      return (int)(Math.random()*30000+15000);
  }

  public int generateValidatedRandomID() throws SQLException {
    int id = generateRandomID();
    String criteria,field;

    if (tableName.equals("UserClient")) {
      criteria = "USERID="+id;
      field = "USERID";
    } else {
      criteria = "MERCID="+id;
      field = "MERCID";
    }

    boolean isValid = isEntryValid(criteria,field);
    while (!isValid) {
      id = generateRandomID();
      isValid = isEntryValid(criteria,field);
    }
    return id;
  }

  public boolean isEntryValid(String crit, String field) throws SQLException {
    Row row = getEntry(crit);
    String isValid = row.get(field);
    if (isValid.equals(null))
      return false;
    else
      return true;
  }
   
     
  public void insertEntry(Row entryRow) {
    try {
      table.putRow(entryRow);
    } catch(SQLException e) {
      LogWriter.write("accountServicesInterface",
                      "insertEntry",
                      "Exception while inserting new row",
                      e);
    }
  }
     
  public static void main(String args []) {
    accountServicesInterface ac
      = new accountServicesInterface("userClient");
    try {
      RowSet rows = ac.getAllEntries("userid>0");
    } catch(SQLException e) {
      LogWriter.write("accountServicesInterface",
                      "getEntry",
                      "Exception while executing SQL statement",
                      e);
    }
  }
}
0
Comment
Question by:blizz_ard
  • 3
4 Comments
 
LVL 92

Accepted Solution

by:
objects earned 35 total points
ID: 10856974
> Table table = db.getTable(tableName);

change that to:

table = db.getTable(tableName);
0
 
LVL 92

Expert Comment

by:objects
ID: 10856977
your existing code initialises a local var named table, instead of the table member var.
0
 
LVL 1

Expert Comment

by:KartikShah
ID: 10859693
The problem seems to be in your constructor. You current code is :

  public accountServicesInterface(String tableName) {
    db = new Database();
    Table table = db.getTable(tableName);
    this.tableName = tableName;
  }


while it should be:

  public accountServicesInterface(String tableName) {
    db = new Database();
    this.table = db.getTable(tableName);
    this.tableName = tableName;
  }


The problem here was, that you are initializing a local variable table, in your constructor, thile, you should have referenced to the variable table, which is a member variable.

This seems to be the reason for getting the NullPointerException
0
 
LVL 92

Expert Comment

by:objects
ID: 10864427
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now