Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP and Access

 
kevin quinn
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am running JSP on Tomcat, NT using a simple Access backend. Often, users will be told they have made a successfull insert into the database but the database was not updated. Any Ideas?
 
Reuben Cleetus
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have all connections/resultsets been closed? Hanging connections/resultsets cause updates to be delayed in Access.
Regards,
Reuben.
Originally posted by kevin quinn:
I am running JSP on Tomcat, NT using a simple Access backend. Often, users will be told they have made a successfull insert into the database but the database was not updated. Any Ideas?

 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have heard of this happening from other people using access. You have to close the connection(can be time consuming to open/close connections after every SQL statement) OR do a meaningless select from the table you updated. For somereason when you do a query on the table you just updated, the changes mysteriously show up!
eg.
"insert into emp values (id,...)"
after this insert perform a select on emp- "select id from emp where id = 'somevalue'"
hope this helps,
Jamie
 
wei ma
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did they "commit" after "insert"?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic