AgileTrack
Put your development on the AgileTrack

Unknown initial character set error

I am new to AgileTrack but our company is very interesting in adopting this software. I have installed the client software and have been able to use AgileTrack with hsqldb but I am getting the following error when trying to use mySql:
Login cannot be performed. Trouble connecting to the AgileTrack server: java.sql.SQLException: Unknown character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.
We are using mySQL 5.0.21. Does anyone have any ideas what may be causing this error?

—Posted by Sharon on Dec 28, 2007


	Forum AgileTrack Client


	Reply

The JDBC connection string is using characterEncoding=utf8. This error looks the same as one I found here:

http://forums.mysql.com/read.php?39,139534,162839#msg-162839

The solution appears to be to update the JDBC connector. The current MySQL connector being used is mysql-connector-java-5.0.4-bin.jar. I sounds like it was fixed in 5.0.5. The latest connector version is 5.1.5. Could you try removing the old connector jar and replacing it with the current one?

http://dev.mysql.com/downloads/connector/j/5.1.html

If it works, please let me know, and I'll update the connector used for future distributions. Thanks.

—Posted by Adam Lane on Jan 2, 2008 at 7:30:45 AM

Thanks! That worked perfectly.

—Posted by Sharon on Jan 2, 2008 at 8:06:04 AM