remote jdbc 1

[Krogh]

hi,

i made an applet to upload a file from the client to a server using ftp, after the upload i need to register the file in a database, how could i connect to the database without RMI, servelet, etc. The database isn't on the same server that the applet.
My applet is signed with full permission

thx for help
Krogh

PS : excuse my english..

 

[LittleWing]

i don't think you can. an applet runs in the browser so giving it full permissions only allows it acces to the local machine, not a remote machine.

i would strongly suggest to use either RMI or servlets but if you can;t, there are two suggestions i would give.

1. as you can already ftp, you could ftp a flat file with the name of the file to be registered. on the remote machine a process could look for these files occasionly and then execute a stored procedure to update your database.

2. consider running an rexec or rsh to call a local command(script), passing in your file nams as an arguement. this local script would then call the stored procedure on your database.

i still think you should use a servlet though!!

 

[Krogh]

thx.. but i saw since yesterday i can use a postgres database to do it without rmi or servlet :
getConnection("jdbcostgres://hostort/alias","","&quot

i don't know what kind of database i can use because postgres is for linux and i'd like a database for win32

i'll try to send information in a file via ftp

thank you for your help
Krogh