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]
Re: Pls help me !! Urgent!
For columns that return null values why don't you check if the rset.getString() returns null? If you installed tomcat with the exe rather then there is a option for you to install tomcat as a service. I think the program that tomcat uses to do this is freely available but escapes me at the moment. Try doing a google for javant service or something like that. zafar Ahsan wrote: 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]
RE: Pls help me !! Urgent!
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]
Re: Pls help me !! Urgent!
Hi Zafar
I wrote this very simple method
public final static String getString(String pOriginal) {if (pOriginal ==
null) return new String();return pOriginal;}
and i use it to retrieve strings that can be null, getting in this case a
new string.
bye bye
Giorgio
- Original Message -
From: "zafar Ahsan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 10, 2003 8:16 AM
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]
Pls help me . Urgent(JDBC oracle thin driver+tomcat+servlet)
Dear sir/madam, Just after looking at email, u might be thinking ohhh am there to eat yr time, but sir/madam am sorry for this, i try my best not to take much of yr time and when i really get in to trouble i use to write to u, i know yr time is very precious, am very thankful for yr kind help that u have provided to me till date. Sir/madam i have little problem pls try to solve it. am using tomcat3.2.4 ok i have created my own application directory, $tomcat_home\webapps\zaf_fin and have configured server.xml file and also $tomcat_home\webapps\zaf_fin\web-inf\web.xml for my servlet. The server is starting without any problem though initially there were some mistake and it cozed some problem but then i could be able to make it so now its working ok. i have my htm file at $tomcat_home\webapps\zaf_fin\salslip.html and my class file for servlet in $tomcat_home\webapps\zaf_fin\web-inf\classes\Salaryslip Now pls let me know 1 Do i need to configure server.xml file again for jdbc if so what i would have to do. 2How to call servlet from html file. i mean am usng form tag method=post action=..( what i have to write to here pls write me considering am on local host) am confused about this becoz on its local host site if i try to some examples it shows action to a directory servlet and in tomcat whole directory structure there is no servlet directory but there is one servlets directory. How does it do that where to cheek for this clue. pls help me i would be really very -very thankful to yr kind help.pls zafar [EMAIL PROTECTED] _ 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]
Pls help me . Urgent(JDBC oracle thin driver+tomcat+servlet)
Dear sir/madam, Just after looking at email, u might be thinking ohhh am there to eat yr time, but sir/madam am sorry for this, i try my best not to take much of yr time and when i really get in to trouble i use to write to u, i know yr time is very precious, am very thankful for yr kind help that u have provided to me till date. Sir/madam i have little problem pls try to solve it. am using tomcat3.2.4 ok i have created my own application directory, $tomcat_home\webapps\zaf_fin and have configured server.xml file and also $tomcat_home\webapps\zaf_fin\web-inf\web.xml for my servlet. The server is starting without any problem though initially there were some mistake and it cozed some problem but then i could be able to make it so now its working ok. i have my htm file at $tomcat_home\webapps\zaf_fin\salslip.html and my class file for servlet in $tomcat_home\webapps\zaf_fin\web-inf\classes\Salaryslip Now pls let me know 1 Do i need to configure server.xml file again for jdbc if so what i would have to do. 2How to call servlet from html file. i mean am usng form tag method=post action=..( what i have to write to here pls write me considering am on local host) am confused about this becoz on its local host site if i try to some examples it shows action to a directory servlet and in tomcat whole directory structure there is no servlet directory but there is one servlets directory. How does it do that where to cheek for this clue. pls help me i would be really very -very thankful to yr kind help.pls zafar [EMAIL PROTECTED] _ 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]
RE: Pls help me . Urgent(JDBC oracle thin driver+tomcat+servlet)
Dude, you must take a look at Sun´s tutorial about servlet, i´m think that it´s your first step to understand the Servlet/JSP universe: > -- > De: zafar ahsan[SMTP:[EMAIL PROTECTED] > Responder:Tomcat Users List > Enviada: quarta-feira, 26 de fevereiro de 2003 2:10 > Para: [EMAIL PROTECTED] > Assunto: Pls help me . Urgent(JDBC oracle thin driver+tomcat+servlet) > > Dear sir/madam, > > Just after looking at email, u might be thinking ohhh am there to eat > yr time, but sir/madam am sorry for this, i try my best not to take much > of yr time and when i really get in to trouble i use to write to u, i know > yr time is very precious, am very thankful for yr kind help that u have > provided to me till date. > > Sir/madam i have little problem pls try to solve it. am using tomcat3.2.4 > > ok i have created my own application directory, > $tomcat_home\webapps\zaf_fin > > and have configured server.xml file and also > > $tomcat_home\webapps\zaf_fin\web-inf\web.xml for my servlet. > > The server is starting without any problem though initially there were > some mistake and it cozed some problem but then i could be able to make it > so now its working ok. > > i have my htm file at > > $tomcat_home\webapps\zaf_fin\salslip.html > > and my class file for servlet in > > $tomcat_home\webapps\zaf_fin\web-inf\classes\Salaryslip > > Now pls let me know > > 1 Do i need to configure server.xml file again for jdbc if so what i > would have to do. > > 2How to call servlet from html file. > > i mean am usng form tag method=post > action=..( what i have to > write to here pls write me considering am on local host) > > am confused about this becoz on its local host site if i try to some > examples it shows action to a directory servlet and in tomcat whole > directory structure there is no servlet directory but there is one > servlets directory. > > How does it do that where to cheek for this clue. > > pls help me i would be really very -very thankful to yr kind help.pls > > zafar > [EMAIL PROTECTED] > > > > > > > _ > 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] >
