Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Download data from server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Download data from server" Watch "Download data from server" New topic
Author

Download data from server

vishwas madhuvarshi
Greenhorn

Joined: Jan 21, 2001
Posts: 16
I am working on a website where data is posted from 12 branch offices and viewed from head office in form of generated html reports on daily bases. The data has to remain on server for one month after which, it is to be downloaded at headquarters and the database at HQ has to be updated with this downloaded data. I want to know how this downloading and updation of database can be done. The database being used is Oracle.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
hello there well ur problemisnot so big but here is the answer:
First take the data into a servlet(in resultset).
prepare a table in html and show the data from servlet. thats it. For Transfering the Database first u have to store all that in a servlet. Then according to the data in the resultset transfer it into a hash table. Again update or create a same database on the server side.(It is important to convert it into an hashtable or enumeration etc.)
<To run the program timely or weekly automatic>.
Check system date ofthe server to run this servlet. it can be possible through win nt. It may be there in the office. orin the server.if it is not in the server side then it will be linux server. it is same with unix.(through shell programming).
All the best.
bhanu and mandeep
for rest of the queries send mail to us
bhanuxyz@yahoo.com
mandeepmehra100rediffmail.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Download data from server
 
Similar Threads
Uploading and downloading data from excel sheet
Update Client DataBase with data on Server
DownLoad to Client Machine
Data Download from server
Download file on client machine by user request