If you don't have to do it in Java but can work in Eclipse, try IRI NextForm (DB Edition) to set a time-based query condition in the input phase of the job and direct the target rows into MySQL via its ODBC method. If the tables are massive though, write a similar query in the config file of IRI FACT (Fast Extract) for Oracle. Use IRI CoSort to filter, pre-sort, etc. and then bulk-load MySQL with a named-pipe output from CoSort.