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/