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
Please sign in to leave a comment.
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
>
>
>
>
>
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