RE: Using Apex display files

  • From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
  • To: <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 12 May 2015 10:40:50 -0400

Thank you Rich,
I have not configured Oracle REST Data Services or Tomcat. I am using the
embedded pl/sql gateway for apex. I am not concerned about the direct
linking as the filenames are not readable or sequential
(01adf5ce-f17f-44b0-82fa-67edf0f318fd.tif) so guessing a file name is really
difficult and any employee that has access will have access to everything.


Ken

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Rich Jesse
Sent: Tuesday, May 12, 2015 9:13 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Using Apex display files

Hey Ken,

1. Is it better to load all 200k files (pdf, jpeg, tiff etc., about
60g total - average size 300k each ) into the database as blobs and
display them from the database? Or is it better to leave them on the
file system? is there a way to bulk load all 200k files? I searched
and could find a document that was clear guide to doing so, anything I
found assumed too much prior apex knowledge.

"better" is subjective, but in this case "easier" may be a winner.
Filesystem is the way I'd go, provided that doesn't cause issues with your
customer (e.g. files could be directly linked w/o going through the app).

2. How would I display the file if stored as a blob?

Not needed if filesystem is used. :)

3. How does Apex recognize the file to be able to display it? I
tried
using http://servername/drive/path/file1.pdf but all i get is a 404
error. I assume there has to be some configuration so apex knows which
directory they are in and to server.

The URL is likely being handled by your webserver and not by APEX. Think of
APEX as a webapp run by your webserver. The PDF URL you have is more like a
simple JPG file, which Apache or whatever you're using will handle. So this
would likely be a webserver configuration issue.

Speaking of which, have you configured REST Data Services and Tomcat, or are
you using another method for serving up APEX pages?

Rich


--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2015