Member Avatar for a_iyer20

Hello,

I have a requirement to fetch data from a database and store into another database. More explanation goes as follows:

I have a web application deployed on an application server. The JDBC connection fetches data from a oracle database. Now I have a need to fetch data from a remote database
(that is not the database of my application) and store some data into my current application's database.

The data should be fetched periodically and a scheduler needs to be designed so that every 1 hour data is fetched and the current database is updated.

From my own research, I found some info in this link:

http://www.devx.com/Java/Article/29873/

Also, refer to the attachment for the source code for the above link.

Please let me know how I can design and implement such a solution.

Thanks,
Ashok.

14339.zip (15.95 KB)
  • 3 Contributors
  • 2 Replies
  • 101 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for peter_budo

Ehmm, you just have to do what is in tutorial. Did you actually look at it?

Member Avatar for jwenting

I've a feeling that many schools these days have homework assignments like "get someone on the internet to make XXXXX for you", where only XXXXX differs between assignments.

It's the only explanation I can think of for the flood of homework kiddos out there.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.