Hi,

You don't have to use a DB for such a process! A file server could do! I
would imagine having a directory per customer. Grant read/write access to
their own directory and use a DAO to access it. You could Handle directory
creation and authorisations in a common service component. Your file
server could be a Network Area Storage if you like. Of course, you should
handle this in the business tier.

My whole point here is that you don't have to use a DB.

Christophe
SCEA


> Hi all, my current project is for a law company that wants to upload
> document files contains legal information of their customers (balance of
> the company, fiscal position, taxes paid/to be paid etc.) and let the
> customers to access those files online.
>
> Because every customer will have their own username and password to
> access only their own documents, I think the document will be stored
> into a database and let the customers download instead of saving as a
> file on server. That way, the customer will not be able to access files
> by typing URL address.
>
> My problem is I don’ know if MySQL is strong enough to handle the file
> serving task. Does anyone have any idea? What is the most secure way to
> let the customer access their files?
>
> Thanks in advance.
> Thuan Nguyen
> ------------------------------------------------------------------------------
>
> This email is confidential and may be legally privileged.
>
> It is intended solely for the addressee. Access to this email by anyone
> else, unless expressly approved by the sender or an authorized
> addressee, is unauthorized.
>
> If you are not the intended recipient, any disclosure, copying,
> distribution or any action omitted or taken in reliance on it, is
> prohibited and may be unlawful. If you believe that you have received
> this email in error, please contact the sender, delete this e-mail and
> destroy all copies.
>
> =======================================================================================================================================================
> To unsubscribe, send email to listserv@(protected)
> body of the message "signoff J2EE-INTEREST". For general help, send
> email to listserv@(protected)
> "help".
>
>
> ==========================================================================To
> unsubscribe, send email to listserv@(protected)
> of the message "signoff J2EE-INTEREST". For general help, send email to
> listserv@(protected)".

===========================================================================
To unsubscribe, send email to listserv@(protected)
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected)".