Forum Discussion

Stefan1's avatar
Stefan1
New Contributor
4 years ago

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

  • PrathapR's avatar
    PrathapR
    Frequent Contributor
    4 years ago

    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's avatar
      richie
      Community Hero
      4 years ago
      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
      • Stefan1's avatar
        Stefan1
        New Contributor
        4 years ago

        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.