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

[Przemyslaw Kowalczyk]

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


server.xml

---cut---here----
<Server port="8005" shutdown="SHUTDOWN" debug="0">
  <Service name="Tomcat-Standalone">

    <Connector className="org.apache.catalina.connector.http.HttpConnector"
               port="8080" minProcessors="5" maxProcessors="75"
               enableLookups="true" redirectPort="8443"
               acceptCount="10" debug="0" connectionTimeout="60000"/>
    <Engine name="Standalone" defaultHost="localhost" debug="0">

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


      <Realm className="org.apache.catalina.realm.MemoryRealm" />

      <Host name="localhost" debug="0" appBase="webapps" unpackWARs="true">

        <Valve className="org.apache.catalina.valves.AccessLogValve"
                 directory="logs"  prefix="localhost_access_log." 
suffix=".txt"
                 pattern="common"/>

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

        <Context path="/manager" docBase="manager" 
         debug="0" privileged="true"/>

        <Context path="/bookstore1" docBase="bookstore1" debug="0"
                 reloadable="true" crossContext="true">
          <Logger className="org.apache.catalina.logger.FileLogger"
                     prefix="localhost_bookstore1_log." suffix=".txt"
                  timestamp="true"/>
          <Resource name="jdbc/BookDB" auth="Container"
            type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/BookDB">
            <parameter>
             <name>username</name>
              <value>java</value>
            </parameter>
            <parameter>
              <name>password</name>
              <value>java</value>
            </parameter>   
            <parameter>
              <name>driverClassName</name>
              <value>org.postgresql.Driver</value>
            </parameter>
            <parameter>
              <name>driverName</name>
              <value>jdbc:postgresql:/localhost/public</value>
            </parameter>
          </ResourceParams>
        </Context> 

      </Host>

    </Engine>

  </Service>


  <Service name="Tomcat-Apache">

    <Connector className="org.apache.catalina.connector.warp.WarpConnector"
     port="8008" minProcessors="5" maxProcessors="75"
     enableLookups="true"
     acceptCount="10" debug="0"/>

    <Engine className="org.apache.catalina.connector.warp.WarpEngine"
     name="Apache" defaultHost="localhost" debug="0" appBase="webapps">

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

      <Realm className="org.apache.catalina.realm.MemoryRealm" />

    </Engine>

  </Service>

</Server>

---cut---here----

web.xml

---cut---here----
<!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>
        <display-name>Info Application</display-name>
        <description>
                Just test application
        </description>
        <servlet>
                <servlet-name>info</servlet-name>
                <display-name>info</display-name>
                <description>no description</description>
                <servlet-class>InfoServlet</servlet-class>
        </servlet>
        <servlet-mapping>
                <servlet-name>info</servlet-name>
                <url-pattern>/info</url-pattern>
        </servlet-mapping>
        <session-config>
                <session-timeout>30</session-timeout>
        </session-config>
        <resource-ref>
                <description>Database Connection</description>
                <res-ref-name>jdbc/BookDB</res-ref-name>
                <res-type>javax.sql.DataSource</res-type>
                <res-auth>Container</res-auth>
        </resource-ref>
</web-app>
---cut---here---

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