[Building Sakai] ENTITY_ Tables

[Aaron Zeckoski]

Those are just the typical INFO level messages which you are free to
ignore (in essence, the DDL already ran and cannot run again because
the tables already exist).

-AZ


On Wed, May 9, 2012 at 4:33 AM, David Horwitz <david.horwitz at uct.ac.za> wrote:
> Hi all
>
> on current trunk I'm seing this on the 2nd and subsequent startup:
>
> INFO Registered entity provider
> (org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl$2)
> prefix (batch) with 1 capabilities
> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_PROPERTIES (
> id            bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
> entityRef       varchar(255) NOT NULL, entityPrefix    varchar(255) NOT
> NULL, propertyName    varchar(255) NOT NULL, propertyValue   text NOT
> NULL, INDEX (entityRef, entityPrefix, propertyName) )]; nested exception
> is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'ENTITY_PROPERTIES' already
> exists:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'ENTITY_PROPERTIES' already exists
> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_TAG_APPLICATIONS
> ( id            bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
> entityRef       varchar(255) NOT NULL, entityPrefix    varchar(255) NOT
> NULL, tag             varchar(255) NOT NULL, INDEX (entityRef,
> entityPrefix, tag) )]; nested exception is
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'ENTITY_TAG_APPLICATIONS' already
> exists:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'ENTITY_TAG_APPLICATIONS' already exists
>
>
> The second and later restarts also fail. I'm not sure why
>
> D
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"



-- 
Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile