RE: Simple question about JSP page
you should post you tag code of the code for that page. It can either be a problem with your tag, or the connection pooling. Try stopping and restarting the app in the manager and see if that makes the updates take affect. If so, the issues is with re-use of objects and possible connection pooling. Shawn Zernik Internetwork Consulting www.internetworkconsulting.net -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Simple question about JSP page Hi, Maybe it's a stupid question. Built jsps for addingsearching with MySQL. First listing all existing records in db and then adding a new one into database, then listing all records again. Now the list is the same as previous. How to solve it? THX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Simple question about JSP page
Hard to tell with the information given, but my guess is that you're getting a browser-cached copy of the list all page. Add the header voodoo to suppress caching and see if that helps. -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: Fri 9/5/2003 7:30 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Subject: Simple question about JSP page Hi, Maybe it's a stupid question. Built jsps for addingsearching with MySQL. First listing all existing records in db and then adding a new one into database, then listing all records again. Now the list is the same as previous. How to solve it? THX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Simple question about JSP page
Have you verified that the record IS getting added correctly to the DB? Have you hit the refresh button to check that your browser isn't displaying a stale page? If an old page is getting displayed you can turn off page cacheing by calling: response.setHeader(Pragma, no-cache); - Original Message - From: engp0510 [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, September 06, 2003 3:30 AM Subject: Simple question about JSP page Hi, Maybe it's a stupid question. Built jsps for addingsearching with MySQL. First listing all existing records in db and then adding a new one into database, then listing all records again. Now the list is the same as previous. How to solve it? THX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Simple question about JSP page
Has your SQL code issued a commit after adding the extra rows? Some DBMSs require that before the application can see new rows in the database - a repeated query simply gets the original result until the rollback buffer is committed. Murray -Original Message- From: engp0510 [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Simple question about JSP page Hi, Maybe it's a stupid question. Built jsps for addingsearching with MySQL. First listing all existing records in db and then adding a new one into database, then listing all records again. Now the list is the same as previous. How to solve it? THX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Simple question about JSP page
1st, you shouldn't cross post to more than one list at a time. 2nd, without seeing your code, we can't help you. Have you checked the DB with another tool to verify that the record was actually added to the database? Are you catching SQL errors and doing something useful with them so you can see why your insert is failing (if it is)? On Friday 05 September 2003 10:30 pm, you wrote: Hi, Maybe it's a stupid question. Built jsps for addingsearching with MySQL. First listing all existing records in db and then adding a new one into database, then listing all records again. Now the list is the same as previous. How to solve it? THX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Simple question about JSP page
Did you commit the Add transaction prior to loading the list again? More details would be helpful prior to making any more guesses. Cheers Christopher Marsh-Bourdon Pyplia Limited On 6/9/03 3:30, engp0510 [EMAIL PROTECTED] wrote: Hi, Maybe it's a stupid question. Built jsps for addingsearching with MySQL. First listing all existing records in db and then adding a new one into database, then listing all records again. Now the list is the same as previous. How to solve it? THX - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]