title: Recompling invalid Java class in Oracle database
body: <p>In Oracle database we have a schema called "prodtxn" in that we load the following java classes for application purposes using </p>
  
  <pre><code> host loadjava -user prodtxn/password  -verbose -resolve 
      wsdl4j-1.5.1.jar
      saaj.jar
      jaxrpc.jar
      commons-logging-1.0.4.jar
      commons-discovery-0.2.jar
      axis.jar
      clickatell14.jar
  </code></pre>
  
  <p>While loading we get the message successfully loaded, but when while running the following query, we see some java class objects invalid  </p>
  
  <pre><code>SELECT owner, object_name
  FROM   dba_objects
  WHERE  object_type IN ('JAVA CLASS')
  AND    status != 'VALID'
  </code></pre>
  
  <p>I can see the following objects are invalid </p>
  
  <pre><code>/213c5fb9_AxisHTTPSessionListe
  /226d1fae_CommonsHTTPSender1
  /b8a75d12_CommonsHTTPSenderGzi
  /90807c76_CommonsHTTPSenderMes
  /78ab888e_CommonsHTTPSender
  /a6c3563c_Log4JCategoryLog
  /3ba8073b_Log4JLogger
  /e1bfe35f_Log4jFactory
  /d39d2eaa_LogKitLogger
  /aee8cb05_AvalonLogger
  /c072eec9_MailSender
  /e8f4e62c_MailServer
  /d048f0b6_MailWorker
  /ca9a0853_JimiIO
  /d83efe05_BSF
  /f9b37edc_CastorDeserializer
  /afdd6cc5_CastorSerializer
  </code></pre>
  
  <p>I tried to do the following</p>
  
  <p><strong>SQL Prompt</strong></p>
  
  <pre><code>SQL&gt; alter java class "/213c5fb9_AxisHTTPSessionListe" resolve;
  </code></pre>
  
  <p>Warning: Java altered with compilation errors</p>
  
  <p>How can I make these objects valid?</p>
  
  <p>In User_errors view i found the following </p>
  
  <pre><code>/213c5fb9_AxisHTTPSessionListe  JAVA CLASS  2   0   0   ORA-29521: referenced name javax/servlet/http/HttpSessionEvent could not be found   
  </code></pre>
  
  <p>Please advise.</p>