关闭statement时出现NullPointerException

0 0

关闭statement时出现NullPointerException10

公司的一个系统出了个很奇怪的问题，方法调用Trace如下：

ABC.java

......
Connection connection = null;
PreparedStatement ps = null;
ResultSet rs = null;
......
try {
    if(A){
        theSQL = "******";
        connection = theContext.theSQLMgr.getDBSession().getConnection(); 
        ps = connection.prepareStatement(theSQL);
        ......
    }
    else{
        theSQL = "******";
        connection = theContext.theSQLMgr.getDBSession().getConnection(); 
        ps = connection.prepareStatement(theSQL);
        ......
    }
} catch (SQLException e) {
	e.printStackTrace();
	throw new DBResourceException(e);
} finally {
        DBUtils.release(theContext, rs, ps, connection);
}

DBUtils.java

public static void release(Context context, ResultSet rs, Statement ps, Connection con) {
	if (rs != null) {
	    context.theSQLMgr.getDBSession().releaseResultSet(rs);
	}
	if (ps != null) {
		context.theSQLMgr.getDBSession().releaseStatement(ps);
	}
	if (con != null)
		context.theSQLMgr.getDBSession().releaseConnection(con);
	}

DBSession.class

/**
     * Releases preparedStatement from the database.
     * @param statement
     */
    public void releaseStatement(Statement statement) {
    	if (statement != null) {
    		try {
    			statement.close();
    		} catch (SQLException e) {
    			dbSessionLogger.warn("Error:DBSession.releaseStatement", e);
    		}
        }
    }

***WrappedStatement.class(implements PreparedStatement)

public void close()
    throws SQLException
  {
    SsaGenericApplication.logDebug(this.name + "--[close]:: closing statemt...");
    if ((!this.inTrans) || (!this.updateQuery))
    {
      this.stmt.close();
      this.stmt = null;
    }
    SsaGenericApplication.logDebug(this.name + "--[close]::statment closed");
  }

在最后这个class中就报异常了，信息如下：

10:29:10,414 ERROR [STDERR] Caused by: java.lang.NullPointerException
10:29:10,414 ERROR [STDERR]     at com.***.service.baseobjects.***WrappedStatement.close(Unknown Source)
10:29:10,414 ERROR [STDERR]     at com.agileitp.forte.genericdbms.DBSession.releaseStatement(DBSession.java:202)
10:29:10,414 ERROR [STDERR]     at com.***.service.utils.DBUtils.release(DBUtils.java:36)
10:29:10,414 ERROR [STDERR]     at com.***.service.dcustomize.TransferP1S1.processStep(TransferP1S1.java:297)
10:29:10,414 ERROR [STDERR]     at com.***.service.exeprocessmanager.TransactionService.executeProcedure(Unknown Source)
10:29:10,414 ERROR [STDERR]     at com.***.service.exeprocessmanager.TransactionServiceSOBean.executeProcedure(Unknown Source)
10:29:10,414 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
10:29:10,414 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:10,414 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:592)
10:29:10,414 ERROR [STDERR]     at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

理论上，最后一个class的

this.stmt.close();

不可能报错，因为之前已经做过ps!=null的判断了，至此失去思路。

不知错误可能出在哪里？

数据库 NullPointerException

2012年11月29日 14:48

richit
13
0 0 1

1个答案按时间排序按投票排序

0 0

public void close()
    throws SQLException
{
    SsaGenericApplication.logDebug(this.name + "--[close]:: closing statemt...");
    if ((!this.inTrans) || (!this.updateQuery))
    {
      this.stmt.close();
      this.stmt = null;
    }
    SsaGenericApplication.logDebug(this.name + "--[close]::statment closed");
}

估计是你最合格包装的statement的 this.stmt 为null 你可以看看

2012年11月29日 15:49