Hi,
It seems that there is a problem with the TEST_USER and TEST_GROUP tables from the cornerstonedemo-schema.xml file when using MySQL. The schema contains :
<table name="TEST_USER">
<column name="ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="LOGIN_NAME" type="VARCHAR"/>
<column name="FIRST_NAME" type="VARCHAR"/>
<column name="LAST_NAME" type="VARCHAR"/>
</table>
<table name="TEST_GROUP">
<column name="ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="NAME" type="VARCHAR"/>
</table>There is no size attribute on the VARCHAR types, and MySQL requires this to be set, as the VARCHAR type is limited to 255 under MySQL 4 (MySQL 5 automatically handles this case but it's still in Alpha). Anyway I think it is reasonable to limit the size of these fields as they should not need to be unlimited.
A suggestion would be therefore :
<table name="TEST_USER">
<column name="ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="LOGIN_NAME" size="30" type="VARCHAR"/>
<column name="FIRST_NAME" size="50" type="VARCHAR"/>
<column name="LAST_NAME" size="50" type="VARCHAR"/>
</table>
<table name="TEST_GROUP">
<column name="ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="NAME" size="30" type="VARCHAR"/>
</table>Note that the sizes here we set arbitrarely, without looking at the code, so there might be some assumptions that are missing. Anyway, hope this helps...
Regards, Serge Huber.
- -- --- -----=[ serge.huber at jahia dot com ]=---- --- -- -
Jahia : A collaborative source CMS and Portal Server
www.jahia.org Community and product web site
www.jahia.com Commercial services company
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
