Hi everybody,
I have to develop a swing app (or jsp) which can manage records on a
MySql db table, and to associate an image file to each record. I
thought to make it in this way:

- sending the image file through FTP
- associate the file path on the web server to the record


Have you got any suggestion?
Regarding FTP do you think is it a good solution?


Thank you very much in advance for your help

carmelo wrote:

> Hi everybody,
> I have to develop a swing app (or jsp) which can manage records on a
> MySql db table, and to associate an image file to each record. I
> thought to make it in this way:
> 
> - sending the image file through FTP
> - associate the file path on the web server to the record
> 
> 
> Have you got any suggestion?
I would put the images into a BLOB field.

> Regarding FTP do you think is it a good solution?
> 
Yes, that'd work.

On 5 Mag, 12:32, Sabine Dinis Blochberger <no.s...@here.invalid>
wrote:


Thank you for your answer.
But putting the image into a BLOB field, can I display it later on a
web page?

carmelo wrote:
> But putting the image into a BLOB field, can I display it later on a
> web page?

Yes.

-- 
Lew

On May 5, 11:26 am, carmelo <csa...@tiscali.it> wrote:
....
> Regarding FTP do you think is it a good solution?

FTP has hardly any concept of security.

It is a good solution as long as you have no security
concerns at all.

If you have control over the server that needs
to receive the file, configuring SSH and using
SCP is a much better alternative (SFTP would do
too).

I implemented exactly what you describe using SCP.

More fancy setups like FTP over TLS or FTP over SSH
can be made to work but I think using SSH/SCP is
way easier.

If you value security, FTP is a big no-no.

carmelo wrote:
> Hi everybody,
> I have to develop a swing app (or jsp) which can manage records on a
> MySql db table, and to associate an image file to each record. I
> thought to make it in this way:
> 
> - sending the image file through FTP
> - associate the file path on the web server to the record
> 
> 
> Have you got any suggestion?
> Regarding FTP do you think is it a good solution?
> 
> 
> Thank you very much in advance for your help
The JSP can handle the server side (receiving the file and putting it 
into the database) - you don't need the overhead of interfacing with an 
FTP server. The JSP can also retrieve and display the images if that's 
part of the assignment. You can use a browser, an HTML form and <input 
type file> for the client side upload.


-- 
Dave Miller
Java Web Hosting
http://www.cheap-jsp-hosting.com/