June 18th, 2002, 11:17 AM
Hi - I am trying to update a field in my table where a certain condition is met eg I want to update my address field where name = the name given in a html form. When i try run the jsp page it never finishes so I am not gettin any errors but it doesnt stop. Does anyone have any idea what is wrong with my code:
String sql="UPDATE Table SET ADDRESS='" + ADDRESS + "' WHERE NAME='" + NAME + "'";
Statement stmt = con.createStatement();
String newLocn = "choose.html";
Thank you in advance, loneill!
June 19th, 2002, 05:45 PM
This is a complete guess, but I can't see where else this would just stop. But I think you are defining your connection wrong.
I don't think the // is gonna be picked up at all, cos I think that bit is treated like a domain, or ip. So maybe use the ip loop back of "127.0.0.1" or setting a server name in your hosts file to point at that ip, then use that (call it localhost - as you have - which means it's likely this is set already). You'll probably also want to set up the odbc settings to add an interbase db so that you can asccess it (unless this is a direct access driver rather than an odbc one - which I can't really tell from this). Also you might find that the driver listens on a specific port (I think oracle is 1526 by default, but it'll probably be different for interbase), so maybe something along the following lines would work
Hope this helped
June 19th, 2002, 05:55 PM
ok, I've just looked at some interbase documentation and it appears it's nothing like the oracle driver.
In which case there are only a 3 things I can think it might be
1) you haven't got "InterServer" running
2) localhost isn't defined in your host file to loop back to your local ip, or the loopback ip
3) (a silly one), use upper case "C:" instead of lowercase
June 20th, 2002, 04:09 AM
Thanks for your help. I have managed to sort the problem now , I don't know why this is but when I came back the next date it worked fine, weird!!