Solved

JDBC timed data push

Posted on 2007-11-29
5
214 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
use lov values 2 50
Excel - SQL export question 3 41
possible to record changes (trigger I think) msql 11 35
Java string replace 11 46
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…

773 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