Hi All,
I'm trying to move data from an online db to an offline one. I have a bean
that I have set up a select method to get info from one system, and the same
bean has an insert to put that data into the other system. However, when I
get a result set from the select and loop through it in the jsp, it always
exits after I call the insert.
Do I need to use two beans? The tables are the same on both systems so it
seems redundant. I'm using Resin with the datasources set up in the
resin.conf file. Is it a problem to be switching back and forth in the same
bean?
Here is a code snippet:
<% wwwOrder.select(); %>
<% while (wwwOrder.next()) { %>
<p><jsp:getProperty name="wwwOrder" property="orrfnbr"/>
<br><jsp:getProperty name="wwwOrder" property="orstat"/>
wwwOrder.insert();
<% } %>
If I have to use 2 beans, what is the best method to load the data from one
to the other? Is there a way to pass a whole result set?
Thanks for any clues!
Tom
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
