How can i save a pdf file in oracle 12c database from j2ee webapp

Question

I'm developping a J2EE web app, i have to save a pdf file in oracle database (oracle 12c) .

• I need the type of the attribute (like varbinary in sqlserver).
• How to do it with java.
  • Save the pdf to the database .
  • Export it from the database to my webapp.

The file it will be uploaded by user. I would like some advices too like if its better to save the pdf in database like binary , something else or just the path. any information or idea will be very interesting for me .

Answer 1

First thanks to Giovanni the type is BLOB. How to do it:

• Example for storing blob data : visit http://www.java2s.com/Code/Java/Database-SQL-JDBC/StoreBLOBsdataintodatabase.htm .

• Example for reading blob data from database: visit http://www.java2s.com/Code/Java/Database-SQL-JDBC/ReadBLOBsdatafromdatabase.htm .