Solved

JDBC timed data push

Posted on 2007-11-29
5
216 Views
Last Modified: 2010-03-30
What is the best way to set something up to do a JDBC nightly push of selected information from a MySQL database to a FileMaker database?

Would I need to set up some kind of Timed Thread or something to do this?
0
Comment
Question by:tbboyett
  • 2
  • 2
5 Comments
 
LVL 17

Expert Comment

by:contactkarthi
ID: 20373820
you can do it using timer in util package

http://www.exampledepot.com/egs/java.util/ScheduleLater.html
0
 
LVL 17

Accepted Solution

by:
contactkarthi earned 250 total points
ID: 20373830
0
 
LVL 28

Expert Comment

by:lesouef
ID: 20373942
where is the filemaker database? on a stand alone fmaker, or on a fm server?
the easiest way to do it, is to use a fake fmbase with just a script triggering the backup script in the main file at its own startup, and have a scheduled or croned task to lauch fm with this fake file.
0
 
LVL 5

Author Comment

by:tbboyett
ID: 20373988
thanks for the replys!

lesouef, i'm fairly new to the world of filemaker so i don't really follow some of your recommendation but the filemaker database is on it's own server.  do you know of any links to where i can find information of what you are describing?  

thanks again for all the help guys
0
 
LVL 28

Assisted Solution

by:lesouef
lesouef earned 250 total points
ID: 20374241
it is on a fm server...
 which version, standard, or advanced?
advanced can read an odbc source at the server level and has schedule capabilities to trigger an external source while the regular can't; in this case you must use a fm client to do the transfer. but this client can reside on the server's machine.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Facing this issue for maven proxy setting 2 20
Change size 15 53
CLI command keep running after close 7 36
check mysql insert 12 27
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Creating and Managing Databases with phpMyAdmin in cPanel.
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
The viewer will learn how to implement Singleton Design Pattern in Java.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question