[JAVA] Generating a pdf file and saving it in oracle database, the retrieve

[eliokh]

Hello,

I have the following task:

1- Generate a pdf file in java using a certain library (probably i-text).

2- Save the generated file to a database

3- Retrieving an already saved file from the database and sending it to a client via HTTP.

I have the following questions:

1- Is it possible to save the generated file in the database (in a BLOB) directly WITHOUT physically creating it?'

2- Is it possible to read the file from database and send it to the user as object, without saving it physically on the server?

I know we can save them in a temporary directoty but i prefer not to have anything physical.

Currently i can do save a PHYSICAL file in DB, and retrieve a blob column into a PHYSICAL file from DB.

thank u in advance

[Kami-]

1. Yes

2. Yes