Re: error ORA-1031 using loadjava

From: Marco de Haan <haandm_at_yahoo.com>
Date: Mon, 29 Oct 2001 16:47:01 +0100
Message-ID: <1004370424.910211_at_newsreader1.wirehub.nl>

This is a part of the code I'm using.......after this method has been completed, the variables "d" and "conn" are still NULL:

/**/

// ESTABLISHES CONNECTION TO MSACCESS DATA SOURCE    static void connectMSAccess() throws SQLException {

      String dsn      = "jdbc:odbc:Noorderwind";
      String user     = "admin";
      String password = "";

      try {
         // Load the  driver
         d =

(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

         java.sql.DriverManager.registerDriver(d);

         // Connect to the database
         conn = DriverManager.getConnection(dsn, user, password);

         // Shut off autocommit
         conn.setAutoCommit(false);

      } catch( ClassNotFoundException e1 ) {
          e1.printStackTrace();

      } catch( SQLException e2 ) {
          e2.printStackTrace();

      } catch( InstantiationException e3 ) {
          e3.printStackTrace();

      } catch( IllegalAccessException e4 ) {
          e4.printStackTrace();
      }

    }

/**/

> May I have your code? And have your SYS the "JAVA_ADMIN" privilege?
> Did you tried to load without "resolver"?

I don't have a JAVA_ADMIN privelege......I only have the following roles: JAVADEBUGPRIV
JAVAIDPRIV
JAVASYSPRIV
JAVAUSERPRIV SYS has all of these roles! Received on Mon Oct 29 2001 - 16:47:01 CET