Unanswered: connect to mysql via applet on remote server
If I have missed posts on this, apologies in advance. I've spent the last 3 weeks googling and posting to find a solution.
I'm running a java applet which needs to connect to mysql on a remote server. I have read some posts that suggest using PHP to act as a proxy. The applet then contacts the proxy. Has anyone done this? Can you offer code snippets that demonstrate this. This seemed like a workable solution until it's time to run the JDBC DriverManager getConnection method: getConnection( url ). It does not like to see anything other than hostname/database?user= .... Attempts to use the php script in there result in Exceptions.
Any other concrete solutions (aside from signing the applet)?
I've got a lot of pieces in place: running apache/php on linux. The applet runs and does connect to mysql on the hosting server.
If I can do this without adding another daemon on the server (ie, jakarta, etc) that would be great. I am not opposed to running a jakarta. If that is the recommendation, how to do this?