Now how can I find the RESULT in my ResultSet rs???
pl z help!!!
Why do you need a result Set for Batch ? Usually Batch is used to execute series of insert/update/delete statements pertaining to a single transaction.Either you commit at end or rollback on failure. Thus making it behave as single transaction.
Result Set object maintains cursor to navigate in the records fetched from DB. Its not useful in updateBatch case.
our requirement is
we have a list of mailids in oracle table. we want to read all the mailids and wants to send a mail to them (i have a code to send mails). but this should be happen on daily basis.i dont know how to do this.can somebody help me in this.
Just query your database for the email ids something like "Select * from emailtable where conditon". Once you execute the above statement you get the resultset. Loop through the resultset and get all the emails ids and store them in a StringBuffer seperated by ";". Then use this in your mailer programme.
in the future, please do not post unrelated questions into an existing topic. Your question has nothing to do with the original topic, and we now have a discussion that deals with two unrelated issues, which is something we try hard to avoid.