I have a problem when connecting h2 database that is embedded in
applet as a .zip file.
Directory structure is as following
/H2Applet.jar --> Applet jar.
/lib/h2.jar --> h2 jar.
/lib/TestH2.zip --> zipped database file in which contains
"test_h2" database.
I've tried following connection URL with no luck.
Connection connection = DriverManager.getConnection("jdbc:h2:zip:lib/
TestH2.zip!/test_h2", "sa", "");
I've signed all applet files. Following is a stack trace.
org.h2.jdbc.JdbcSQLException: General error:
java.security.AccessControlException: access denied
(java.io.FilePermission lib\TestH2.zip read) [50000-78]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.convert(Message.java:257)
at org.h2.engine.Database.<init>(Database.java:226)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:125)
at org.h2.engine.Engine.getSession(Engine.java:108)
at org.h2.engine.Session.createSession(Session.java:242)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:87)
at org.h2.Driver.connect(Driver.java:57)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at H2Applet.test(H2Applet.java:14)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.plugin.javascript.JSInvoke.invoke(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.plugin.javascript.JSClassLoader.invoke(Unknown Source)
at sun.plugin.com.MethodDispatcher.invoke(Unknown Source)
at sun.plugin.com.DispatchImpl.invokeImpl(Unknown Source)
at sun.plugin.com.DispatchImpl$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.plugin.com.DispatchImpl.invoke(Unknown Source)
Caused by: java.security.AccessControlException: access denied
(java.io.FilePermission lib\TestH2.zip 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.checkRead(Unknown Source)
at java.util.zip.ZipFile.<init>(Unknown Source)
at java.util.zip.ZipFile.<init>(Unknown Source)
at org.h2.store.fs.FileSystemZip.openZipFile(FileSystemZip.java:250)
at org.h2.store.fs.FileSystemZip.exists(FileSystemZip.java:74)
at org.h2.util.FileUtils.exists(FileUtils.java:132)
at org.h2.engine.Database.open(Database.java:490)
at org.h2.engine.Database.<init>(Database.java:207)
... 25 more
What is the problem? What is the correct connection URL in this case?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
