Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

JDBC timed data push

Posted on 2007-11-29
5
Medium Priority
?
238 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 750 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 750 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this article, we’ll look at how to deploy ProxySQL.
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

715 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