Witam,
Mam problem z połączeniem się za pomocą Applet'u z bazą danych mysql. Sam applet się uruchamia i działa, problem pojawia się dopiero w momencie łączenia się z bazą, w applet viewerze w IDE wszystko działa poprawnie.
Pliki jar zostały podpisane za pomocą programu jarsigner kluczem wygenerowanym za pomocą keytool.
Wersja przeglądarki: Mozilla Firefox 43.0.4
Połączenie z bazą:
String url = "jdbc:mysql://127.0.0.1:3306/demi_db";
String username = "username";
String password = "password";
ArrayList<DatabaseResult> databaseResults = new ArrayList<>();
try (Connection connection = DriverManager.getConnection(url, username, password)) {
Statement statement = connection.createStatement();
String sql = "SELECT * FROM TETRIS_RESULTS";
DatabaseResult databaseResult;
ResultSet rs = statement.executeQuery(sql);
while (rs.next()) {
databaseResult = new DatabaseResult(rs.getString("name"), rs.getInt("points"), rs.getInt("time"));
databaseResults.add(databaseResult);
}
}
catch (SQLException e) {
e.printStackTrace();
System.out.println("Error");
throw new IllegalStateException("Cannot connect the database!", e);
}
return databaseResults;
Kod html którym używam appletu:
<html>
<head></head>
<body>
<applet code="main.Tetris" width="700" height="700" archive="Tetris.jar,mysql-connector-java-5.1.38-bin.jar">
</applet>
</body>
</html>
Błąd podczas łączenia się z bazą za pomocą przeglądarki:
... 43 more
at com.mysql.jdbc.StringUtils.<clinit>(StringUtils.java:118)
at java.lang.System.getProperty(System.java:708)
at java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1298)
at net.sourceforge.jnlp.runtime.JNLPSecurityManager.checkPermission(JNLPSecurityManager.java:292)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:549)
at java.security.AccessController.checkPermission(AccessController.java:685)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:474)
Caused by: java.security.AccessControlException: access denied ("java.util.PropertyPermission" "file.encoding" "read")
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:717)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:77)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.EventQueue$4.run(EventQueue.java:718)
at java.awt.EventQueue$4.run(EventQueue.java:720)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:77)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.EventQueue$3.run(EventQueue.java:704)
at java.awt.EventQueue$3.run(EventQueue.java:706)
at java.awt.EventQueue.access$300(EventQueue.java:103)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:747)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEventImpl(Component.java:4872)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.processEvent(Component.java:6281)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3312)
at java.awt.Component.processMouseEvent(Component.java:6516)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at panels.MainMenu.actionPerformed(MainMenu.java:70)
at main.Tetris.showRanking(Tetris.java:34)
at panels.ranking.RankingPanel.draw(RankingPanel.java:52)
at database.DatabaseConnector.getSortedResults(DatabaseConnector.java:58)
at database.DatabaseConnector.getResults(DatabaseConnector.java:37)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:310)
Exception in thread "AWT-EventQueue-1" java.lang.ExceptionInInitializerError
Denying permission: ("java.util.PropertyPermission" "file.encoding" "read")