This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi All!! Thanks for ur concern in solving out my query. as u asked for the code, i don't know how best i can represent it to u, as it's very easy easy to get confused with the project specific intricacies & database details. one or two three things i would like to tell u 1. i don't what do u mean by thread safe sevlet or jsp page for that metter (and i only know that web server takes care of it by itself.) 2. i haven't closed my resultset object anywhere in the whole file as if i go about doing that then tomcat causes even more problem. i mean i haven't used the folowing code anywhere in the file resultset1.close(); resultset2.close(); statement1.close(); statement1.close(); conn.close(); now here is my code sample............................ ur help is very much required.... Thanks in advance lusha
lusha: I could see your code when I went to reply to you. To make your code visible you have to take the html stuff out and just post the java code. I think I see your problem. you are using the jdbc dbc bridge. There are some restrictions when you use this driver. One of them is that you can only have one statement per connection. I see that you have 2 statements for 1 connection. When you open the second statement, you are implicitly closing the first statement(and again implicitly closing any associated resultsets to the first statement). You are limited to one statement per connection, so you need to open another connection to exececute the second statement. Jamie