Problem with Java Stored Procedure fpr SMB Filetransfer
13952Dec 12 2003 — edited Dec 14 2003Hello everybody,
I wrote some java methods to enable a oracle db that runs on a unix box to copy files that reside on Windows Servers.
I use the jcifs Java Package to get the SMB Protocol Layer.
Everything works fine in a IDE Environment with a JRE 1.3. 1 which it should be equal to JRE in Oracle (Sorry it is Eclipse not JDeveloper ;-) )
I can copy Files from local to smb from smb to smb ...
I wrote a little Test in the main method of the class.
Step1: Copy a local File to the SMB Filesystem
Step2: Copy the file from one directory on the smb filesstem to another directory in the smb filesystem.
Step3: Copy the file from smb filesystem to local filesystem.
Step4: copy from local to local filesystem.
No Problem in the IDE.
So I load the classes into the DB and write PL/SQL Wrappers.
If I try to run the four steps
in one session, step 1 and 2 complete successfully.
Step 3 raises a SMB Exception Timeout waiting for response from server and exists the test.
If I run all 4 steps in separate sessions one after the other, everything works fine as in the Java IDE.
So I don't think it is a problem of my java sources.
I had to grant some java Security Properties
which are:
java.util.PropertyPermission
name: *
action: read,write
java.net.NetPermission
name: specifyStreamHalndler
action:
I also granted javasyspriv,javauserpriv and java_admin to my Java owner, but nothing helped.
I'm not very experienced in java, so I'm sure for the Java pros this is a simple problem.
Any hints??
I can post the sourcecode if necessary or interesting!
regards
Detlev