Issue with psql driver

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Tomcat - JSP/Servlet container

Struts - A MVC web framework

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

JSP - A mailing list about Java Server Pages specification and reference

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Servlet : Session invalidate
•	Oracle Connection Pooling in 3 2 2
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Running a Simple JMS Example
•	Tomcat and webapplication specific java library path
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	Value attribute of <html:checkbox
•	url string for connecting jboss to oracle
•	javax servlet ServletException: BeanUtils populate
•	5 0 18: Windows XP Pro vs Windows 2000
•	HTTP Status 404 The requested resource is not available

Issue with psql driver

Issue with psql driver

2007-09-05 - By Chris Baty

Back
Hi Guys,
I'm trying to access psql from Tomcat5. I have the correct driver
because my command-lind test program works fine. So I copied the
driver into /usr/share/tomcat5/common/lib, like the documentation
says. Then I kept getting

Error occurred: org.postgresql.util.PSQLException: Something unusual
has occured to cause the driver to fail. Please report this exception.

I was told I had a security problem so I added a file called
chapter1.policy to /etc/policy.d:
// These permissions apply to the chapter1 web application
grant codeBase "file:${catalina.home}/webapps/chapter1/WEB-INF/
classes/-" {
permission java.security.AllPermission;

};

grant codeBase "file:${catalina.home}/webapps/chapter1/WEB-INF/
lib/-" {
permission java.security.AllPermission;

};

//
// The permission granted to your JDBC driver
grant codeBase "file:${catalina.home}/common/lib/postgresql-
jdbc3-8.1.jar" {
permission java.net.SocketPermission "localhost:5432",
"connect";

};

I still get the same PSQLException
Could anyone send me an example of a security policy that works? I
don't understand because 03Catalina.policy contains:

// These permissions apply to the servlet API classes
// and those that are shared across all class loaders
// located in the "common" directory
grant codeBase "file:${catalina.home}/common/-" {
permission java.security.AllPermission;

};

Thanks.

__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ______
__ __
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for
today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow