java nullpointer exception error
HELP!!!!
java.lang.NullPointerException
at csc.util.SQLstatement.prepStatement(SQLstatement.java:24)
at csc.util.dbutil.DBprcslogEnd(dbutil.java:713)
at tr_fets_ck.processMain(tr_fets_ck.java:266)
at tr_fets_ck.main(tr_fets_ck.java:175)
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:153)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at tr_fets_ck.processMain(tr_fets_ck.java:183)
at tr_fets_ck.main(tr_fets_ck.java:175)
I can run my code using jdeveloper 10g using a default file and everything works fine but when I run my code in the production environment I get the error listed above.
Here's portions of the code.
public void processMain(csc.util.SQLstatement sq, String filename) {
try {
// Connect to the database
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:TEST","test","test4xml");
// Open specified file
if (xu.Check_File_Processed(conn, filename)){
xu.WriteXMLProblem("FAILURE", err, "N/A", "FILE " +filename+ " HAS ALREADY BEEN RUN SUCCESSFULLY","https://msis.k12.ms.us/SAP/MSIS_err.html#87");
UpdateFETSDistrict(conn, "N", filename, district, year, sq);
xu.Process_Results_Report(conn,err,filename);
conn.commit();
conn.close();
System.exit(0);
}
The code that I think is generating the error is:
if (CheckYearInd(conn,district, year, sq)) {
xu.WriteXMLProblem("FAILURE", err, "N/A", "FILE " +filename+ " PREVIOUS YEAR DATA HAS ALREADY BEEN COMPLETED","https://msis.k12.ms.us/SAP/MSIS_err.html#87");
UpdateFETSDistrict(conn, "N", filename, district, year, sq);
xu.Process_Results_Report(conn,err,filename);
conn.commit();
conn.close();
System.exit(0);
}
public static boolean CheckYearInd (Connection conn,
String district,
String year,
csc.util.SQLstatement sqs)
// check the FETS_DISTRICT_APPROVAL table for a record.
// Return FALSE if previous year data exists = Y.
// Return TRUE if no record exists
throws SQLException
{
PreparedStatement pstmt1 = null;
String SQLString = "select count(rowid) from FETS_DISTRICT_APPROVAL" +
" where DISTRICT_NUMBER = ? and "+
" YEAR = ? and " +
" BOND_DATA_IND = 'Y' and "+
" STATE_APPROVAL_STATUS = 'COMPLETED' and "+
" REQ_RESUBMISSION = 'N' ";
//System.out.println(SQLString);
pstmt1 = sqs.prepStatement(conn,SQLString);
pstmt1.setString(1,district);
pstmt1.setString(2,year);
ResultSet rset = pstmt1.executeQuery();
rset.next ();
if (rset.getInt(1) > 0) {
rset.close();
return false;
} else {
rset.close();
return true;
}
} // end CheckYearProcessed
