• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

JAVA MySQL connection - how to?

R

ramfade

Guest
I'm pretty much a newbie to JAVA, so thanks to anyone taking the time to read this.

My system:
FC2
Plesk 7.5.4
PHP 4.3.10-2.4
MySQL 4.1.15-1.rhfc2.art
Tomcat 4.1.24-full.2jpp
HTTPD (Apache I assume...) 2.0.49-4

What I've done:
I was able to create my first usable JAVA application. It's purpose is to optimize (resize and compress) images for the web, upload to the server, and insert the image name and location into the database. It can do one, several, or an entire directory of images at once. It does this by posting an HTML multi-part form to a php script on the server, which in turn handles the files and runs the (MySQL) insert/update queries to update the database. The application can also read data very crudely by reading HTML output from the server. It works but it's cumbersome with the 'split' code I have to write.

What I want to do:
I want to improve on this and use JAVA for everything, especially for reading the data from the server - but I can't figure out where to start! The tutorials I find seem to do everything on one machine, and I don't really understand how much has already been done since Tomcat is already installed.

The desired result:
My goal is to have the application process all the images on the local machine, then upload to the server and insert into the database, among other database entry/edit tasks. I don't know if an applet would be better, I'm concerned with the size of the applet and how long it would take to load from the server. Or a servlet? I don't want to upload the images before optimizing for web, one of my clients thinks he needs a 10 megapixel image for anything!

Or do I need a combination servlet / application for the database connection? I just don't know - my learning curves are usually flat longer than most I think.

Any advice would be greatly appreciated!
 
Back
Top