Has anyone successfully got JNDI Connection pooling to work with Tomcat (vers 4.0.2) and Postgres?
I think my server.xml must be wrong. It's got: <Resource name="jdbc/LiveDb" auth="Container" type="tyrex.jdbc.ServerDataSource" /> <ResourceParams name="jdbc/LiveDb"> <parameter><name>factory</name> <value>org.apache.naming.factory.TyrexDataSourceFactory</value></parameter> <parameter><name>user</name><value>live</value></parameter> <parameter><name>password</name><value>live</value></parameter> <parameter><name>serverName</name><value>l2</value></parameter> <parameter><name>databaseName</name><value>live</value></parameter> <parameter><name>driverClassName</name><value>org.postgresql.Driver</value>< /parameter> <parameter><name>driverName</name><value>jdbc:postgresql://l2/live</value></ parameter> </ResourceParams> But I get an error: java.security.AccessControlException: access denied (tyrex.tm.TyrexPermission manager) at java.security.AccessControlContext.checkPermission(AccessControlContext.java :272) at java.security.AccessController.checkPermission(AccessController.java:399) at tyrex.tm.Tyrex.getTransactionManager(Tyrex.java:89) at tyrex.tm.ResourceManager.run(ResourceManager.java:118) at java.security.AccessController.doPrivileged(Native Method) at tyrex.tm.ResourceManager.enlistResource(ResourceManager.java:91) at tyrex.jdbc.EnlistedConnection.enlist(EnlistedConnection.java:241) at tyrex.jdbc.EnlistedConnection.<init>(EnlistedConnection.java:129) at tyrex.jdbc.ServerDataSource.getConnection(ServerDataSource.java:258) at tyrex.jdbc.ServerDataSource.getConnection(ServerDataSource.java:223) at AccessLog.doGet(AccessLog.java:192) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase .java:475) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: 1012) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107 ) at java.lang.Thread.run(Thread.java:484) Any ideas??? Thanks for any help Mark -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>