I have the need to setup a mirrosync so to keep updated a duplicate db of a 4D served application so to further send out some data to a mysql application, someone have already made some experience in keep synched 4D and FMS? I'm truly newbie in this ... thanks in advance and sorry for bad english. BR Sincerely

 

Carlo

If there is a JDBC driver for 4D then yes, we should be able to sync it with FileMaker.

However, I'm not sure that any JDBC driver exists. I see an old 2004 press release about it here (http://www.businesswire.com/news/home/20040316005800/en/4D-Releases-Free-JDBC-Driver-Java-based-Connectivity), but the download link from that page goes to a 404 error. If you're able to find a JDC driver and would like our assistance setting this up, we can do this at our standard hourly rate of $185/hour.

HTTP://doc.4D.com/4Dv16/4D/16-R4/4D-ODBC-Driver.100-3454244.en.html

seem that jdbc exist

 

Thanks for replying

 

carlo

ODBC and JDBC are not the same thing - let me know if you find a JDBC driver

I knew that but using an odbc-jdbc bridge can do the work? 

Kinda maybe sorta... ;-)

I've never used the JDBC-ODBC bridge, and it sounds like it's been removed in Java 8: https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html

With that said, MirrorSync can work with Java 7, so if you want, we could try to help with this setup. We'd need to bill for our time, and I can't make any promises that it would work. If you'd like to proceed, let me know and I'll get you in touch with Sterling, our project manager.