JBDC Request results
I have a JDBC request that is returning the following: <Results> <ResultSet fetchSize="10"/> </Results> It relies on a DataSource that only returns one row. If I run the DataSource manuall...
Forum Discussion
I really appreciate you trying to help me but the issue has nothing to do with the SQL statement in the DataSource. It works as it should.
After the DataSouce, I have 2 Property Transfer steps that work as they should. One passes the value to the GET REST step correctly and the GET REST step returns the correct XML. The other passes the value to the JDBC Request correctly (or so it seems) and the JDBC Request returns incorrect XML. See sample below:
<Results>
<ResultSet fetchSize="10"/>
</Results>
So I'm getting closer. I think that it has something to do with the SQL in the JDBC Request because the :partyNumber variable needs to be in quotes. I'm going to try to figure that out.
After the DataSouce, I have 2 Property Transfer steps that work as they should. One passes the value to the GET REST step correctly and the GET REST step returns the correct XML. The other passes the value to the JDBC Request correctly (or so it seems) and the JDBC Request returns incorrect XML. See sample below:
<Results>
<ResultSet fetchSize="10"/>
</Results>
So I'm getting closer. I think that it has something to do with the SQL in the JDBC Request because the :partyNumber variable needs to be in quotes. I'm going to try to figure that out.