Re: Tomcat 4.0.4, jndi, jdbc and postgresql [long]

[Brian P. Millett]

On Tue, 2002-07-02 at 08:47, Przemyslaw Kowalczyk wrote:
> On Tuesday 02 July 2002 15:16, Les Hughes wrote:
> > Ignore the "remove //" comment - I was looking at my oracle notes :-)
> > I really have no idea why it's trying to load the hsql driver if there's no
> > ref in your
> > server.xml
> 
> Ok, the full versions (I cut off all comments):
> 
> przem

Przem,
 Here are the setting I have used with Tomcat 4.0.4, postgresql 7.2.1 &
jdk1.4

I had to put the postgresql.jar, commons-dbcp.jar, commons-pool.jar into
the <DIR>/common/lib directory.

SERVER.XML:

<Resource name="jdbc/tropicos" auth="Container"
type="javax.sql.DataSource"/>
      <ResourceParams name="jdbc/tropicos">
          <parameter>
             <name>factory</name>
            
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
           
<parameter><name>maxActive</name><value>100</value></parameter>
           
<parameter><name>maxIdle</name><value>30000</value></parameter>
           
<parameter><name>maxWait</name><value>100</value></parameter>
           
<parameter><name>username</name><value>XXXXX</value></parameter>
           
<parameter><name>password</name><value>XXXX</value></parameter>
            <parameter>
                <name>driverClassName</name>
                <value>org.postgresql.Driver</value>
            </parameter>
            <parameter>
                <name>url</name>
               
<value>jdbc:postgresql://localhost:5432/ids_tropicos</value>
            </parameter>
          </ResourceParams>

Then the web.xml cruft:
    <resource-ref>
      <description>PostgreSQL DB Connection</description>
      <res-ref-name>jdbc/tropicos</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
    </resource-ref>

-- 
Brian Millett                    
Enterprise Consulting Group   "Shifts in paradigms
(314) 205-9030               often cause nose bleeds."
[EMAIL PROTECTED]                           Greg Glenn


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>