Re: Calling java from RPG - how to increase performance

Hi Paul,
 
<snip>
Have you tried calling createNewFile() on the File object when setting up
streamResult and before doing the transform?  I'm not sure that would solve
the problem but that's what I'd try.  I don't see any
flush/close/delete/finished methods on the File, StreamResult, Result,
Transformer, or TransformerFactory classes/interfaces.
</snip>
 
This is what I can't understand. This process is almost identical to what I
did in the original RPG code (which works):
 
That is, I create a String from the result file path (byte []), I then
create a File object from the String, I then create a streamResult from the
File. The only difference is that the one that works is not nested - each
object is explicitly created before the next (and freed after). The only
difference now is that there is no object references in my RPG. The creation
of the streamResult object is only done once, and my original code can
happily transform THOUSANDS of XML documents and place the results in this
file. The SQL service program then uses an open/read combo to execute the
SQL inside after each transformation. 
 
So I can't understand why the file is created, and populated, but I can't
see it in my RPG app.
 
Even more stange is that if I try to see the file using wrklnk I can't see
it there either! Well not directly, but it is there.
 
I mean...
 
If I run the command wrklnk '/dir1/dir2/dir3/myfile.txt' I can't see the
file - I get a message saying the object does not exist.
 
However, if I run the command wrklnk '/dir1/dir2/dir3/*' I can see the file
among those listed. Using F22 over the file gives me the full file path and
it is exactly what is entered above (/dir1/dir2/dir3/myfile.txt).
 
Even more stange is that if I take option 5 to look at the contents of the
file I can see the contents BUT at the top of the screen the full file path
is missing - as though the program is referencing an object but it doesn't
know what it's called.
 
So the file exists but I can't reference it directly. What's going on? The
authority is correct (*RW data authority and full object management
authority) so it's not that.
 
Why would this happen using the java code I posted? Regardless of the RPG -
Java interactions this should not happen. How can my java code create a file
that I can't reference directly, but I can see that it clearly exists?
 
This is most puzzling. Any ideas would be gratefully received.
 
Cheers
 
Larry