Problem to execute a stored procedure with sybase on Talend Integratio

[Anonymous]

Hi,
We have a problem to execute a stored procedure with sybase on Talend Integration Suite Professionnal Edition 4.2.4.
We want to execute a Sybase stored procedure with a date in entry to update several tables values. We use in our job a tsybase connection, tsybaserow to "set chained off" and trowgenerator to generate the current date (TalendDate.formatDate("MM/dd/yyyy",TalendDate.getCurrentDate()) with the object tSybaseSP to launch the stored procedure (with our current date as IN parameter).
Finally we have a tsybasecommit to save the changes.
The procedure is running (during 10 minutes) but the tables are not updated.
When we launch the stored procedure with RapidSQL, the tables are updated.
The problem comes about Talend. Is there specials parameters to add or something wrong in our job ?

The parameter requiered in entry of our procedure is :
"Parameters in entry:     - @adt_end   (MM/DD/YYYY)  : End Date treatment"
 
Best regards

[Anonymous]

Anyone has already encountered this problem and could help us, we don't find a solution or an alternative which works

Thanks.

[Anonymous]

Hello,
I got the same issue where the SP updates tables. Solve it.
tSybaseConnection_1 --> tFixedFlowInput --> tSybaseSP -> tSybaseCommit
check Auto Commit on Advanced settings of tSybaseConnection
uncheck "Close Connection" of tSybaseCommit
Hope it helps
Lalaina