ConnectionPooling / java.net.SocketException

[Christopher Stephan]

Hi,
I have following problem:

I have an application which works fine, if only one users is active.
If two users act at nearly the same time I always get following error:
Unexpected Exception: java.sql.SQLException message given: Communication
link failure: java.net.SocketException.

It seems to me that it has something to do with the Connection Pooling or
any mysql setting.
Has anybody of you any idea?

I have following settings in the server.xml:
<DefaultContext cookies="true" crossContext="true" reloadable="true">
    <Resource name="jdbc/test" auth="Container"
type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/test">
        <parameter>
            <name>user</name>
            <value></value>
        </parameter>
        <parameter>
            <name>password</name>
            <value></value>
        </parameter>
        <parameter>
            <name>driverClassName</name>
            <value>org.gjt.mm.mysql.Driver</value>
        </parameter>
        <parameter>
            <name>driverName</name>
            <value>jdbc:mysql://localhost/xudoo</value>
        </parameter>
    </ResourceParams>
</DefaultContext>

And following settings in the web.xml:
<resource-ref id="ResourceRef_2">
    <description>
        bla
    </description>
    <res-ref-name>jdbc/test</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>CONTAINER</res-auth>
</resource-ref>

Configuration:
Tomcat 4.0.4.
MySql 3.23.47
Struts Beta2


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