Skip to Main Content

Java and JavaScript in the Database

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!

Problem with Java Stored Procedure fpr SMB Filetransfer

13952Dec 12 2003 — edited Dec 14 2003
Hello 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2004
Added on Dec 12 2003
1 comment
260 views