RE: Tomcat 5.5.7 + Connection Pool

[Abdullah Jibaly]

Alex,

Try using only the Resource element like this:

<Resource name="jdbc/StrutsDemosDS" auth="Container" 
type="javax.sql.DataSource" scope="Shareable"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
maxActive="20"
maxIdle="10"
maxWait="-1"
username="postgres"
password="irigon2004"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql:strutsdemo" />

Regards,
Abdullah

-----Original Message-----
From: Alex Rodrigues da Silva [mailto:[EMAIL PROTECTED]
Sent: Friday, March 18, 2005 6:58 AM
To: user@struts.apache.org
Subject: Tomcat 5.5.7 + Connection Pool


Hi,
i'm trying to use a datasource, to connect to postgresql,
but i didn't do it.
my server.xml have this lines then i added above 
     <Host name="localhost" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">  :

        <DefaultContext>
          <Resource name="jdbc/StrutsDemosDS" auth="Container" 
type="javax.sql.DataSource" scope="Shareable"/>
          <ResourceParams name="jdbc/StrutsDemoDS">
            
<parameter><name>factory</name><value>org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory</value></parameter>
            <parameter><name>maxActive</name><value>20</value></parameter>
            <parameter><name>maxIdle</name><value>10</value></parameter>
            <parameter><name>maxWait</name><value>-1</value></parameter>
            <parameter><name>username</name><value>postgres</value></parameter>
            
<parameter><name>password</name><value>irigon2004</value></parameter>
            
<parameter><name>driverClassName</name><value>org.postgresql.Driver</value></parameter>
            
<parameter><name>url</name><value>jdbc:postgresql:strutsdemo</value></parameter>
          </ResourceParams>
        </DefaultContext>
and my postgresql.jar i added at /common/lib at tomcat.
but i get an exception no suitable driver.

can you help me ?

thanks 
-- 
Alex Rodrigues da Silva
Analista de Sistemas
tel.: 55 21 8825-1967
[EMAIL PROTECTED]
Linux User #378866

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


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