cancel
Showing results for 
Search instead for 
Did you mean: 

Save pdf file from Oracle Database with jdbc step

Stefan1
New Contributor

Save pdf file from Oracle Database with jdbc step

Hi everybody,

 

is there any possibilty to save/download a pdf file, stored in a Oracle Database with a jdbc step?

 

Thanks in advance

3 REPLIES 3
PrathapR
Frequent Contributor

Re: Save pdf file from Oracle Database with jdbc step

Hey @Stefan1 ,

 

After you connect to DB using jdbc step and if you run query to retrieve the pdf file, how the pdf file is pulling response(as attachment or some other way?)?

 

Thanks!

richie
Community Hero

Re: Save pdf file from Oracle Database with jdbc step

Hey @Stefan1,

I'm curious about this.

I know Oracle altered its DB architecture from purely relational to object oriented/relational about version 9 so i think oracle extended the blob datatype that supported storing of bitmaps, images, files, etc., but soapui returns its query results in xml format.

Are you talking about reading the content of the data or just retrieving something that is returned if you query the blob column that contains the .pdf?

Ta

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Stefan1
New Contributor

Re: Save pdf file from Oracle Database with jdbc step

Hi @richie,

 

thanks for the advice.

It's correct what you say. The data is stored as BLOB in the Database.

 

Additionally a little button in the database editor allows me to download that data as pdf file, and that is what I would like to receive in SoapUI.

 

 

New Here?
Join us and watch the welcome video:
Top Kudoed Authors