• Post Reply Bookmark Topic Watch Topic
  • New Topic

Pulling values from SQL Server

 
Pol Appan
Ranch Hand
Posts: 144
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65661
129
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not even remotely JSP related, so off to the JDBC forum this goes.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 35977
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!