 | 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
|
|
|
| | | Issue with psql driver | Issue with psql driver 2007-09-05 - By Dan Armbrust
Back
Pease add a ex.printStackTrace() call to your exception catch block,
and then post the results. That will give more information as to what
went wrong.
You may need to take this question to the postgres mailing lists.
Dan
On 9/5/07, Chris Baty <batymohn@(protected)> wrote:
> I'm not sure. The code looks like:
> try {
> con =
> DriverManager.getConnection("jdbc:postgresql:test","batymohn","bcl122");
> out.println("Conection made");
> } catch (Exception ex) {
> System.out.println("Error occurred: " + ex);
> out.println("<p>NO Connection made</p>");
> }
> When it throws this exception it comes out in
> /var/tomcatt5/Catalina.date.log
> Chris
>
> --- David Smith <dns4@(protected)> wrote:
>
> > How do you log the event? Most logging frameworks
> > support log.error(
> > String message, Exception e ), which would provide
> > the complete stack
> > and root cause in the log file.
> >
> > --David
> >
> > Chris Baty wrote:
> >
> > >Hi David,
> > >The only trace that I can find is the Catalina
> > log:
> > >
> > >Error occurred: org.postgresql.util.PSQLException:
> > Something unusual
> > >has occured to cause the driver to fail. Please
> > report this exception.
> > >
> > >This comes right from my catch routine and is
> > what I would expect.
> > >
> > >Thanks.
> > >Chris
> > >
> > >
> > >-- -- Original Message ----
> > >From: David Smith <dns4@(protected)>
> > >To: Tomcat Users List <users@(protected)>
> > >Sent: Wednesday, September 5, 2007 10:58:19 AM
> > >Subject: Re: Issue with psql driver
> > >
> > >
> > >Can you post the complete stack trace of your
> > error? That would be
> > >extremely helpful in diagnosing the problem.
> > >
> > >---David
> > >
> > >
> > >Chris Baty wrote:
> > >
> > >
> > >
> > >>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
> >
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> >
> >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> > >To start a new topic, e-mail:
> > users@(protected)
> > >To unsubscribe, e-mail:
> > users-unsubscribe@(protected)
> > >For additional commands, e-mail:
> > users-help@(protected)
> > >
> > >
> > >
> >
> >__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ___
__ _____
> > >Looking for a deal? Find great prices on flights
> > and hotels with Yahoo! FareChase.
> > >http://farechase.yahoo.com/
> > >
> > >
> >
> >
> >
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> > To start a new topic, e-mail:
> > users@(protected)
> > To unsubscribe, e-mail:
> > users-unsubscribe@(protected)
> > For additional commands, e-mail:
> > users-help@(protected)
> >
> >
>
>
>
>
> __ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____
__ ____
> Moody friends. Drama queens. Your life? Nope! - their life, your story. Play
Sims Stories at Yahoo! Games.
> http://sims.yahoo.com/
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To start a new topic, e-mail: users@(protected)
> To unsubscribe, e-mail: users-unsubscribe@(protected)
> For additional commands, e-mail: users-help@(protected)
>
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
|
|
|
