topic Re: String to Blob with TJdbcOuput and Oracle driver in Talend Studio

String to Blob with TJdbcOuput and Oracle driver

_AnonymousUser — Sat, 16 Nov 2024 11:40:35 GMT

Hello,
I have a long input String and need to save it into Oracle database via JDBC.
When i look convert TalendType to get blob in database i see : Id_Object => Blob
Someone could say me please how construct this object from a String ?
Regards

Re: String to Blob with TJdbcOuput and Oracle driver

Anonymous — Thu, 01 May 2014 06:46:13 GMT

Hi,
Need to convert your input string to byte[]
Then insert this byte to BLOB column. Pl refer...
https://community.talend.com/t5/Design-and-Development/Inserting-BLOB-or-CLOB-data-into-a-database/ta-p/21688?content-lang=en
earlier I have inserted a CSV file into MySQL BLOB. I can read the contents of file in BLOB column.
Vaibhav

Re: String to Blob with TJdbcOuput and Oracle driver

_AnonymousUser — Tue, 13 May 2014 10:28:07 GMT

Thanks, with Mysql you can do as this but TOracleOut need data type Object not byte[]

Re: String to Blob with TJdbcOuput and Oracle driver

Anonymous — Tue, 13 May 2014 11:04:30 GMT

In the referred routine java code, convert to Object in place of byte[].
Is there any other problem?
Vaibhav

Re: String to Blob with TJdbcOuput and Oracle driver

_AnonymousUser — Tue, 13 May 2014 14:46:05 GMT

Yes , but what kind of of Object? How construct this object?

Re: String to Blob with TJdbcOuput and Oracle driver

_AnonymousUser — Wed, 04 Jun 2014 16:46:28 GMT

Finally it works with myString.getBytes()
Thanks and regards