It seems like I need to synchronize access to the tags that perform these updates. Here's my rationale. My tags read the workbook to figure out the row count and perform an insert on a cell of a specific row and then save it back to the file. If two requests come into this JSP at the same time, they'll both have the same initial picture of the file (assuming it will even be read and won't throw a lock or FileNotFoundException) and when they update, the last update will win.

But still this synchronization solution doesn't seem to help at the file level. Additional thoughts?

Brian



Brian Bonner wrote:

Hi Guys,

I had a request from someone to allow them to write forms directly to an Excel spreadsheet. This user is not a developer, but does do web design and is fairly fluent with HTML, xHTML. Anyway.

I have written a tag library to allow read/write access to/from Excel spreadsheets using POI. It works well, and I know that POI is not threadsafe.

I could synchronize access to calls made by the tags to POI. But I'm also concerned about a user opening up the file and locking up the app.

Any suggestions?



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to