Writing sound file to mysql

Hello:

I have an applet that records sound from the client machine. I want to be able to save this sound clip --which is 10 secs--to mysql db. Additionally, the applet provides the user the option of playing back that sound (after it is recorded), I need to be able to perform this task as well. All of this happens within the same session.

Currently, the applet records the sound and saves on the user's desktop; for security resons, I want to avoid this process and write the file back to my server's db (same server serving up the applet).

Any guidance in this area is of great help;
Thanks

In which format files are?

Is the Applet connecting directly to the db?

If so then a straight JDBC PreparedStatement, using the setBinaryStream() to set the right field, passing in whatever stream is provided by your audio framework...presumably there's one that you use for writing out to the file currently.

I' m writing wav files.

Concerning Tolls' suggestion, if I want to avoid exposing mysql connection information when going directly from Applet to db, is there another option using some sort of php script and allowing this script to process this procedure with mysql?

For my current code to writeToFile, I have the following:

Code:

---

void writeToFile() throws IOException {
     
        long lLengthInFrames = totalCount / format.getFrameSize();
        PipedOutputStream pos = new PipedOutputStream();
        PipedInputStream ios = new PipedInputStream(pos);
        AudioInputStream ais = new AudioInputStream(ios, format, lLengthInFrames);
        WriterThread thread = new WriterThread(ais, "WriteThread", outname);
        thread.start();
       
        osOut.writeTo(pos);
       
        try {
            thread.join();
        } catch (java.lang.InterruptedException e) {
            System.err.println(e);
        }
       
    }

---

Any thoughts any of this?

In such situations what I'm doing is use of separate service to ftp relevant files, and avoid the overhead from the client side. It could in different models, like windows service, etc...

Send the file as an attachment?
You should then be able to simply call the php script like that.

Hunt around in the Http stuff for Java....there's stuff on here about it, but it's 4 years old. There may be a package (HttpClient?) that does most of this for you.

Basically rolling your own http request as if it came from a browser, with multipart file stuff. Then on the server you can use whatever technology you are used to to accept the file and store it on the db.