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