[Permission Denied] JTDS + APPLETS + HTML = ERRO!

0 respostas
L

Ae galera, estou utilizando este código para me conectar a base de dados e de lá obter informações para a construção de um gráfico utilizando o JFreeChart.
Estou utilizando Applets para serem carregados por uma página HTML simples e a página HTML ser carregada e exibida no VB6.
Quando rodo através do eclipse, funciona que é uma beleza. O problema está quando vou rodar através do HTML. O sistema exibe o erro descrito após o código de conexão com a base de dados.
Tentei criar o gráfico sem utilizar conexão com a base apenas para ver se estava tudo correto na construção da HTML. O gráfico foi exibido corretamente.
Então creio eu que a permissão negada seja relacionada a conexão com o banco.
Agradeço desde já a atenção e abraços.

package br.com.espe.db;

import java.sql.DriverManager;
import java.sql.SQLException;

public class DbSqlServer {
    private java.sql.Connection con;
    private String url = "jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=papelrb2;namedPipe=true";
    private String driver ="net.sourceforge.jtds.jdbc.Driver";
    private String usuario;
    private String senha;

    public DbSqlServer() {
        this.usuario = "PAPELRB2";
        this.senha = "!*$45937EZ";
    }

    public java.sql.Connection getConexao(){
    	try {
            Class.forName(driver);
            con = DriverManager.getConnection(url,usuario,senha);
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
            return null;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        }
        return con;
    }

    protected void fecharConexao(){
        try{
            if(con!=null)
                con.close();
            con=null;
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}

ERRO:

security: property package.access value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.

security: property package.access new value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws

security: property package.access value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws

security: property package.access new value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws,com.sun.deploy

security: property package.access value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws,com.sun.deploy

security: property package.access new value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws,com.sun.deploy,com.sun.jnlp

security: property package.definition value null

security: property package.definition new value com.sun.javaws

security: property package.definition value com.sun.javaws

security: property package.definition new value com.sun.javaws,com.sun.deploy

security: property package.definition value com.sun.javaws,com.sun.deploy

security: property package.definition new value com.sun.javaws,com.sun.deploy,com.sun.jnlp

security: property package.access value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws,com.sun.deploy,com.sun.jnlp

security: property package.access new value sun.,com.sun.xml.internal.ws.,com.sun.xml.internal.bind.,com.sun.javaws,com.sun.deploy,com.sun.jnlp,org.mozilla.jss

security: property package.definition value com.sun.javaws,com.sun.deploy,com.sun.jnlp

security: property package.definition new value com.sun.javaws,com.sun.deploy,com.sun.jnlp,org.mozilla.jss

basic: Added progress listener: sun.plugin.util.GrayBoxPainter$GrayBoxProgressListener@13582d

basic: Applet loaded.

basic: Applet resized and added to parent container

basic: PERF: AppletExecutionRunnable - applet.init() BEGIN ; jvmLaunch dt 417691 us, pluginInit dt 1253267 us, TotalTime: 1670958 us

basic: Applet initialized

basic: Removed progress listener: sun.plugin.util.GrayBoxPainter$GrayBoxProgressListener@13582d

basic: Applet made visible

basic: Starting applet

Exception in thread thread applet-br.com.espe.gui.Principal-1 java.lang.ExceptionInInitializerError

at net.sourceforge.jtds.jdbc.Driver.parseURL(Driver.java:371)

at net.sourceforge.jtds.jdbc.Driver.setupConnectProperties(Driver.java:240)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:179)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at br.com.espe.db.DbSqlServer.getConexao(DbSqlServer.java:21)

at br.com.espe.db.SqlGraphics.(SqlGraphics.java:29)

at br.com.espe.gui.CriaGrafico.(CriaGrafico.java:55)

at br.com.espe.gui.Principal.start(Principal.java:52)

at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.security.AccessControlException: access denied (java.util.PropertyPermission java.io.tmpdir read)

at java.security.AccessControlContext.checkPermission(Unknown Source)

at java.security.AccessController.checkPermission(Unknown Source)

at java.lang.SecurityManager.checkPermission(Unknown Source)

at java.lang.SecurityManager.checkPropertyAccess(Unknown Source)

at java.lang.System.getProperty(Unknown Source)

at net.sourceforge.jtds.jdbc.DefaultProperties.(DefaultProperties.java:115)

 11 more
Criado 16 de janeiro de 2009
Respostas 0
Participantes 1