Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

“java.lang.ClassNotFoundException: cs/jdbc/driver/CompositeDriver

1048687Apr 18 2016 — edited Apr 19 2016

Dear team,

We have uploaded  a java class into the apps schema of database and uploaded the custom jar file which the java class refers to the apps schema of the database.

Custom jar file csjdbc.jar is uploaded using the loadjava utility from windows.

loadjava  -verbose -resolve -user username/pwd@servicename  -jarasresource csjdbc.jar

pls/sql function invokes the java class  and when function is called from anonymous block we are getting error

"java.lang.ClassNotFoundException: cs/jdbc/driver/CompositeDriver".

cs/jdbc/driver/CompositeDriver is the class file in the custom jar file.


When we query in the apps schema of the database server we can see a record

select * from all_objects where object_name like 'csjdbc.jar' and object_type like 'JAVA%';


Can you please suggest whether we need to add any entry to classpath.


thank you

Comments

user434854
Is a Parameter list beeing transmitted to the report ?

If yes, try :

ADD_PARAMETER(v_list_id, 'PARAMFORM', TEXT_PARAMETER, 'YES');

Maybe you need to explicitely set this parameter in the report when calling it through the run_report_object built-in.
1 person found this helpful
708420
A parameter list is not currently being sent, but i can try to create a parameter list and send the one you suggest. I'll see how that works.

Thanks!
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 17 2016
Added on Apr 18 2016
15 comments
2,275 views