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]