Hello,
I am trying to use a jdbc connection to Postgresql and I have some problems
with the security manager (?).
Every access to the database gives me an abort of the transaction with a
stack trace :
----------------------------------------------------------------------------------------------------------------------------------
Apache Tomcat/4.0.3
ACCESS Erreur connection : ==Something unusual has occured to cause the
driver to fail. Please report this exception: Exception:
java.security.AccessControlException: access denied
(java.net.SocketPermission localhost resolve)
Stack Trace:
java.security.AccessControlException: access denied
(java.net.SocketPermission localhost resolve)
� � � � at
java.security.AccessControlContext.checkPermission(AccessControlContext.java:272)
� � � �at
java.security.AccessController.checkPermission(AccessController.java:399)
� � � � at java.lang.SecurityManager.checkPermission(SecurityManager.java:545)
� � � � at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042)
� � � � at java.net.InetAddress.getAllByName0(InetAddress.java:559)
� � � � at java.net.InetAddress.getAllByName0(InetAddress.java:540)
� � � � at java.net.InetAddress.getByName(InetAddress.java:449)
� � � � at java.net.Socket.<init>(Socket.java:100)
� � � � at org.postgresql.PG_Stream.<init>(PG_Stream.java:41)
� � � � at org.postgresql.Connection.openConnection(Connection.java:134)
� � � � at org.postgresql.Driver.connect(Driver.java:149)
� � � � at java.sql.DriverManager.getConnection(DriverManager.java:517)
� � � � at java.sql.DriverManager.getConnection(DriverManager.java:177)
� � � � at database.access.<init>(access.java:46)
------------------------------------------------------------------------------------------------------------------------------------------
The line 46 in my class (database.access) looks like :
� � 44 � � � try
� � �45 � � � {
� � �46 � � � � db = DriverManager.getConnection(url, username, password);
� � �47 � � � } catch (SQLException se)
� � �48 � � � � { ret = 1;
� � �49 � � � � � System.out.println("ACCESS Erreur connection : " + "==" �
+se+ "==");
� � �50 � � � � � return;
� � �51 � � � � }
� � �52 � � }
That class is OK when called through a "terminal screen", the connection is OK
and all wnet well.
I look at the "security" properties in the "catalina.policy" file, but I
can't find the good value for the parameters, even if I give all permissions
to the �jdbc.jar ..... with :
�
�grant codeBase "file:/var/lib/tomcat4/webapps/myapps/WEB-INF/lib/pgjdbc2.jar"
�{ � permission java.security.AllPermission;
�};
I can't find the right "codebase" to apply the "grant" ?????.
Any help is wanted ...
Regards
JP Pozzi
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
