I'm also using the 1.1.x branch, at revision 9938, using mysql5 with the DDL script from svn, but I don't see this error.
> Looks like the HOST_REGISTRATION table is missing a default value. The database schema shouldn't have default values for ID columns, since the JPA implementation takes care of ID generation. Here's the relevant Java that determines this behavior (from HostRegistration.java): @Id @Column @GeneratedValue protected Long id; By default, Eclipselink uses a table named "SEQUENCE" to hand out identifiers. I've included some information about my mysql server below. Are you running a different mysql version? Is the code revision you're running aligned with the DDL revision? Thanks, Josh mysql> \s -------------- mysql Ver 14.12 Distrib 5.0.91, for apple-darwin10.0 (i386) using EditLine wrapper Connection id: 1 Current database: matterhorn Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.0.91-log Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/mysql/mysql.sock Uptime: 3 days 22 hours 42 min 1 sec Threads: 4 Questions: 527 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 13 Queries per second avg: 0.002 -------------- mysql> describe host_registration; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | ID | bigint(20) | NO | PRI | NULL | | | HOST | varchar(255) | NO | UNI | NULL | | | MAINTENANCE | tinyint(1) | NO | | 0 | | | MAX_JOBS | int(11) | NO | | NULL | | | ONLINE | tinyint(1) | NO | | 0 | | +-------------+--------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) On Sat, Feb 19, 2011 at 5:38 AM, Lovemore Nalube <[email protected]> wrote: > > Hi Everyone > > I'm sitting on this database error at host registration: > > Caused by: org.opencastproject.serviceregistry.api.ServiceRegistryException: > javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse > Persistence Services - 2.0.2.v20100323-r6872): > org.eclipse.persistence.exceptions.DatabaseException > Internal Exception: java.sql.SQLException: Field 'ID' doesn't have a default > value > Error Code: 1364 > Call: INSERT INTO HOST_REGISTRATION (HOST, MAINTENANCE, MAX_JOBS, ONLINE) > VALUES (?, ?, ?, ?) > bind => [http://srvslsopc003.uct.ac.za, false, 4, true] > Query: InsertObjectQuery(http://gsadcbjdhbv.uct.ac.za) > at > org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.registerHost(ServiceRegistryJpaImpl.java:468) > at > org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.activate(ServiceRegistryJpaImpl.java:161) > This happens on a clean install of Matterhorn and MySql (v5.5.9-1) after > manually running the ddl sql scripts. The Matterhorn startup fails after this. > > Looks like the HOST_REGISTRATION table is missing a default value. If this is > a bug on the 1.1.x branch I'll file a jira. > > Thanks > > > -- > Lovemore Nalube > OLE Developer (Vula) > University of Cape Town > http://www.cet.uct.ac.za/LovemoreN > > > ### > > UNIVERSITY OF CAPE TOWN > > This e-mail is subject to the UCT ICT policies and e-mail disclaimer > published on our website at > http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 > 21 650 9111. This e-mail is intended only for the person(s) to whom it is > addressed. If the e-mail has reached you in error, please notify the author. > If you are not the intended recipient of the e-mail you may not use, > disclose, copy, redirect or print the content. If this e-mail is not related > to the business of UCT it is sent by the sender in the sender's individual > capacity. > > ### > > _______________________________________________ > Matterhorn mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/matterhorn > > > To unsubscribe please email > [email protected] > _______________________________________________ _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
