aspose file tools*
The moose likes JDBC 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
Bookmark "Pulling values from SQL Server" Watch "Pulling values from SQL Server" New topic
Author

Pulling values from SQL Server

Pol Appan
Ranch Hand

Joined: Aug 26, 2004
Posts: 144
Hello,

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.

Thanks

Ponic


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

Joined: Jan 10, 2002
Posts: 60057
    
  65

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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29249
    
139

Cosmos,
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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Pulling values from SQL Server
 
Similar Threads
Pulling values from SQL Server
Storing data that changes
SQL Server To Oracle
Check Database is running / not
web app authentication: users from oracle database.