Hi Guilherme, You can check this example: https://github.com/DataTorrent/examples/tree/master/tutorials/jdbcToJdbc Also for your usecase, you will need to override getUpdateCommand() method and put the statement as per your need.
-Priyanka On Tue, Jun 13, 2017 at 3:51 AM, Guilherme Hott <guilhermeh...@gmail.com> wrote: > Thanks, I did it. But I have to use "INSERT .. ON DUPLICATE KEY UPDATE > ..." because in the test is using "MERGE..." and it's not supported by > mysql. > > > > On Mon, Jun 12, 2017 at 12:49 PM, Sanjay Pujare <san...@datatorrent.com> > wrote: > >> Not an example but there is a test for that operator >> https://github.com/apache/apex-malhar/blob/master/ >> library/src/test/java/com/datatorrent/lib/db/jdbc/JdbcPo >> joOperatorTest.java which might be useful? >> >> On Mon, Jun 12, 2017 at 11:08 AM, Guilherme Hott <guilhermeh...@gmail.com >> > wrote: >> >>> Nice, yeah, an example will be helpful. Thanks a lot. >>> >>> On Mon, Jun 12, 2017 at 10:27 AM, Sanjay Pujare <san...@datatorrent.com> >>> wrote: >>> >>>> There is an operator https://www.datatorre >>>> nt.com/docs/apidocs/com/datatorrent/lib/db/jdbc/JdbcPOJONonI >>>> nsertOutputOperator.html . >>>> >>>> Did you want an example about how to use it? >>>> >>>> >>>> On Mon, Jun 12, 2017 at 9:16 AM, Guilherme Hott < >>>> guilhermeh...@gmail.com> wrote: >>>> >>>>> Hi guys, what is the best solution for a jdbc update output operator? >>>>> >>>>> Best >>>>> >>>> >>>> >>> >>> >>> -- >>> *Guilherme Hott* >>> *Software Engineer* >>> Skype: guilhermehott >>> @guilhermehott >>> https://www.linkedin.com/in/guilhermehott >>> >>> >> > > > -- > *Guilherme Hott* > *Software Engineer* > Skype: guilhermehott > @guilhermehott > https://www.linkedin.com/in/guilhermehott > >
