Hi,
my graph consists of 2 phases. In phase 1 I use a DataReader to read records from a CSV file and write them to a database by using the DBOutputTable component. But I only want to commit the data if no error occurs. So I set the error action of the DBOutputTable to rollback and the records in commit to MAX_INT. In the second phase I use a DBExecute that just executes a commit. Unfortunately this does not work. Even if both phases passed without any errors there were no records committed. Any ideas how to solve this?
database is postgreSQL 8.3, I have to use the DBOutputTable component, PostgreSQLDataWriter is no alternative.
my graph consists of 2 phases. In phase 1 I use a DataReader to read records from a CSV file and write them to a database by using the DBOutputTable component. But I only want to commit the data if no error occurs. So I set the error action of the DBOutputTable to rollback and the records in commit to MAX_INT. In the second phase I use a DBExecute that just executes a commit. Unfortunately this does not work. Even if both phases passed without any errors there were no records committed. Any ideas how to solve this?
database is postgreSQL 8.3, I have to use the DBOutputTable component, PostgreSQLDataWriter is no alternative.
-
Hello,
you have to set attribute threadSafeConnection="false" in your connection. In other case you call commit on different connection instance (while each component creates its own instance of db connection - see DB Connection).
Please sign in to leave a comment.
Comments 1