Full disclosure -- I am a PL/SQL developer. I write a small amount of Java-by-Google when I need to perform some function in the database that isn't possible via PL/SQL alone. In this case, I am trying to load the Apache POI classes into Oracle so that I can (eventually) write a package that will allow me to update existing Excel files using PL/SQL package with Java in the background. I mention this because while I have coded with PL/SQL for 20+ years, there is nothing that can be done wrong about loading JAR files via loadjava that is so incredibly stupid that it's impossible for me to be doing it.
I'm using Oracle 11.2 Standard Edition and loading JAR files from the latest version of Apache POI (3.17). I'm using the following three commands to load the files into the database. The first generates a handful of 'unable to resolve' errors. The second two get the error on essentially every class being loaded. I don't have any idea where to even start on determining what dependencies that I'm missing that could be causing the errors. Any assistance would b greatly appreciated.
loadjava -r -user [username]/[password] -verbose commons-codec-1.10.jar
loadjava -r -user [username]/[password] -verbose poi-ooxml-3.17.jar
loadjava -r -user [username]/[password] -verbose poi-3.17.jar