Return-Path: 
 <tomcat-user-return-12644-qmlist-jakarta-archive-tomcat-user=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 5598 invoked from network); 1 Mar 2002 16:57:44 -0000
Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131)
  by daedalus.apache.org with SMTP; 1 Mar 2002 16:57:44 -0000
Received: (qmail 26370 invoked by uid 97); 1 Mar 2002 16:56:34 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org
Received: (qmail 26354 invoked by uid 97); 1 Mar 2002 16:56:34 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 26341 invoked from network); 1 Mar 2002 16:56:33 -0000
Message-ID: <010901c1c142$0d10c650$7502000a@MARKMUFFETTPC>
From: "Mark Muffett" <mark@muffett.net>
To: <tomcat-user@jakarta.apache.org>
Subject: JNDI / DB Connection pooling
Date: Fri, 1 Mar 2002 16:56:37 -0000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>