Re: a little disillusioned

i should also note that i just finished installing mysql and the mysql
jdbc driver and i do have this working for mysql, following verbatim
what is on this page

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-
examples-howto.html

other then the error that Paul noted there isn't much different from
what i can tell for postgres.

On Jan 27, 2004, at 4:52 PM, David Wilbur wrote:

>
> 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 |
>> +------------------------------
>> +---------------------------------------------+
>>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>