When trying to import a CSV file to an oracle database using the same basic structure as the SQL example that is provided with Javelin the import fails with the following Error:
Error 1:
2020-07-09 08:04:47 - Variable Name = Username Value = CA_UIM_902
2020-07-09 08:04:47 - Variable Name = ServiceName Value = pdborcl
2020-07-09 08:04:47 - Variable Name = Port Value = 1521
2020-07-09 08:04:47 - Variable Name = BatchSize Value = 0
2020-07-09 08:04:47 - Variable Name = NotifyAfter Value = 0
2020-07-09 08:04:47 - Variable Name = BulkCopyTimeout Value = 600000
2020-07-09 08:04:47 - Variable Name = DestinationTableName Value = TestCases
2020-07-09 08:04:47 - Variable Name = ColumnMappings Value =
2020-07-09 08:04:47 - Variable Name = AdditionalConnectionParameters Value = <NULL>
2020-07-09 08:04:47 - Variable Name = Timeout Value = 0
2020-07-09 08:04:47 - Error executing Idata reader push into Oracle : The type initializer for 'Oracle.DataAccess.Client.OracleBulkCopy' threw an exception.
Version and path issues.
Original version:
Windows 2016
Javelin (2.x) ( default installed with 4.9 TDM release)
Update to Javelin 64-bit 8.4.x
ftp://tdmpuser:[email protected]/TDM/Javelin/Javelin-4.8.109.0.zip
Update to the latest GTODACDeployer 4.126.X
ftp://tdmpuser:[email protected]/TDM/GTODACDeployer/GTODACDeployer-4.126.0.100.zip
add the odac64 directory to your environment path.