Hi All,
I've tried at least 4 drivers, changing the url to
localhost:test, localhost:5432:test, 127.0.0.1:test
This is my current trace:
Error occurred: org.postgresql.util.PSQLException:
Something unusual has occured to cause the driver to
fail. Please report this exception.
org.postgresql.util.PSQLException: Something unusual
has occured to cause the driver to fail. Please report
this exception.
at org.postgresql.Driver.connect(Driver.java:276)
at
java.sql.DriverManager.getConnection(DriverManager.java:512)
at
java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.apache.jsp.jdb_jsp._jspService(jdb_jsp.java:69)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
at java.security.AccessController.doPrivileged(Native
Method)
at
javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
at
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:272)
at
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
at
org.apache.catalina.core.ApplicationFilterChain.access$0(ApplicationFilterChain.java:177)
at
org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
at java.security.AccessController.doPrivileged(Native
Method)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.security.AccessControlException:
access denied (java.net.SocketPermission localhost
resolve)
at
java.security.AccessControlContext.checkPermission(AccessControlContext.java:269)
at
java.security.AccessController.checkPermission(AccessController.java:401)
at
java.lang.SecurityManager.checkPermission(SecurityManager.java:524)
at
java.lang.SecurityManager.checkConnect(SecurityManager.java:1023)
at
java.net.InetAddress.getAllByName0(InetAddress.java:1000)
at
java.net.InetAddress.getAllByName0(InetAddress.java:981)
at
java.net.InetAddress.getAllByName(InetAddress.java:975)
at
java.net.InetAddress.getByName(InetAddress.java:889)
at
java.net.InetSocketAddress.<init>(InetSocketAddress.java:114)
at java.net.Socket.<init>(Socket.java:124)
at
org.postgresql.core.PGStream.<init>(PGStream.java:59)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at
org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
... 45 more
Thanks.
Chris
--- Chris Baty <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> To: Tomcat Users List <users@tomcat.apache.org>
> 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@tomcat.apache.org
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
>
>
____________________________________________________________________________________
> Looking for a deal? Find great prices on flights and
> hotels with Yahoo! FareChase.
> http://farechase.yahoo.com/
____________________________________________________________________________________
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
