• Index
  •  » Talend Open Studio for Data Integration » Component creation
  •  » Multiple Row out with SQL Connection

#1 2012-03-10 01:17:41

andmattia
New member
Registered: 2011-08-03
Posts: 1

Multiple Row out with SQL Connection

Hi all,

I lost some days to try to solve this issue:
I develop a component to read data from weservice (XML Path) and I works fine only if the record founded is only 1 with sql connection.
so, in some case I need to create more than 1 output rows and in this case I intercept a SQL Exception that says me "ResultSet object is closed". I try to create a FOR in main and close the cicle on the END javajet but I catch this exception. I try to move the and of cicle from END to MAIN and the component works fine but I have only 1 row output.

I some test I see a strange situation: if I move the end of cicle in END javajet and conntect my component to tRowGenerator it's work fine and generate more than 1 row but if try to change my source from tRowGenerator or tFixedFlow it's work's fine.

Any idea???

thank to all.

Mattia

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Component creation
  •  » Multiple Row out with SQL Connection

Board footer

Powered by FluxBB