AppletTalk.com

Chetan Nehete via JavaKB. · Guest

Hi guys,

am facing problem while iterating through while(rs.next()).

I want to retrive userid from my database through username criteria.
I wrote one simple query for that.
But after getting connection,statement and executing query,at the time of
entering while(rs.next()),it is giving problem,it is not entering into
while and that's why my value of userid is not not getting set into data
object.Consenquently,in further method calls the userid is going null,and
it's throwing NullPointerException.

I've provided code below,plz help me for the same.

thanx to all of u.

try
{
String sql = getQuery("SQL_SELECT_CTS_USERS_USER_ID");
//The query for above key is "Select * from CTS_USERS where upper(USERNAME)
= ?"
conn = ConnectionManager.getConnection();
pstmt=StatementFactory.getStatement(conn,sql);

if(ctsUserData.getUserName() != null && ctsUserData.getUserName().trim()
..length() > 0)
{
System.out.println("InvestigatorSessionBean.deleteFromLDAP() in if");
pstmt.setString(1,ctsUserData.getUserName().toUpperCase());
}
else
{
System.out.println("InvestigatorSessionBean.deleteFromLDAP() in the
else");
pstmt.setNull(1,Types.VARCHAR);
}
System.out.println("InvestigatorSessionBean.deleteFromLDAP() query is"
+pstmt);

rs=pstmt.executeQuery();
System.out.println("The resultset is"+rs);
while(rs.next())
{
ctsUserData.setUserId(new Long(rs.getLong("USER_ID")));
System.out.println("InvestigatorSessionBean.deleteFromLDAP() user id in
while "+ctsUserData.getUserId());
}
}
catch (Exception e)
{
e.printStackTrace();
msg = e.getMessage();
log(Priority.ERROR, msg);
throw new RemoteException(msg);
}
finally
{
ConnectionManager.cleanUp(conn, pstmt, rs);
}

--
Message posted via http://www.javakb.com

Robert Klemme · Guest

"Chetan Nehete via JavaKB.com" <forum (AT) JavaKB (DOT) com> schrieb im Newsbeitrag
news:ad5830f011e64f618a59c79451da9c4c (AT) JavaKB (DOT) com...

ableofhighheart@gmail.com · Guest

joeNOSPAM@BEA.com · Guest

Hi. There's nothing wrong with your code, as much of it as is shown.
SHow us the full stacktrace of the NullPointerException.
Joe Weinstein at BEA