invalid JAVA CLASS objects

From: <navaed_at_my-deja.com>
Date: Wed, 24 Jan 2001 21:51:43 GMT
Message-ID: <94nip9$tth$1@nnrp1.deja.com>

 All,

 I've encountered a strange problem in
 Oracle 8.1.7 Rel 3 for Linux. After installing  8.1.7 using the Oracle Universal Installer with  the option of creating a starter database I  encountered no problems. But when I fired up  DB Assist to create a second database I  encountered invalid objects mostly with package  bodies and java classes.

 My workaround was to just manually recompile  the invalid objects, and this worked fine for  the packages, but not for the JAVA CLASS objects.  Every time I compile them I get a 'compiled  with errors' message. How do I fix it so that  these objects are compiled as VALID.

 Here is a snip of my query and it's results when  I looked for invalid objects and compiled them.

<snip>

SQL> select object_name, object_type from dba_objects

     where status != 'VALID';

 OBJECT_NAME                     OBJECT_TYPE   STATUS
 -------------------             -----------   ------
 /ad6de920_dbExecuteTag           JAVA CLASS   INVALID
 oracle/jsp/dbutil/BeanUtil       JAVA CLASS   INVALID
 oracle/jsp/dbutil/ConnBean       JAVA CLASS   INVALID
 oracle/jsp/dbutil/CursorBean     JAVA CLASS   INAVLID
 oracle/jsp/dbutil/DBBean         JAVA CLASS   INAVLID
 oracle/jsp/tags/sql/dbCloseTag   JAVA CLASS   INVALID
 oracle/jsp/tags/sql/dbNextTag    JAVA CLASS   INAVLID

 oracle/jsp/tags/sql/dbOpenTag JAVA CLASS INVALID  oracle/jsp/tags/sql/dbQueryTag JAVA CLASS INAVLID

SQL> select dbms_java.longname(object_name)   2 from dba_objects
  3 where status != 'VALID';

DBMS_JAVA.LONGNAME(OBJECT_NAME)

---

oracle/jsp/tags/sql/dbExecuteTag
oracle/jsp/dbutil/BeanUtil
oracle/jsp/dbutil/ConnBean
oracle/jsp/dbutil/CursorBean
oracle/jsp/dbutil/DBBean
oracle/jsp/tags/sql/dbCloseTag
oracle/jsp/tags/sql/dbNextTag
oracle/jsp/tags/sql/dbOpenTag
oracle/jsp/tags/sql/dbQueryTag

9 rows selected.

SQL> ALTER JAVA CLASS "oracle/jsp/tags/sql/dbExecuteTag" compile;

Warning: Java altered with compilation errors.

<snip>

 If anyone knows how to get compile these JAVA CLASS  objects so that they are valid I would greatly appreciate  it.

 Thanks,
 Daniel N.

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 15:51:43 CST