aspose file tools*
The moose likes JForum and the fly likes summary bug Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "summary bug" Watch "summary bug" New topic
Author

summary bug

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi!
I configured the summary to send daily at 21:00.
Some days I receive the message and some days - not
I found out in log file - in the day it success :

Job going to be executed: net.jforum.summary.SummaryJob, null[Sun Jan 14 21:30:00 NZDT 2007]
21:30:00,027 INFO [SummaryModel ] Sending Weekly summary...
21:30:00,549 INFO [SimpleListener ] Job execution ended: net.jforum.summary.SummaryJob, null[Sun Jan 14 21:30:00 NZDT 2007

and in other day (not success):

Job going to be executed: net.jforum.summary.SummaryJob, null[Tue Jan 16 21:30:00 NZDT 2007]
21:30:00,031 WARN [SummaryJob ] com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at net.jforum.dao.generic.GenericSummaryDAO.listRecipients(GenericSummaryDAO.java:118)
at net.jforum.summary.SummaryModel.listRecipients(SummaryModel.java:112)
at net.jforum.summary.SummaryJob.execute(SummaryJob.java:66)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.
21:30:00,031 INFO [SimpleListener ] Job execution ended: net.jforum.summary.SummaryJob, null[Tue Jan 16 21:30:00 NZDT 2007]

What can be a reason of this exception and how can I solve it?
Thank you

[originally posted on jforum.net by yanam]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thank you for reporting this. I will look into this soon.

What JForum version are you using by the way?
[originally posted on jforum.net by lazee]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Append the following string to your mysql connection string (WEB-INF/config/database/mysql/mysql.properties):



Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I use 2.1.6
[originally posted on jforum.net by yanam]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
yanam wrote:I use 2.1.6


Please try the suggestion from Rafael
[originally posted on jforum.net by lazee]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thank you very much!!
I put it in the WEB-INF/config/database/mysql/mysql.properties and in the ... /jforum-custom too
like this:
database.connection.string=jdbc\:mysql\://${database.connection.host}\:${database.connection.port}/${database.connection.dbname}?user\=${database.connection.username}&password\=${database.connection.password}&autoReconnect\=true${mysql.unicode}${mysql.encoding}&useNewIO\=false&zeroDateTimeBehavior\=convertToNull&useServerPrepStmts\=false &jdbcCompliantTruncation\=false

Ihope it help. Iwill see it during some days of correct work
[originally posted on jforum.net by yanam]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael!
it not helped
which connection implementation must be: pooled or simple???
[originally posted on jforum.net by yanam]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: summary bug