topic Re: Convert an Oracle Blob to MSSQL Varbinary field in Talend Studio

Convert an Oracle Blob to MSSQL Varbinary field

KPB — Fri, 15 Nov 2024 23:15:55 GMT

Does anyone have any idea how to move a blob from an oracle database to a varbinary field in a microsoft sql database?

Right now if I try doing it through tmap I get an error: java.sql.SQLException: Unable to convert between oracle.sql.BLOB and JAVA_OBJECT.

at net.sourceforge.jtds.jdbc.Support.convert

In tmap it lists the types for both the blob and varbinary as "object"

I didn't find anything recent (last 5 years) here by searching so I thought I'd post and see if anyone had any ideas.

Thanks.

Re: Convert an Oracle Blob to MSSQL Varbinary field

Anonymous — Fri, 28 Jan 2022 00:59:16 GMT

I can't test this as I don't have the databases available BUT I suspect that this is connected to the fact that the blob will be returned as an Object. So, the first thing I would try would be to cast the column to a oracle.sql.BLOB and then retrieve the bytes from that. Following that, load the byte array to the SQL Server table.

In the tMap try this in the output column feeding the Varbinary column....

((oracle.sql.BLOB)row1.blobcolumn).getBytes()

As I said, this is just the first thing I would try. Let me know if it works.