Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <ul> <li>use some preconfigured folder outside your webapp on the server. As it was mentioned earlier in the comments, it is not a good idea to generate them inside WEB-INF</li> <li>create servlet that will serve the content of the requested file to the user from your preconfigured folder</li> <li>you can also protect the servlet if it is needed</li> <li>the servlet can also delete the file as soon as it was delivered to the user</li> <li>alternatively, you can <a href="https://community.jboss.org/wiki/ExternalDirectories" rel="nofollow">map external folder</a> into webapp and let JBoss serve them as static content (but you need to protect the access if it is required)</li> </ul> <p>P.S. you may still do some "scheduled" cleanup in case the generated file is never downloaded.</p> <p><strong>Servlet serving the content</strong> (Answer to your comment)</p> <p>I do not see any problems with security when having external folder in your case. This external folder is only accessible in your application. </p> <p>Let's say you have a directory you generate files into (<em>FilesRootDir</em>) - /var/myapp/storage/tmp. </p> <ol> <li>Create the servlet in your webapp that knows the location of your <em>FilesRootDir</em></li> <li>Let's say the servlet is mapped to the following url (/mywebapp/downloads/file)</li> <li>To keep it simple your servlet receives as a parameter the relative path to the generated file (<em>path</em>) </li> <li>Taking the above <ol> <li>The app generates the file here /var/myapp/storage/tmp/dir1/document.csv</li> <li>and generates the link /mywebapp/downloads/file?path=/dir1/document.csv, so the user can download the file</li> </ol></li> <li>When the user decides to download the file, the request is handled by your servlet. <ol> <li>The servlet receives the location of the requested file - /dir1/document.csv</li> <li>constructs the absolute path concatenating <em>FilesRootDir</em> and <em>path parameter</em> - <em>/var/myapp/storage/tmp/dir1/document.csv</em></li> <li>Reads and outputs the content of the file to the user </li> </ol></li> </ol> <p>I believe you can apply the same security constraints to your servlet as you have it in your app, because it is a part of the application.</p>
    singulars
    1. This table or related slice is empty.
    1. POEfficient way to expose generated files in the server?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USVasyl Keretsman
    1. USVasyl Keretsman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POEfficient way to expose generated files in the server?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for your response. I don't want to create outside my webapp because if it is I have to re-write authentication code before serving the file. How exactly you are proposing a Servlet to serve the file content? Also, can I use my application authentication to serve static external files using JBoss configuration? +1 for your information on JBoss app server feature.
      singulars
      1. PO
      1. USIndoKnight
    2. CO@Indoknight see the answerto the comment in the "main answer"
      singulars
      1. PO
      1. USVasyl Keretsman
    3. COThanks I'll try this approach.
      singulars
      1. PO
      1. USIndoKnight
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload