JpaServiceRegistry with MySQL backend

[Romain Bourgue]

Hi,

I've set the ServiceRegistryDao to use a database for persistance. I set my 
application context as attached.

The datasource configuration seems to be ok as it creates the table in the database.
But, when I try to save a registered service in the service manager interface, I 
get this exception :

Hibernate: insert into RegisteredServiceImpl (allowedAttributes, allowedToProxy, 
anonymousAccess, description, enabled, name, serviceId, ssoEnabled, theme, id) 
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2007-08-09 18:51:58,706 ERROR [org.hibernate.util.JDBCExceptionReporter] - <No 
value specified for parameter 10>

Even if the id field in RegisteredServiceImpl table is auto-increment, Hibernate 
tries to set a value for it... is it normal ?

No query is sent to the MySQL server, the exception is raised before.


Did I miss something ?


Romain


--Snip from applicationContext.xml

	<bean id="serviceRegistryDao" 
class="org.jasig.cas.services.JpaServiceRegistryDaoImpl"
    p:entityManagerFactory-ref="entityManagerFactory" />

<!-- This is the EntityManagerFactory configuration for Hibernate -->
	<bean id="entityManagerFactory" 
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="jpaVendorAdapter">
			<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
				<property name="generateDdl" value="true"/>
				<property name="showSql" value="true" />
			</bean>
		</property>
		<property name="jpaProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.hbm2ddl.auto">create-drop</prop>
			</props>
		</property>
	</bean>

--