Zafar,
You need to test for the null after you have retrived the parameter from the
query, via jdbc ResultSet.wasNull()
Code might look like
CallableStatement cs;
// setup the callable statement stuff prior to here
ResultSet rs = cs.executeQuery();
while (rs.next()) {
String param = rs.getString(pos);
if (rs.wasNull() == true) {
// set preferred param value
param = "0"; // or ""
}
}
Hope this helps
Bill
-----Original Message-----
From: zafar Ahsan [mailto:[EMAIL PROTECTED]
Sent: Monday, 10 March 2003 6:16 PM
To: [EMAIL PROTECTED]
Subject: Pls help me !! Urgent!
hello
Can any one pls let me know how to deals with null that result set returns
when quering from an oracle database. its display "null" when using
rset.getString() method and i want it to be either 0 or " "(nothing).Am
novice to java and tomcat and null being a special literal in java cosing me
problem to get up to my work.
I would be very thankful for yr kind help.
And if don't mind pls let me also know how to start tomcat server through
windows server2000 services.
Md. Zafar Ahsan
_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
