Hi,

i got an strange problem with the BatchedStatistics.
my catalina.log contains a lot of this exceptions:

java.sql.BatchUpdateException: Data truncation: Data too long for
column 'PAGE' at row 1 at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.flush(BatchedStatistics.java:174)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.checkAndDoFlush(BatchedStatistics.java:87)
at
org.apache.jetspeed.statistics.impl.BatchedStatistics.run(BatchedStatistics.java:133)
at java.lang.Thread.run(Thread.java:595)

and the tables are not truncat so that it reach 1GB size in 1 week

the analyses get me an max value of 72 for the column 'PAGE' on table
'PAGE_STATISTICS' and 'PORTLET_STATISTICS'

 i use an tomcat 5.5.26 with jetspeed 2.1.3-dev
andPAGE_STATISTICS mysql-connector-java-5.0.4-bin.jar within an mysql
db ver 5.0.45

the same configuration used with mysql-connector-java-3.0.17-ga-bin.jar
is without this error.

someone else with the same problem?

greetings

-- 

Ralf Rublack
University of Leipzig
Student

Attachment: signature.asc
Description: PGP signature

Reply via email to