Weblogic - JNDI Datasource Lookup Issues

[Eric Rodriguez]

I have an applet that attempts to do a JNDI lookup on a given data source and then once the data source is found use the associated db connection.

Here is my code:

package project99;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Rectangle;
import java.awt.Toolkit;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import java.util.Hashtable;

import javax.naming.Context;
import javax.naming.InitialContext;

import javax.swing.JApplet;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.UIManager;

public class Applet1 extends JApplet {
    private JLabel jLabel1 = new JLabel();

    public Applet1() {
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout( null );
        jLabel1.setText("jLabel1");
        jLabel1.setBounds(new Rectangle(20, 60, 165, 15));
        this.getContentPane().add(jLabel1, null);
    }

    public void init() {
        try {
            jbInit();
            
            Hashtable env = new java.util.Hashtable();
            Connection conn = null;
                                                         
            try {
                //jbInit();
                
                env.put(javax.naming.Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
                env.put(javax.naming.Context.PROVIDER_URL,"t3://localhost:7001");
                env.put(javax.naming.Context.SECURITY_PRINCIPAL, "user");
                env.put(javax.naming.Context.SECURITY_CREDENTIALS, "password");                
                
                System.out.println(env);
                
                try {
                    Context ctx = new InitialContext(env);
                    System.out.println(ctx.getClass().getName());
                    javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("jdbc/sandboxDS");
                    System.out.println(ds.getClass().getName());                    
                    conn = ds.getConnection();                             
                } catch(Exception e){
                    e.printStackTrace();
                }
                
                if(conn != null){
                    System.out.println("Got connection...");
                    jLabel1.setText("Got connection");
                    
                    String colDescQuery =
                        "select column_desc_text from table_one where table_name =
'table_two' order by field_position_no";
                    Statement colDescStmt = conn.createStatement();
                    ResultSet colDescRS = colDescStmt.executeQuery(colDescQuery);
                    
                    while (colDescRS.next()) {
                        System.out.println(colDescRS.getString(1));                    
                    }                    
                    
                } else {
                    System.out.println("No connection...");
                    jLabel1.setText("No connection");                    
                }
            } catch (Exception e) {
                e.printStackTrace();
            }            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void start() {
    }

    public void stop() {
    }

    public void destroy() {
    }
    static {
        try {
        } catch (Exception e) {
        }
    }
}

I have created a jar file from this class and signed it. I need some classes in the weblogic.jar and wlthint3client.jar archives so I signed those as well.

When I run the using the applet viewer (C:\Work\Applet_Test\viewer>appletviewer -J-classpath -Jweblogic.jar;wlthint3client.jar t.html) I get the following exception:

java.lang.ExceptionInInitializerError
        at weblogic.security.service.SecurityManager.getKernelIdentity(SecurityManager.java:164)
        at weblogic.security.service.GetKernelIdentityAction.run(GetKernelIdentityAction.java:25)
        at java.security.AccessController.doPrivileged(Native Method)
        at weblogic.jndi.WLSJNDIEnvironmentImpl.<clinit>(WLSJNDIEnvironmentImpl.java:56)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at weblogic.jndi.internal.JNDIEnvironment.getJNDIEnvironment(JNDIEnvironment.java:33)
        at weblogic.jndi.Environment.<clinit>(Environment.java:89)
        at weblogic.jndi.WLInitialContextFactory.getInitialContext(WLInitialContextFactory.java:117)
        at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:667)
        at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
        at javax.naming.InitialContext.init(InitialContext.java:223)
        at javax.naming.InitialContext.<init>(InitialContext.java:197)
        at project99.Applet1.init(Applet1.java:53)
        at sun.applet.AppletPanel.run(AppletPanel.java:424)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.security.AccessControlException: access denied
(java.util.PropertyPermission com.bea.core.internal.client read)
        at java.security.AccessControlContext.checkPermission(AccessControlContext.java:374)
        at java.security.AccessController.checkPermission(AccessController.java:546)
        at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
        at java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1285)
        at java.lang.System.getProperty(System.java:686)
        at weblogic.security.subject.SubjectManager.<clinit>(SubjectManager.java:207)
        ... 16 more

When I run from a browser I accept the certificate and the applet just hangs where the InitialContext is instantiated.

This seems to be security related but having signed my jars I don't know what else it could be looking for.

Any ideas?

Thanks...