Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

JDBC timed data push

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
tbboyett
Asked:
tbboyett
  • 2
  • 2
2 Solutions
 
contactkarthiCommented:
you can do it using timer in util package

http://www.exampledepot.com/egs/java.util/ScheduleLater.html
0
 
contactkarthiCommented:
0
 
lesouefCommented:
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
 
tbboyettAuthor Commented:
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
 
lesouefCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now