How to write a file as into a database field of type VARBINARY?

0	I would like to write a File in a varbinary field of a database table. How do I implement this? ivy3 asked 02.02.2010 at 00:52 Roman Stalder (suspended) accept rate: 0%

3 Answers:

active answers oldest newest most voted

0	At the moment it is not easily possible with Xpert.ivy 3.x. You can write an own PI to implement this. link answered 03.02.2010 at 03:25 Reto Weiss ♦♦ 4.9k●20●28●57 accept rate: 74%

In Xpert.ivy 5.x, does it support for this?

link

answered 22.01.2014 at 12:29

nndiep
(suspended)
accept rate: 0%

Yes in ivy 4.x and 5.x it's possible. Just make e java methode write an insert query. Create a preparedStatment and insert the file into the database with a fileInputStream.

Maybe you sould open a new question with another tag then ivy3

(22.01.2014 at 15:32) Raphael Bürgin

I remember that I've done this in ivy 3.x

Load the file into a ivy-attribut with type File
Encode the file in a String Attribut -->in.Temp.str3 = in.File.Bild.getFileContentBase64Encoded()
Write a Sql-Query in DB-Step UPDATE FileTable SET file=CAST(in.Temp.str3 as varbinary(MAX))

link

answered 23.01.2014 at 10:24

Raphael Bürgin
(suspended)
accept rate: 55%

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "Title")
image?![alt text](/path/img.jpg "Title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

ivy3 ×24

Asked: 02.02.2010 at 00:52

Seen: 3,122 times

Last updated: 23.01.2014 at 10:24

How to write a file as into a database field of type VARBINARY?

Follow this question

Related questions