I have a Java class that will read the files and insert some data in the database. Currently by using loadjava command we loaded the class in the schema. Noe that class is running on the Oracle JVM(on the server). But my requirement is to pass the file from the Local machine(Ex: C:\test.txt). But the java class running on the server is searching the file in the server and throwing file not found exception.
Am unable to load the commons-net-1.4.1.jar in the schema.
What does "in the schema" mean? You seem to use that term to indicate that the code is running as part of the server; is that correct? If so, that is the wrong place for this code: Commons Net would be used for implementing the FTP client that connects to the FTP server that you said was available on the server already.
This jar depends on lot of jar. am unable to find all the dependent jars.
Try harder. The error messages you'll get for missing classes provide excellent clues.
Let's take a step back. You have a file that you want to transfer to a server that is only FTP-accessible (at least that's what you said in your 3rd post). In your 5th post you're indicating that you have a username/password for login - do you mean Telnet by that, or SSH, or FTP?
Also, do you want to transfer the file manually or programmatically?
Meet Gaurav wrote:I want to transfer the file programmatically.
Basically Server denote my Unix box. We can't transfer a file with out authentication(userid, pwd) rite.
As far as I understood you must use your ftp stuff on your client side, so no need to embed ftp client library on oracle using loadjava.
On client machine -either linux or windows- the simpliest way that comes in my mind is to use a some peice of shell script to make ftp to database server. Then you can use utl_file to access it within your database.
I promise I will be the best, most loyal friend ever! All for this tiny ad: