Datasource issues local

[David Whitehurst]

I'm using this config for my datasource where I use AppFuse DAO and managers and then Struts2 Controllers for serving JSON using REST to a GWT App.

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="maxActive" value="100"/>
        <property name="maxWait" value="1000"/>
        <property name="poolPreparedStatements" value="true"/>
        <property name="defaultAutoCommit" value="true"/>
    </bean>


I'm using an SWT Refresh in the GWT whereby the URL for the JSON is requested on a timer.  Any suggestions on how to NOT get "Internal Server Errors" requiring a MySQL restart.  I have to restart MySQL because I've exceeded connections.  Is there a way to keep the same connection maybe?

Thoughts?


David

[mraible]

I'm not sure of the answer, but you might ask on the user list since I believe there's folks that've experienced (and solved) this issue.

Matt

On Mon, May 4, 2009 at 7:55 PM, David Whitehurst <[hidden email]> wrote:

I'm using this config for my datasource where I use AppFuse DAO and managers and then Struts2 Controllers for serving JSON using REST to a GWT App.

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="maxActive" value="100"/>
        <property name="maxWait" value="1000"/>
        <property name="poolPreparedStatements" value="true"/>
        <property name="defaultAutoCommit" value="true"/>
    </bean>


I'm using an SWT Refresh in the GWT whereby the URL for the JSON is requested on a timer.  Any suggestions on how to NOT get "Internal Server Errors" requiring a MySQL restart.  I have to restart MySQL because I've exceeded connections.  Is there a way to keep the same connection maybe?

Thoughts?


David

[mraible]

Specifically: http://markmail.org/message/vyohh6teo7yfkx5f

On Mon, May 4, 2009 at 9:43 PM, Matt Raible <[hidden email]> wrote:

I'm not sure of the answer, but you might ask on the user list since I believe there's folks that've experienced (and solved) this issue.

Matt

On Mon, May 4, 2009 at 7:55 PM, David Whitehurst <[hidden email]> wrote:

I'm using this config for my datasource where I use AppFuse DAO and managers and then Struts2 Controllers for serving JSON using REST to a GWT App.

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="maxActive" value="100"/>
        <property name="maxWait" value="1000"/>
        <property name="poolPreparedStatements" value="true"/>
        <property name="defaultAutoCommit" value="true"/>
    </bean>


I'm using an SWT Refresh in the GWT whereby the URL for the JSON is requested on a timer.  Any suggestions on how to NOT get "Internal Server Errors" requiring a MySQL restart.  I have to restart MySQL because I've exceeded connections.  Is there a way to keep the same connection maybe?

Thoughts?


David