Anonymous - 2009-10-12

Hi.

I am running Webtest and after each test I am using sqlunit to update a mysql database with the result.

After about 30 mins of running (about 30% through the test suite) I get the following error:

  sqlunit-ant: PermGen space

  PermGen space

This is my sqlunit code:

       <?xml version="1.0"?>
    <!DOCTYPE sqlunit SYSTEM "../dtd/sqlunit.dtd">
    <sqlunit>
        <connection>
            <driver>com.mysql.jdbc.Driver</driver>
            <url>jdbc:mysql://10.140.84.213:3306/csspqa</url>
            <user>*****</user>
            <password>*****</password>
        </connection>
        <setup>
            <set name="${ant.bug}">
                <sql>
                    <stmt>
                         INSERT INTO test_results
         ( bug_id, ip , version , application , test_id , time_stamp , test_result )
         VALUES
         ('${ant.bug.ID}', '${ant.p4.client}', '${ant.BuildNumber}' , '${ant.basepath}' , '${ant.test.ID}' , NOW(), '${ant.testresult}');
                    </stmt>
                </sql>
                <result>
                    <resultset id="1">
                        <row id="1">
                            <col id="1" name="BUNDLE_ID" type="NUMERIC">${status}</col>
                        </row>
                    </resultset>
                </result>  
            </set>
        </setup>
        <echo name="BuildNumber" text="${ant.BuildNumber}"/>
        <echo name="test id" text="${ant.test.ID}"/>
        <echo name="test result" text="${ant.testresult}"/>
        <echo name="basepath" text="${ant.basepath}"/>
        <echo name="bug.ID" text="${ant.bug.ID}"/>

How do I avoid this problem or resolve it?

Thanks