Cannot convert to database with MySQL 5.6+
Jonathan Carter <[email protected]> Wed, 20 Nov 2013 16:41:00 +0000
| Newsgroups | gmane.comp.misc.ontology.protege.general |
|---|---|
| Message-ID | <[email protected]> |
--===============8618535624185466805== Content-Type: multipart/alternative; boundary="Apple-Mail=_0D2899AA-46F4-4595-85C2-046998EF2EC2" --Apple-Mail=_0D2899AA-46F4-4595-85C2-046998EF2EC2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii I have encountered the following error when attempting to convert a = Protege project to a Protege Database in MySQL 5.6 and above. 2013.09.27 20:30:17.953 BST INFO: Creating database indicies: -- = DefaultDatabaseFrameDb.createIndices() 2013.09.27 20:30:18.875 BST WARNING: Failed to create table on database = MySQL with command 'CREATE TABLE essentialRepository1 (frame = VARBINARY(310) NOT NULL, frame_type SMALLINT NOT NULL, slot = VARBINARY(310) NOT NULL, facet VARBINARY(310) NOT NULL, is_template BIT = NOT NULL, value_index INT NOT NULL, value_type SMALLINT NOT NULL, = short_value VARCHAR(310) COLLATE utf8_general_ci, long_value MEDIUMTEXT) = ENGINE =3D INNODB DEFAULT CHARACTER SET 'utf8'' :Specified key was too = long; max key length is 767 bytes -- = DefaultDatabaseFrameDb.createTable() 2013.09.27 20:30:18.937 BST WARNING: Errors at copying knowledgebase = jdbc:mysql://localhost/essential -- = com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key = was too long; max key length is 767 bytes Specifically, the issue appears to be with the key lengths.=20 MySQL 5.5. works perfectly. I have seen this with Protege 3.4.8 and cannot see anything in the = release notes for Protege 3.5 about this. Has it been addressed in = version 3.5? I know that MySQL is one of the recommended databases for = Protege but currently we cannot use MySQL beyond version 5.5 Thanks in advance Jonathan _______________________________________ Jonathan Carter=20 Enterprise Architecture Solutions Ltd _______________________________________ Proud sponsors of The Essential Project The free open-source Enterprise Architecture Management Platform www.enterprise-architecture.org _______________________________________ Enterprise Architecture Solutions Ltd, Registered in England and Wales: = 04097721. Registered Office: 76 High Street, Newport Pagnell, Milton Keynes, MK16 = 8AQ. --Apple-Mail=_0D2899AA-46F4-4595-85C2-046998EF2EC2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dus-ascii"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">I have = encountered the following error when attempting to convert a Protege = project to a Protege Database in MySQL 5.6 and = above.<div><br></div><div>2013.09.27 20:30:17.953 BST INFO: Creating = database indicies: -- = DefaultDatabaseFrameDb.createIndices()<br>2013.09.27 20:30:18.875 BST = WARNING: Failed to create table on database MySQL with command = 'CREATE TABLE essentialRepository1 (frame VARBINARY(310) NOT NULL, = frame_type SMALLINT NOT NULL, slot VARBINARY(310) NOT NULL, facet = VARBINARY(310) NOT NULL, is_template BIT NOT NULL, value_index = INT NOT NULL, value_type SMALLINT NOT NULL, short_value = VARCHAR(310) COLLATE utf8_general_ci, long_value MEDIUMTEXT) ENGINE = =3D INNODB DEFAULT CHARACTER SET 'utf8'' :Specified key was too long; = max key length is 767 bytes -- = DefaultDatabaseFrameDb.createTable()<br>2013.09.27 20:30:18.937 BST = WARNING: Errors at copying knowledgebase = jdbc:mysql://localhost/essential = -- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: = Specified key was too long; max key length is = 767 bytes</div><div><br></div><div>Specifically, the issue appears = to be with the key lengths. </div><div><br></div><div>MySQL 5.5. = works perfectly.</div><div><br></div><div>I have seen this with Protege = 3.4.8 and cannot see anything in the release notes for Protege 3.5 about = this. Has it been addressed in version 3.5? I know that MySQL is one of = the recommended databases for Protege but currently we cannot use MySQL = beyond version 5.5</div><div><br></div><div>Thanks in = advance</div><div><br></div><div>Jonathan<br><div = apple-content-edited=3D"true"> <span class=3D"Apple-style-span" style=3D"border-collapse: separate; = border-spacing: 0px;"><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-style: normal; font-variant: normal; font-weight: = normal; letter-spacing: normal; line-height: normal; orphans: 2; = text-indent: 0px; text-transform: none; white-space: normal; widows: 2; = word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"border-collapse: separate; color: rgb(0, 0, 0); font-family: = Helvetica; font-style: normal; font-variant: normal; font-weight: = normal; letter-spacing: normal; line-height: normal; orphans: 2; = text-indent: 0px; text-transform: none; white-space: normal; widows: 2; = word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; = -webkit-border-vertical-spacing: 0px; = -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: = auto; -webkit-text-stroke-width: 0px; "><div style=3D"word-wrap: = break-word; -webkit-nbsp-mode: space; -webkit-line-break: = after-white-space; "><span class=3D"Apple-style-span" = style=3D"font-family: verdana; font-size: 12px; "><span = style=3D"font-family: verdana; font-size: 12px; font-weight: normal; = color: rgb(196, 30, 58); = ">_______________________________________</span><br><br><span = style=3D"font-family: verdana; font-size: 12px; font-weight: bold; = color: rgb(0, 0, 0); ">Jonathan Carter</span> <br><span = style=3D"font-family: verdana; font-size: 12px; font-weight: bold; = color: rgb(196, 30, 58); ">Enterprise Architecture Solutions = Ltd</span><br><br><span style=3D"font-family: verdana; font-size: 12px; = font-weight: normal; color: rgb(192, 192, 192); = ">_______________________________________</span><br><br><span = style=3D"font-family: verdana; font-size: 11px; font-weight: bold; = color: rgb(196, 30, 58); font-style: italic; "><span = class=3D"Apple-style-span" style=3D"font-style: normal; ">Proud sponsors = of </span><span style=3D"color: rgb(0, 0, 0); "><span = class=3D"Apple-style-span" style=3D"font-style: normal; ">The Essential = Project</span></span><br><span class=3D"Apple-style-span" = style=3D"font-style: normal; "><span class=3D"Apple-style-span" = style=3D"font-weight: normal; "><font class=3D"Apple-style-span" = color=3D"#5F5E5F">The free open-source Enterprise Architecture = Management Platform</font></span></span><br></span><span = style=3D"font-family: verdana; font-size: 11px; font-weight: normal; = "><a href=3D"http://www.enterprise-architecture.org/" style=3D"color: = rgb(196, 30, 58); ">www.enterprise-architecture.org</a></span><br><span = style=3D"font-family: verdana; font-size: 12px; font-weight: normal; = color: rgb(192, 192, 192); = ">_______________________________________</span><span = style=3D"font-family: verdana; font-size: 10px; font-weight: bold; = color: rgb(192, 192, 192); letter-spacing: 1px; "><br></span><br><span = style=3D"font-family: verdana; font-size: 10px; font-weight: normal; = "><font class=3D"Apple-style-span" color=3D"#797979">Enterprise = Architecture Solutions Ltd, Registered in England and Wales: = 04097721.<br>Registered Office: 76 High Street, Newport Pagnell, Milton = Keynes, MK16 8AQ.</font></span></span></div></span></div></span></span> </div> <br></div></body></html>= --Apple-Mail=_0D2899AA-46F4-4595-85C2-046998EF2EC2-- --===============8618535624185466805== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ protege-discussion mailing list [email protected] https://mailman.stanford.edu/mailman/listinfo/protege-discussion Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03 --===============8618535624185466805==--