title: Oracle loadjava error during loading of .jar
body: <p>I'm trying to load and publish a .jar into my Oracle database with this command:</p>
  
  <pre><code>loadjava -schema PIN75 -u username/password -v -resolve -debug BIPExtension.jar
  </code></pre>
  
  <p>but I'm getting this error:</p>
  
  <pre><code>arguments: '-u' 'username/***' '-schema' 'PIN75' '-v' '-resolve' '-debug' 'BIPExtension.jar' 
  creating : resource PIN75.META-INF/MANIFEST.MF
  loading  : resource PIN75.META-INF/MANIFEST.MF
  Error while creating "PIN75".CREATE$JAVA$LOB$TABLE
      ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
  
  java.sql.SQLException: ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
  
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1132)
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1035)
      at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:916)
      at oracle.jdbc.driver.T2CStatement.executeForRows(T2CStatement.java:1159)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1115)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1733)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1688)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:296)
      at oracle.aurora.server.tools.loadjava.JdbcOperations.executeDDL(JdbcOperations.java:583)
      at oracle.aurora.server.tools.loadjava.LoadJavaState.createTable(LoadJavaState.java:546)
      at oracle.aurora.server.tools.loadjava.LoadJavaState.getLoadLOB(LoadJavaState.java:577)
      at oracle.aurora.server.tools.loadjava.SchemaObject.load(SchemaObject.java:845)
      at oracle.aurora.server.tools.loadjava.ClientSchemaObject.create(ClientSchemaObject.java:307)
      at oracle.aurora.server.tools.loadjava.SchemaObject.process1(SchemaObject.java:253)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:556)
      at oracle.aurora.server.tools.loadjava.LoadJava.addObject(LoadJava.java:535)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:474)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:403)
      at oracle.aurora.server.tools.loadjava.LoadJava.addJar(LoadJava.java:880)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:456)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:403)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:372)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:786)
      at oracle.aurora.server.tools.loadjava.LoadJava.processDeferredFiles(LoadJava.java:648)
      at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1016)
      at oracle.aurora.server.tools.loadjava.LoadJava.command(LoadJava.java:278)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:186)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:71)
  Caused by: Error : 60019, Position : 0, Sql = create table "PIN75".CREATE$JAVA$LOB$TABLE (name varchar2(700) unique, lob blob, loadtime date), OriginalSql = create table "PIN75".CREATE$JAVA$LOB$TABLE (name varchar2(700) unique, lob blob, loadtime date), Error Msg = ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
  
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1141)
      ... 27 more
  Error while getLoadLOB PIN75
      ORA-00942: table or view does not exist
  
  java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1132)
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1035)
      at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:916)
      at oracle.jdbc.driver.T2CStatement.executeForRows(T2CStatement.java:1159)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1115)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1733)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1688)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:296)
      at oracle.aurora.server.tools.loadjava.JdbcOperations.executeDDL(JdbcOperations.java:583)
      at oracle.aurora.server.tools.loadjava.LoadJavaState.getLoadLOB(LoadJavaState.java:581)
      at oracle.aurora.server.tools.loadjava.SchemaObject.load(SchemaObject.java:845)
      at oracle.aurora.server.tools.loadjava.ClientSchemaObject.create(ClientSchemaObject.java:307)
      at oracle.aurora.server.tools.loadjava.SchemaObject.process1(SchemaObject.java:253)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:556)
      at oracle.aurora.server.tools.loadjava.LoadJava.addObject(LoadJava.java:535)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:474)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:403)
      at oracle.aurora.server.tools.loadjava.LoadJava.addJar(LoadJava.java:880)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:456)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:403)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:372)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:786)
      at oracle.aurora.server.tools.loadjava.LoadJava.processDeferredFiles(LoadJava.java:648)
      at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1016)
      at oracle.aurora.server.tools.loadjava.LoadJava.command(LoadJava.java:278)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:186)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:71)
  Caused by: Error : 942, Position : 20, Sql = delete from "PIN75".CREATE$JAVA$LOB$TABLE where name='1098953594706461', OriginalSql = delete from "PIN75".CREATE$JAVA$LOB$TABLE where name='1098953594706461', Error Msg = ORA-00942: table or view does not exist
  
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1141)
      ... 26 more
  creating : class PIN75.oracle/com/xmlpublisher/reports/BIPExtension
  loading  : class PIN75.oracle/com/xmlpublisher/reports/BIPExtension
  Error while processing oracle/com/xmlpublisher/reports/BIPExtension
      Exception java.lang.NullPointerException
  java.lang.NullPointerException
      at oracle.aurora.server.tools.loadjava.LoadJavaState.getLoadLOB(LoadJavaState.java:593)
      at oracle.aurora.server.tools.loadjava.SchemaObject.load(SchemaObject.java:845)
      at oracle.aurora.server.tools.loadjava.ClientSchemaObject.create(ClientSchemaObject.java:307)
      at oracle.aurora.server.tools.loadjava.SchemaObject.process1(SchemaObject.java:253)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:556)
      at oracle.aurora.server.tools.loadjava.LoadJava.addClass(LoadJava.java:609)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:459)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:403)
      at oracle.aurora.server.tools.loadjava.LoadJava.addJar(LoadJava.java:880)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:456)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:403)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:372)
      at oracle.aurora.server.tools.loadjava.LoadJava.add(LoadJava.java:786)
      at oracle.aurora.server.tools.loadjava.LoadJava.processDeferredFiles(LoadJava.java:648)
      at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:1016)
      at oracle.aurora.server.tools.loadjava.LoadJava.command(LoadJava.java:278)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:186)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:71)
  The following operations failed
      resource PIN75.META-INF/MANIFEST.MF: creation (createFailed)
      class PIN75.oracle/com/xmlpublisher/reports/BIPExtension: creation
  java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1132)
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1035)
      at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:916)
      at oracle.jdbc.driver.T2CStatement.executeForRows(T2CStatement.java:1159)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1115)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1733)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1688)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:296)
      at oracle.aurora.server.tools.loadjava.LoadJavaState.resetStmts(LoadJavaState.java:782)
      at oracle.aurora.server.tools.loadjava.LoadJava.reset(LoadJava.java:177)
      at oracle.aurora.server.tools.loadjava.LoadJava.command(LoadJava.java:288)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.run(LoadJavaMain.java:186)
      at oracle.aurora.server.tools.loadjava.LoadJavaMain.main(LoadJavaMain.java:71)
  Caused by: Error : 942, Position : 20, Sql = delete from "PIN75".CREATE$JAVA$LOB$TABLE where name='1098953594706461', OriginalSql = delete from "PIN75".CREATE$JAVA$LOB$TABLE where name='1098953594706461', Error Msg = ORA-00942: table or view does not exist
  
      at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1141)
      ... 12 more
  exiting  : Failures occurred during processing
  </code></pre>
  
  <p>I granted <code>CREATE ANY PROCEDURE</code> and <code>CREATE ANY TABLE</code> privileges to <code>PIN75</code></p>
  
  <p>The BIPExtension.jar contains a single class with four methods:</p>
  
  <pre><code>import java.io.PrintStream;
  import java.text.ParseException;
  import java.text.SimpleDateFormat;
  import java.util.Calendar;
  import java.util.Date;
  import java.util.TimeZone;
  
  public class BIPExtension {
  
      public static long infStrToTimet(String dateString, int nFlag) throws ParseException {
          long utc;
          return utc;
      }
  
      public static String infTimetToStr(int lTimeIn, int nFlag) {
          StringBuffer sBuf = new StringBuffer();
          return sBuf.toString();
      }
  
      public static String infGetVersion() {
          return new String("7.5.0.0.1");
      }
  
      public static String infGetDateRange(int dateRange, int nFlag) {
          StringBuffer sBuf;
          return sBuf.toString();
      }
  
      public static String infReplicateString(String inputString, String inputMask, int inputUnmaskLength) {
          StringBuffer paramString = new StringBuffer(tempString);
          return paramString.toString();
      }
  }
  </code></pre>
  
  <p>I just want to use those methods during the execution of SELECT statements. Please tell me if I'm following the wrong path. If not, please help me to fix this error during the use of the loadjava utility.</p>