?
Solved

NullPointerException ???

Posted on 2004-04-18
4
Medium Priority
?
275 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 92

Accepted Solution

by:
objects earned 140 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
This video teaches viewers about errors in exception handling.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month12 days, 22 hours left to enroll

777 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