Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mod_plsql adding expires header ???

Henrie CuijpersJun 4 2013 — edited Jun 4 2013

Hi all,

i'm developing mod_plsql applications since a long time.. I use the document-procedure to fetch a document in a complex way, but at the end it is a sort of

procedure myDocumentProc is
  ...
begin
  sPathInfo := owa_util.get_cgi_env('PATH_INFO');
  ..
  do some nice stuff to get a nDocnr and check autorisation...
  when everything is ok: 
  ..
  select blob_content,mime_type into bLob,sMime from myBlobTable where doc=nDocnr;
  owa_util.mime_header( sMime );
  .... point X
  wpg_docload.download_file( bLob ); 
end;

What i'm experiencing is that if PATH_INFO contains .png or .jpg (maybe there are more extensions) there is automagicly added a Expires: header to the response....

Can someone confirm this, and better: how can i TURN THIS OFF??? please!!

I would like to turn this of because at point X in the code i would like to calculate and add an Expires header myself. I know exactly how long I would like a certain file to be cached. What happens at this moment that when i add an Expires header, most of the request return fine, but when mod_plsql (is it mod_plsql???) does its little magic i end up with an Expires header with two dates in it. Which is wrong....

Example Wrong header:

Expires: Tue, 11 Jun 2013 10:26:53 GMT, Tue, 04 Jun 2013 18:26:53 GMT

The first date is the one i calculated and added as a header, the second date is the date added by some magic.... somewhere...

BTW this is on a webtier 11.1.1.6 and oracle DB 11.2.0.3.0

i'm running the webtier only:

./opmnctl status

Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
ohs1                             | OHS                |   31505 | Alive

and the PlsqlCacheEnable is set to Off

Edited by: hcHoep on Jun 4, 2013 12:50 PM

Sdas-Oracle

You can do this from a SQL query using SEM_MATCH table function which allows you to specify a SPARQL graph pattern.
SEM_MATCH retrieves relevant data from the RDF store which can then be joined with one or more relational tables.

For more details on use of SEM_MATCH, please refer to documentation at:
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sdo_rdf_concepts.htm#CHDJACII

880207

Hi,

I am using Jena & SparQL. I am not sure if i can call SEM_MATCH query directly from Jena. As per my understanding Sparql gets converted to SEM_MATCH query.
As i am calling Sparql query using Jena, I want to use RDBMS table data also with sparql query in a single query.

If possible , kindly share an example , it would be of great help

Thanks and Regards,
Manish H

880207

Any view on above comment

Sdas-Oracle

Use of SPARQL from Jena does not currently allow access to relational tables. A workaround you may consider trying would be to first generate RDF triples from the relational tables and then try querying using SPARQL the original RDF data plus the RDF data generated from relational tables.

1 - 4

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2013

Added on Jun 4 2013

#application-servers, #oracle, #oracle-application-server-general, #server

0 comments

249 views

Integration

mod_plsql adding expires header ???

Comments

Post Details