try catching NullPointerException, because exception is general and you cant
able to figure out what exception it is. My initial guess is that it is
throwing a NullPointerException in authentication bean.
Try your luck
Srini
-----Original Message-----
From: LeBaron Price [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 5:16 PM
To: [EMAIL PROTECTED]
Subject:
Good morning all (esp. Nikhil)
I'm am struggling with the problem that Nikhil mentioned, I've got a Servlet
running
try {
String query;
query = "SELECT description FROM schema.table WHERE column = " +
somevalue;
// Create a Statement and call that fine query
stmt = localConn.createStatement();
rs = stmt.executeQuery( query );
// Get the results
if( rs.next() )
name = rs.getString( "somevalue" );
}
catch (SQLException e) {
Log.trace( "### SQLException thisproc ###\n" + e.getMessage());
}
catch( Exception e ) {
Log.trace( "somevalue= " + somevalue );
Log.trace( "### Some Exception in thisproc ###\n" +
e.getMessage());
StackTrace stackTracer = new StackTrace( e );
Log.trace( stackTracer.toString() );
}
and I'm getting the 'Exception e' error (not the SQL exception), but only
when I run the Servlet through our authentication bean, if I add some debug
code to bypass the security bean and open the Servlet up straight away it
runs fine. any thoughts on why this might be? and what I can do to get it up
and running all the time?
I'm using Apache, Jserve and Jonas for my servers.
thanks,
LeBaron.
--- previous post ----
Hi,
I hope you know that statement.executeQuery("SQL") may return an empty
resultset, but never NULL. And the only way whether it is empty( i.e. your
select statement does not return any value) is to use the method
Resultset.next(), it will return true if there is any record to read. If you
are
getting exception I am sure this is not due to this( rs.next() some thing
else.)
Nikhil
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
