Re: a little disillusioned - Mailing list pgsql-jdbc

On Jan 27, 2004, at 3:01 PM, Paul Thomas wrote:

>
> On 27/01/2004 19:07 David Wilbur wrote:
>> maybe even adding the same advice to the postgres jdbc examples so
>> that  we would have a starting point that we knew was working for
>> someone...   this is a nice starting point, but... it might be nice
>> to add in  something along the line of how to set up a java web
>> server to use  postgres.
>
>
> The Tomcat 5.0 docs gave the stupid (and I would have thought obvious)
> typo that exists in the 4.1 doc for PostgreSQL. The web.xml
> res-ref-name should refer to the matching name in the ResourceParams
> tag _not_ the physical db name which appears in the JDBC url.

yep i saw that  here are my changes as i thought they should be:

more web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
     <!DOCTYPE web-app PUBLIC
     "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
     "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
   <description>PosgreSQL Test App</description>
   <resource-ref>
       <description>DB Connection</description>
       <res-ref-name>jdbc/postgres</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
   </resource-ref>
</web-app>


out of server.xml

                 <Context path="/pgtest" docBase="pgtest"  debug="5"
reloadable="true" crossContext="true">

                   <Logger
className="org.apache.catalina.logger.FileLogger"
                                          prefix="localhost_DBTest_log."
suffix=".txt"
                                          timestamp="true"/>

                   <Resource name="jdbc/postgres"  auth="Container"
type="javax.sql.DataSource"/>

                   <ResourceParams name="jdbc/postgres">
                         <parameter>
                           <name>factory</name>

<value>org.apache.commons.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>10000</value>
                         </parameter>

                         <parameter>
                          <name>username</name>
                          <value>dbuser</value>
                         </parameter>

                         <parameter>
                          <name>password</name>
                          <value>dbpassword</value>
                         </parameter>

                         <parameter>
                            <name>driverClassName</name>
                            <value>org.postgres.Driver</value>
                         </parameter>

                         <parameter>
                           <name>url</name>

<value>jdbc:postgresql://127.0.0.1:5432/test</value>
                         </parameter>
                   </ResourceParams>
                 </Context>


>
>> http://www.postgresql.org/docs/current/static/jdbc-datasource.html
>> i am suspecting that maybe is one of the xml files... either
>> $CATALINA_HOME/conf/server.xml  or the apps WEB-INF/web.xml... but i
>> really don't know for sure what i might have wrong there.  in the
>> mean  time i guess i will try the mysql setup the tomcat people
>> define to see  if that works... since i have to do that too.
>
> FWIW, you don't really need to edit server.xml. Create a <app.,xml
> file defining the context of you web app and put it in the webapps
> directory. Here's a sample which also defines a JDBC realm.

yes, but i thought the whole point of the definition in the server.xml
file was to have it typed once there and then all you need in the
web.xml is the reference to it... that way an admin can make one change
and all that refer to the resource get changed...

thanks, looking  at the following...  they don't seem much different.

>
> <!-- Tomcat XML file for MyApp context -->
> <!-- this file is to be placed in the webapps direcory -->
>
> <!-- MyApp context -->
> <Context path="/myapp"       docBase="myapp.war"         debug="0"
>    reloadable="true"
>  crossContext="true">
>
> <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="0"
>        driverName="org.postgresql.Driver"
>            digest="MD5"
>     connectionURL="jdbc:postgresql://127.0.0.1:5432/my_physical_db"
>    connectionName="dbuser" connectionPassword="dbpasswd"
>         userTable="user_table" userNameCol="login_name"
> userCredCol="password"
>     userRoleTable="user_roles" roleNameCol="role" />
>
> <Resource name="jdbc/aniceDB" auth="Container"
>       type="javax.sql.DataSource"/>     <ResourceParams
> name="jdbc/aniceDB">
>     <parameter>
>         <name>factory</name>
>          <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>     </parameter>
>     <parameter>
>         <name>driverClassName</name>
>         <value>org.postgresql.Driver</value>
>     </parameter>
>     <parameter>
>         <name>url</name>
>          <value>jdbc:postgresql://127.0.0.1:5432/my_physical_db</value>
>     </parameter>
>     <parameter>
>         <name>username</name>
>         <value>dbuser</value>
>     </parameter>
>     <parameter>
>         <name>password</name>
>         <value>dbpasswd</value>
>     </parameter>
>     <parameter>
>         <name>maxActive</name>
>         <value>10</value>
>     </parameter>
>     <parameter>
>         <name>maxIdle</name>
>         <value>1</value>
>     </parameter>
>     <parameter>
>         <name>maxWait</name>
>         <value>30000</value>
>     </parameter>
>     <parameter>
>         <name>removeAbandoned</name>
>         <value>true</value>
>     </parameter>
>     <parameter>
>         <name>removeAbandonedTimeout</name>
>         <value>60</value>
>     </parameter>
>     <parameter>
>         <name>logAbandoned</name>
>         <value>true</value>
>     </parameter>
>     </ResourceParams> </Context>
>
> And here's part of the app's web.xml which defines the datasource
>
>
>     <resource-ref>
>         <description>
>         Resource reference to a factory for java.sql.Connection
>         instances that may be used for talking to a particular
>         database that is configured in the server.xml file.
>         </description>
>         <res-ref-name>jdbc/aniceDB</res-ref-name>
>         <res-type>javax.sql.DataSource</res-type>
>         <res-auth>Container</res-auth>
>     </resource-ref>
>
>
> HTH
>
> --
> Paul Thomas
> +------------------------------
> +---------------------------------------------+
> | Thomas Micro Systems Limited | Software Solutions for the Smaller
> Business |
> | Computer Consultants         |
> http://www.thomas-micro-systems-ltd.co.uk   |
> +------------------------------
> +---------------------------------------------+
>