Releases: jlolling/talendcomp_tDBTableTransfer
Tolerant field matching
Handling of errors fixed
Prevent problems in case the component runs inside a loop and die-on-error is off.
In this case it was possible the component runs in a deadlock because the former resultset for the metadata are not already closed.
Now the component waits 1s to prevent this.
Error messages over all kind of database types unified.
More none-SQL-standard chars identified for the enclosure of identifiers.
Fix problems with using model cache
Caching model cache works now in a way, there is none interference between different job runs.
Performance improvements
The loading of the data models can now be cached even if the job loads different tables.
Enable fields starting with numbers and have dots
Yes, I could it also hardly belief but some guys build tables with field-names starting with numbers. Actually not allowed but with enclosures it is possible. And yes I had the "pleasure" to work with.
This release 13.3 of this components checks that and takes care it will not become a problem.
Also fields can have now dots in the name - yes this also happens. Hard to belief.
Bug solved: Component fails if Logging is in DEBUG mode
Bug solved: Component fails if Logging is in DEBUG mode
Setup keywords implemented
Keywords can now be configured as comma separated string.
Improved error messages when writing into target table failed.
Improve behaviour for Date and Timestamp fields
All Date and Timestamps will be processed now in the target as Timestamps to allow always the transfer of time.
Fetch field from query improved
For PostgreSQL and MySQL and MariaDB the component recognizes now better the alias of fields.
For fixed values with Date type it is now not necessary to create a java.sql.Date anymore. The component converts a java.util.Date themself.
Improvements for MySQL/MariaDB
The component now works also for the latest version of MySQL driver.
The setup for streaming results is now independent of the driver version.
The setup also now works for other connection pools.
The dependency to the PostgreSQL and MySQL driver is removed.