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!

Loadjava invalid classes on DB - can't recompile

PeterValencicJun 23 2015 — edited Jul 1 2015

Hi,

I don't know what happened that I get invalid classes on my database..

I have uploaded JAR file several months ago with loadjava and recompile classes on database side and all worked ok..

Now the classes are invlaid...

screenshot_179.jpg

I tryed to drop all classes and repeat the procedure with load java... with:

c:\loadjava -force -genmissing -grant r_inis_prod -user insurance2/i@MYDB -verbose C:\iText-2.0.7.jar

screenshot_176.jpg

If I look in Toad I get: 398 invalid classes...

screenshot_178.jpg

How to "recompile" this classes?

I have also used this approach:

select 'alter java class '||'"'||object_name||'"'|| ' compile;'

from user_objects

where status <> 'VALID'

And object_type ='JAVA CLASS';

But It's not working...

thank you for any help...

This post has been answered by odie_63 on Jun 29 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2015
Added on Jun 23 2015
4 comments
4,253 views