Help with MySQL

I got fed up with HSQLDB crashing and taking all my data, so I'm trying
to install MySql. The database is up and running, but when I try to
start the TeamCity server I just get very long stack trace with
ERROR - r.serverSide.impl.DatabaseUtil -

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: All parts of a
PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

at the top.

Which version of MySQL should I be using?
http://www.jetbrains.net/confluence/display/TW/TeamCity+FAQ
says 4.1.18 or later, or 5.0.X with 5.0 JDBC driver
http://www.jetbrains.com/teamcity/documentation/faq.html
doesn't give a MySQL version, but it says version 3.1 of the JDBC driver.

Am I using the wrong driver version (I'm on server v 3.23.58)? Or is
there some other setup step I need to do?

Thanks,
R

2 comments
Comment actions Permalink

Hello Robert,

Supported MySQL version is 4.1.18 or later. Version 3.23.58 will not work.
As for JDBC driver - you should download the most recent version. I think
the exception you got will disappear if you upgrade your MySQL.

--
Pavel Sher

"Robert Gibson" <robbie_usenet@yahoo.co.uk> wrote in message
news:eit1av$aet$1@is.intellij.net...
>I got fed up with HSQLDB crashing and taking all my data, so I'm trying to
>install MySql. The database is up and running, but when I try to start the
>TeamCity server I just get very long stack trace with

ERROR - r.serverSide.impl.DatabaseUtil -

>

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: All parts of a
PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE
instead
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

>

at the top.

>

Which version of MySQL should I be using?
http://www.jetbrains.net/confluence/display/TW/TeamCity+FAQ
says 4.1.18 or later, or 5.0.X with 5.0 JDBC driver
http://www.jetbrains.com/teamcity/documentation/faq.html
doesn't give a MySQL version, but it says version 3.1 of the JDBC driver.

>

Am I using the wrong driver version (I'm on server v 3.23.58)? Or is there
some other setup step I need to do?

>

Thanks,
R



0
Comment actions Permalink

Hi Pavel,
Thanks for your quick answer. You should probably update the page
http://www.jetbrains.com/teamcity/documentation/faq.html#Advanced_topics
with this information.

Regards,
R

0

Please sign in to leave a comment.