Hi all, I have an application of this sort. I have a page written in JSP which has total 5 form elements in it. Depending on the number of times user wants i will select each set of these 5 fields and then insert into database. Suppose, the user wants to go for 3 times then total 15 values will be there. I add these 15 values in 3 sets with 5 each (coz 5 fields) and add to the database. Now my problem is, for adding these 15 fields one by one, i'm using a variable of type StringBuffer which keeps adding the total values the user selected. And finally i could able to get the values he selected in proper format. But here if around 100 users access at the same time, then i'm getting SQLException: string literal out of limit error :-( Will the stringbuffer is getting full? (which is possible?) And if i replace this file then it is working fine. Please help me, VENU __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ =========================================================================== 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
