| 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: 56191
|
|
|
Not even remotely JSP related, so off to the JDBC forum this goes.
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
|
|
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26184
|
|
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
|
|
 |
|
|
subject: Pulling values from SQL Server
|
|
|
0
