DO NOT REPLY [Bug 14565] New: - Tomcat Server hangs and does not make entries in the database

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=14565>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=14565

Tomcat Server hangs and does not make entries in the database

           Summary: Tomcat Server hangs and does not make entries in the
                    database
           Product: Tomcat 4
           Version: 4.1.12
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Catalina
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I finally figured what entries to make in the server.xml to look up the 
Datasource using JNDI. The problem is when I do to make an entry in the 
database,the server hangs. I checked the database table and no entry was made 
there.

Here is the corresponding entries in the server.xml:

    <Resource name="jdbc/Questions" scope="Shareable" 
type="javax.sql.DataSource"/>
 <ResourceParams name="jdbc/Questions">
      <parameter>
        <name>validationQuery</name>
        <value></value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:weblogic:mssqlserver4:Questions@localhost</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value></value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>weblogic.jdbc.mssqlserver4.Driver</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>sa</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>

The corresponding entries in the web.xml:

 <resource-ref>
             <res-ref-name>jdbc/Questions</res-ref-name>
              <res-type>javax.sql.DataSource</res-type>
              <res-auth>Container</res-auth>
</resource-ref>

I am using MSSQL driver from weblogic to update the table in MSSQL server.

--
To unsubscribe, e-mail:   <mailto:tomcat-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-dev-help@;jakarta.apache.org>