Hi Le,
Do u get Nullpointer Exception? Have u checked the details of the Exception??
Vijay
LeBaron Price <[EMAIL PROTECTED]> on 09/20/2000 09:45:31 PM
Please respond to "A mailing list for discussion about Sun Microsystem's
JavaServlet API Technology." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Vijay Deshpande/HAZIRA/RIL)
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
