Limit of 8000 in SQLServerBulkCopy class provided in JDBC 4.2
I am using the latest version of SQL Server JDBC driver (4.2) and when I am trying to copy a table which contains binary data from Oracle to SQL Server it is throwing the following error.
The size (2147483647) given to the column 'IMAGE_DATA' exceeds the maximum allowed for any data type (8000) .
How can I handle copy of large data (LOB) using the new SQLServerBulkCopy class?
September 14th, 2015 1:34am
What is the datatype of column 'IMAGE_DATA'?
September 14th, 2015 2:27am
BLOB in Oracle
September 14th, 2015 12:31pm
Well, I mean the target column in SQL Server, as you're trying to export an blob type into sql server, in SQL Server it should be varbinary(max) or other lob data type like varchar(max).
September 14th, 2015 9:18pm
I tried with both Image and varbinary(max) and it did throw the same error. Do I need to specify the datatype in my
September 15th, 2015 1:39am
Other recent topics
