This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
In my Project i am getting data from one recordset .using this recordset value i can get another value, so i open new recordset object it gives an error . so i tried in anotherway like to create new connection new preparestatement and recrdset but it gives an error msg . how to i solve this problem .if any idea how to get two values from the table.
first of all the way you are creating pstmt1 is not perfect. the number of records in outer resulult set will cause the same number of times pstmt1 to be created instead of this you can create pstmt1 once and reuse it by calling method clearParameters() over statement.
can you paste the exception/error you are getting
Joined: Aug 01, 2004
hai Shailesh Chandra
ok fine its working.now error was corrected . ok thanks .
yester day you are said prepareStatement handling is not good . but now i am using in this way. if u send any sample codeing i can follow that format ok thank u p.manikandan