This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes Performance and the fly likes JSP and Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "JSP and Access" Watch "JSP and Access" New topic
Author

JSP and Access

kevin quinn
Greenhorn

Joined: Aug 15, 2001
Posts: 3
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

Joined: Jul 13, 2001
Posts: 50
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

Joined: Jul 09, 2001
Posts: 1879

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

Joined: Jul 18, 2001
Posts: 39
Did they "commit" after "insert"?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSP and Access