Re: JDBC Connection lost every morning.

communities@jivesoftware.com — Mon, 08 Dec 2008 00:22:19 GMT

Is anything showing up in your logs in the morning? Can you post them? Also, what version of MySQL and MySQL connector is this?

JDBC Connection lost every morning.

mking@eapps.com — Sat, 22 Nov 2008 04:21:13 GMT

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>
    
    
    
    
    <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

Jivespace: Message List - JDBC Connection lost every morning.

Re: JDBC Connection lost every morning.

JDBC Connection lost every morning.