Alright, here it goes. I'm running 4 instances of this Java/MySQL raw stats parser, and after TONS of modding to be compliant with MySQL 4.1+, I'm stuck at this dumb error. I can honestly say I've spent 10+ hours working to make this right, and this last dumb error has me stumped. I need to set the property jdbcCompliantTruncation to false, but I don't know where to set it to that, or how. I'm guessing it'd be in the jconnector. The reason it's a big deal is because as soon as the parser encounters an error, it immediately stops and doesn't continue. Here's the dump:
select(bf) 0.4 - A Battlefield XML Log File Parser
----------------------------------------------------
Copyright (C) 2003 Tim Adler
Published under GPL
http://www.gnu.org/licenses/gpl.txt
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
Available at
select(bf) - A Battlefield 1942/Vietnam XML-logparser and statistics-generator
----------------------------------------------------
Using Database-Config as follows:
otb1@otbclub.net:3306
User: ********** Password:**********
---------------------------------------------------
Logs-Directory: \\gamesrv1\Srv1Logs
-> processing File 'ev_14567-20070414_0722.xml' (1/18) PROBLEM with the database: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated; out of range for column 'score' at row 1 - Please check your config!
---DONE---
-----------------PRECACHING DATA-----------------
Please wait this takes a while
-> Caching 'Character-Type Usage' FINISHED (0.234 sec)
-> Caching 'Vehicle Usage' FINISHED (0.235 sec)
-> Caching 'Weapon Kills' FINISHED (0.25 sec)
-> Caching 'Player Ranking' FINISHED (0.75 sec)
-> Caching 'Map Statistics' FINISHED (0.562 sec)
---------------------------------------------------
Process FINISHED
Thanks for using select(bf)!
---------------------------------------------------