Well, it would seem it isn't a caching problem at all but a caught exception
which isn't printing a stack trace. Though I'm guessing it is because it is
within a <%! (declare) block so it doesn't have access to out (yes?)
At any rate this line is what is throwing a java.lang.NullPointerException
(beware word wrap) :
configValue.replace(0, configValue.capacity(), rs.getString("con_Value"));
configValue is a StringBuffer. It has to be the rs.getString("con_Value")
part. I've tried assigning rs.getObject("con_Value") to an object but when I
test the new filled Object with Object.equals(null) I get a
NullPointerException error again, though I suspect it is because the Object
gets set to null and is then not an object, but I'm new to java so I'm just
guessing. The con_Value in this case is indeed null in the SQL server 7 DB.
The damned thing is, I have a test page which connects to the same db and
renders a table from the resultset and it's metadata complete with column
names and the word null when a value is null and it is retrieving and
printing that table cells like:
for(int j=1; j<=rs.getMetaData().getColumnCount(); j++){
out.println("<td>" + rs.getObject(j) + "</td>");
}
My point being that null gets outputted then but I can never get those 4
characters as a string without getting a NullPointerException when I try to
get the value in any way...
Help?!?
--
John Minadeo
[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
