Hi absig, this is a special behavior of PostgreSQL database. Indeed if a statement within a transaction failed, the current transaction is unusable until now. This current connection can only be used after a commit or rollback. Please try this: Use a separate tPostgresqlConnection and set the option to auto commit.
... View more
Hi below a bug (related in 2010 by an other person) and i have the same problème (tos 4.2.2 or TOS 5.0 with Postgresql 9.0). It is very important to can update some record and have a reject fux. For this elementary task i hope talend fix the bug in 2012 or 2013 or 2014 ...;) Can someone have the same problem or a solution? For me using batch with 1line don't work. Thanks; The bug : Hi, I want to insert rows in an PostgreSQL database having rejected row to be log in a special file. I'm using a tPostgresqlOutput with "commit every" 10000, "Die on error" false. When an error occurs on "insert", all the following rows are rejected with the following message "current transaction is aborted, commands ignored until end of transaction block" While using tOracleOutput I don't get this kind of error. I can counter this by setting "commit every" to 1, but is there any other way to save "commit" and go through first SQL error? --My config : TOS 4.0.2.r43696 PosgreSQL Database Server 8.2
... View more