OAS 4.0 file locking problem

[bobbybouche]

I am running Oracle Web Application Server 4.0.8.0.1 on a Windows NT server and running Forms 6i (6.0.8.4.1 with patch 15 installed). I know this is a 9iAS forum but I was hoping somebody has had experience with the older OAS software.
We are having a file locking problem. The forms application is served up and runs but there is a problem with files that are dynamically generated by the application (via text_io from forms and a forms library(.plx)) being locked by the OWAS.
We get a "sharing violation, file may still be in use" error. If I move a different file into the same directory, I can delete it with no problem. If we shut down the Oracle Web Lsnr 4.0(

http://www-oas,<server

name>)process and start it back up then the lock goes away.

Has anyone ever experienced this problem with Oracle Web Application Server? I have been searching metalink but have not found the answer there yet. Can anyone answer this question or point me to where I might find the answer?

Thanks.

 

[bobbybouche]

I did find out the source of the problem though. It's when I use Web.Show_Document (or manually go to the URL that points to the file) to allow the user to save the file to their local PC. I am creating a text file and doing things pretty much according to the following instructions:

How to Save/Open files (doc,xls..) via Web listener at Client machine from Forms
--------------------------------------------------------------------------------
Create a virtual path in the Web listener configuration pointing to the physical location where the doc/xls files are located.

Then in Forms use WEB.SHOW_DOCUMENT with the URL referencing the file name. Assume that test.xls is located at the D:\FILES

In Web listener configuration

Physical Path Virtual Path

------------- ------------

D:\FILES /FILES/

In Forms
WEB.SHOW_DOCUMENT('

http://your_server.domain_name/FILES/test.xls');

--

The following is my specific call, using a variable containing the string below:

WEB.SHOW_DOCUMENT('

HTTP://10.52.96.136/FNSREPRINTS/007845RP.ged');

I do not include the domain name. Everything works except any file I touch using the web.show_document command becomes locked by the oraweb40.exe process forever more unless I shut it down.

--
This will submit the URL in the Browser and based on the associated MIME type,

the browser will invoke the application and prompts the user to save or open the

file.

Any Ideas, I'm running out! It should work but it doesnt. It seems like an Oracle OAS bug to me.

 

[bobbybouche]

I think I have finally found the solution to the problem. \ows\admin\<server_name>\httpd_<server_name>\

http://www\svwww.cfg

must have FileCaching = OFF instead of FileCaching = ON. This seems to solve the problem. Of course you have to shut down Oracle Web Lsnr 4.0(

http://www-oas,

<server_name>), change the FileCaching setting to OFF, save the file, then restart Oracle Web Lsnr 4.0(

http://www-oas,

<server_name>).