File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exception during installation

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I'm getting the following exception when installing JForum 2.1.8 via the web installer:



This is happening on a Vista Ultimate x86 machine + JDK 6 + Tomcat 6 + MySQL 5.0.45. Any ideas how to fix it?
[originally posted on jforum.net by Ree]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A quick guess is that there is a missmatch between your MySQL database encoding and your Java encoding settings. Make sure that your tables/database is set to at least UTF-8.
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL server and database charsets are set to utf8.

I also ran

on an empty database I created for JForum.
[originally posted on jforum.net by Ree]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A google for this error showed that it's a common issue with some recent 5.0 MySQL JDBC driver versions. Try updating your JDBC driver jar to the latest from MySQL.

Here's a good thread talking about the problem.

http://forums.mysql.com/read.php?39,139534,139534#msg-139534
[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, ugrading to the latest MySQL connector fixed the problem.

I'm wondering why JForum developers are still using mysql-connector-java-5.0.3-bin.jar which is over a year old?
[originally posted on jforum.net by Ree]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Helping support guys have job security... wait.. nobody gets paid for this... :lol:

Just simply being human and having other jobs to work at and it works fine on the developer/testers boxes.

But, fwiw, put a Jira issue in on it so that it is less likely to fall thru the cracks during the next release.
[originally posted on jforum.net by monroe]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic