Write file to webserver from an Applet

[sanoj_av]

Hi, I am new to Java,

I have simple applet which works fine. I just want to show some information which are enetred by some users to all the users of the applet. For that I use a small light weight DB (sqlite version 3). I am creating the connection as follows
Connection conn =DriverManager.getConnection("jdbc:sqlite:"+System .getProperty("user.dir")+"\\GT.db");
Now my problem is that the applet create the GT.db file in the client machine as the System.getProperty("user.dir") return the user directory on the client , not on the server. Hence i am not able to achieve what I want. How do I save the file on the web server instead of the client ?
I am using a signed applet. I dont have much control over the web server to install programs or add server side processes; but I can upload files. I googled and found that an applet can read and write files to the host where it is coming from. If so how do i do it? can any one help me please ?

[cselic]

I think this example would be helpful:

Java HTTP example - Reading and writing to an HTTP server | devdaily.com

[Tolls]

If you want all the users to see data from each other then you need your db on the server.
Second, you will either have to expose that db through a port (I don't know sqlite, so can't say if that's doable), or have some code (servlet, php, whatever) that will do the accessing and your applet will then make http calls to this.

[Webuser]

So you mean uploading ?

[sanoj_av]

Thanks Tolls & cselic for your valuable replies. I solved it by using one server side script in PHP which talks to the database and call that PHP from my application by using URLConnection class.


Thanks
Sanoj

[Webuser]

Thanks Tolls & cselic for your valuable replies. I solved it by using one server side script in PHP which talks to the database and call that PHP from my application by using URLConnection class.

Much surprised to see PHP advices on Java forum :confused:

Now my problem is that the applet create the GT.db file in the client machine as the System.getProperty("user.dir") return the user directory on the client , not on the server.

Oh... It is not a problem but an applet reality cause applets are client apps ;)
To avoid that I recommend just use a servlet for your applet because servlets are really can get access your server side as a desktop app ;)
So write a servlet doGet method and place your code in it like a

Connection conn =DriverManager.getConnection("jdbc:sqlite:"+System .getProperty("user.dir")+"\\GT.db");

then connect your applet to your servlet and that's it :) it is a simpliest way to solve your problem I guess. If problem stays report

[Tolls]

He solved his problem.
He has the applet talking to a server that does the work for him.
Who cares whether that server code is written in PHP, Java, or Flingleplap?

[Webuser]

Who cares whether that server code is written in PHP, Java, or Flingleplap?

Java fans, pal :rolleyes: