Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes Pulling values from SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Pulling values from SQL Server" Watch "Pulling values from SQL Server" New topic

Pulling values from SQL Server

Pol Appan
Ranch Hand

Joined: Aug 26, 2004
Posts: 144

I want to pull values from SQL Server to Oracle database frequently.
How can I do this, the problem is I want to deploy the application in
Sun Solaris server, so what kind of driver I need to use to deploy to
Solaris server?

Can I have a timer or some kind of mechanism to check and pull and update the oracle database?

Any help is highly appreciated.



Never take anything for granted because you never know when you will lose it
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63548

Not even remotely JSP related, so off to the JDBC forum this goes.

[Asking smart questions] [About Bear] [Books by Bear]
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32823

You could use a batch/cron job on the server.

In Java, you could use a threaded application (that sleeps for a specified amount of time.) In J2EE, you could use the Timer API.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Pulling values from SQL Server
It's not a secret anymore!