Insert a File into a database table using webdynpro file attachment

[Former Member]

Hi,

We are doing a project where we need to attach a file to a form and need to insert this file that i have uploaded from webdynpro into a database.The file is always associated with a job number which is unique.Can somebody help me on how to do this.We are using oracle as the database.

The steps of the process flow is:

User enters into apppliaction

attaches a file

A job number is already associated with the file.

The file should be stored in the same record as the job number which i need for the information retrieval from a different iview.

regards

swathi

[Former Member · Accepted solution]

Hi,

Make use of BLOB datatype for your Table column where the file is stored.

Following code will help you to start off with

http://www.java2s.com/Code/Java/Database-SQL-JDBC/BlobJDBCdealswithBinaryData.

Regards

Ayyapparaj

[Former Member · Accepted solution]

Hi,

I dont see the link working

regards

swathi

[Former Member · Accepted solution]

Hi,

"http://www.java2s.com/Code/Java/Database-SQL-JDBC/BlobJDBCdealswithBinaryData.htm"

add .htm to the previous link.

Regards

Ayyapparaj

[Former Member · Accepted solution]

Thank you this helped me a lot.Assigned points