Solved

JDBC timed data push

Posted on 2007-11-29
5
230 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

627 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