Hi all,

Would anyonw happen to know why a jdbc connection will be dead every moring?  Everything is fine all day but in the morning the server needs to be restarted.

Database settings in jive_startup.xml

<database>
    <!-- Uncomment to enable Unicode support when using MySQL -->
    <!-- <mysql><useUnicode>true</useUnicode></mysql> -->
    <!-- Uncomment to enable Statement caching when using Oracle JDBC -->
    <!-- <oracle><useStatementCache>true</useStatementCache></oracle> -->
    <defaultProvider>
      <username>xxxuser</username>
      <maxConnections>75</maxConnections>
      <minConnections>10</minConnections>
      <serverURL>jdbc:mysql://xxxserver:3306//xxxdb?autoConnect=true</serverURL>
      <driver>com.mysql.jdbc.Driver</driver>
      <connectionTimeout>0.3</connectionTimeout>
      <password>xxxpass</password>
      <checkOpenConnections>true</checkOpenConnections>
    </defaultProvider>
  </database>

my.cnf on remote mysql server

[mysqld]
max_allowed_packet=16M
interactive_timeout=86400