Return-Path: 
 <users-return-139280-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 2491 invoked from network); 24 Jan 2006 22:36:22 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 24 Jan 2006 22:36:22 -0000
Received: (qmail 80816 invoked by uid 500); 24 Jan 2006 22:36:07 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 80801 invoked by uid 500); 24 Jan 2006 22:36:06 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 80781 invoked by uid 99); 24 Jan 2006 22:36:05 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jan 2006 14:36:05 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [217.116.234.122] (HELO gropa.frojonck.dk) (217.116.234.122)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Jan 2006 14:36:01 -0800
Received: from [192.168.1.52] (papa.family [192.168.1.52])
	by gropa.frojonck.dk (Postfix) with ESMTP id C85901A80B0
	for <users@tomcat.apache.org>; Tue, 24 Jan 2006 17:35:40 -0500 (EST)
Message-ID: <43D6ABBC.1020604@frojonck.dk>
Date: Tue, 24 Jan 2006 23:35:40 +0100
From: torben <torben@frojonck.dk>
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Postgresql and JNDI Datasource
References: <43D6A257.5070304@frojonck.dk> <43D6A3FD.4040404@aspix.it>
In-Reply-To: <43D6A3FD.4040404@aspix.it>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Edoardo Panfili wrote:

> torben ha scritto:
>
>> I am trying to define a global JDBC datasource, where the database is 
>> Postgresql (version 7.3) ni Tomcat version 5.5.15.
>>
>> I have strictly followed the example in 
>> http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html, 
>>
>> but it does not work if I define the datasource in 
>> $CATALINA_HOME/conf/server.xml.
>>
>> However if I define the datasource in the application 
>> META-INF/context.xml, it is working.
>>
>> I would prefer to define the datasource in 
>> $CATALINA_HOME/conf/server.xml. Has somebody succeded in doing that ? 
>> And if yes, how ?
>>
>>
>> Torben Fr�berg
>>
> this is my configuration:
> now I am using postgres 8.1 but it is the same configuration for my 
> old configuration (1 month ago) with postgres 7.4
>
> server.xml------------------------------------------
>        <Context path="/lisy" docBase="lisy" debug="5" reloadable="true">
>                <Resource name="jdbc/lisy" auth="Container" 
> type="javax.sql.DataSource"
>                        maxActive="8" maxIdle="5" maxWait="10000"
>                        username="uname" password="pwd" 
> driverClassName="org.postgresql.Driver"
>                        url="jdbc:postgresql://127.0.0.1:5432/lisy"
>                        removeAbandoned="true"
>                        removeAbandonedTimeout="30"
>                        logAbandoned="true"
>                />
>
>        </Context>
> web-xml------------------------------------------------
>        <resource-ref>
>                <description>postgreSQL Datasource</description>
>                <res-ref-name>jdbc/lisy</res-ref-name>
>                <res-type>javax.sql.DataSource</res-type>
>                <res-auth>Container</res-auth>
>        </resource-ref>
>
>
> I hope that this can help you
>
Yes, thank you. It works.

But how comes that it is not possible to define the resource as a 
GlobalNamingResource ?
It is the way it is defined in the example in 
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html. 


Torben

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org