Scott,
I used this dependency.
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<version>3.3.1.ga</version>
</dependency>
This will depend on the hibernate-core 3.2.4, which is where the problem
comes from.
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2605
I manually include 3.2.5 and things work fine now.
Who controls this dependency? (Hibernate?) Could we do something to force
the include of 3.2.5 besides adding manually to pom.xml in webapp?
Thanks,
Harry
scott_battaglia wrote:
>
> Harry,
>
> Which version of Hibernate are you using? One recent version had a bug
> with
> fields that could AUTOINCREMENT.
>
> -Scott
>
> On 10/15/07, Harry Ng <[EMAIL PROTECTED]> wrote:
>>
>> Dear Scott,
>>
>> I have almost successfully configured the Services Management to use
>> MySQL
>> with Hibernate in storing the services. After it automatically creates
>> the
>> table in MySQL DB, I tried to add the first service in the web interface,
>> but then it fails.
>>
>> It said that "Statement parameter 10 not set" which as shown in the
>> Hibernate log, it should be the "id" not set. Is it a problem with the
>> use
>> of MySQL?
>>
>> Regards,
>> Harry
>>
>> ==========================================
>> Hibernate: insert into RegisteredServiceImpl (allowedAttributes,
>> allowedToProxy, anonymousAccess, description, enabled, name, serviceId,
>> ssoEnabled, theme, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
>> 2007-10-16 10:29:24,260 ERROR [ org.hibernate.util.JDBCExceptionReporter]
>> - <Statement parameter 10 not set.>
>> 2007-10-16 10:29:24,260 ERROR
>> [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/cas].[cas]]
>> - <Servlet.service() for servlet cas threw exception>
>> javax.persistence.PersistenceException:
>> org.hibernate.exception.GenericJDBCException: could not insert: [
>> org.jasig.cas.services.RegisteredServiceImpl]
>> at
>> org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException (
>> AbstractEntityManagerImpl.java:630)
>> at org.hibernate.ejb.AbstractEntityManagerImpl.merge(
>> AbstractEntityManagerImpl.java:237)
>> at org.springframework.orm.jpa.JpaTemplate$6.doInJpa(JpaTemplate.java
>> :272)
>> at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java
>> :191)
>> at
>> org.springframework.orm.jpa.JpaTemplate.merge(JpaTemplate.java:270)
>> at org.jasig.cas.services.JpaServiceRegistryDaoImpl.save(
>> JpaServiceRegistryDaoImpl.java :36)
>> at org.jasig.cas.services.DefaultServicesManagerImpl.save(
>> DefaultServicesManagerImpl.java:101)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>> at java.lang.reflect.Method.invoke(Unknown Source)
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (
>> AopUtils.java:296)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
>> (ReflectiveMethodInvocation.java:177)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (
>> ReflectiveMethodInvocation.java:144)
>> at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(
>> TransactionInterceptor.java:107)
>> at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (
>> ReflectiveMethodInvocation.java:166)
>> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:204)
>> at $Proxy11.save(Unknown Source)
>> at
>> org.jasig.cas.services.web.RegisteredServiceSimpleFormController.onSubmit(
>> RegisteredServiceSimpleFormController.java:78)
>> at
>> org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission
>> (SimpleFormController.java:267)
>> at
>> org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(
>> AbstractFormController.java:250)
>> at
>> org.springframework.web.servlet.mvc.AbstractController.handleRequest(
>> AbstractController.java:153)
>> at
>> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(
>> SimpleControllerHandlerAdapter.java:48)
>> at org.springframework.web.servlet.DispatcherServlet.doDispatch(
>> DispatcherServlet.java:857)
>> at org.springframework.web.servlet.DispatcherServlet.doService(
>> DispatcherServlet.java :792)
>> at org.springframework.web.servlet.FrameworkServlet.processRequest(
>> FrameworkServlet.java:475)
>> at org.springframework.web.servlet.FrameworkServlet.doPost(
>> FrameworkServlet.java:440)
>> at javax.servlet.http.HttpServlet.service (HttpServlet.java:709)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>> at org.jasig.cas.web.init.SafeDispatcherServlet.service(
>> SafeDispatcherServlet.java:115)
>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (
>> ApplicationFilterChain.java:252)
>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>> ApplicationFilterChain.java:173)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
>> (FilterChainProxy.java :265)
>> at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(
>> FilterSecurityInterceptor.java:107)
>> at
>> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(
>> FilterSecurityInterceptor.java :72)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
>> (FilterChainProxy.java:275)
>> at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(
>> ExceptionTranslationFilter.java:110)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
>> (FilterChainProxy.java:275)
>> at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(
>> AbstractProcessingFilter.java:229)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(
>> FilterChainProxy.java:275)
>> at
>> org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java
>> :106)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
>> (FilterChainProxy.java:275)
>> at
>> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(
>> HttpSessionContextIntegrationFilter.java:286)
>> at
>> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter
>> (FilterChainProxy.java:275)
>> at org.acegisecurity.util.FilterChainProxy.doFilter(
>> FilterChainProxy.java:149)
>> at org.acegisecurity.util.FilterToBeanProxy.doFilter(
>> FilterToBeanProxy.java:98)
>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (
>> ApplicationFilterChain.java:202)
>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>> ApplicationFilterChain.java:173)
>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>> StandardWrapperValve.java :213)
>> at org.apache.catalina.core.StandardContextValve.invoke(
>> StandardContextValve.java:178)
>> at org.apache.catalina.core.StandardHostValve.invoke(
>> StandardHostValve.java:126)
>> at org.apache.catalina.valves.ErrorReportValve.invoke (
>> ErrorReportValve.java:105)
>> at org.apache.catalina.core.StandardEngineValve.invoke(
>> StandardEngineValve.java:107)
>> at org.apache.catalina.connector.CoyoteAdapter.service(
>> CoyoteAdapter.java:148)
>> at org.apache.coyote.http11.Http11Processor.process (
>> Http11Processor.java:869)
>> at
>> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
>> (Http11BaseProtocol.java:664)
>> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
>> PoolTcpEndpoint.java :527)
>> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
>> LeaderFollowerWorkerThread.java:80)
>> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
>> ThreadPool.java:684)
>> at java.lang.Thread.run (Unknown Source)
>>
>> --
>> My Weblog - http://blog.planner4u.org/
>> LinkedIn - http://www.linkedin.com/in/harryng
>> _______________________________________________
>> Yale CAS mailing list
>> [email protected]
>> http://tp.its.yale.edu/mailman/listinfo/cas
>>
>>
>
>
> --
> -Scott Battaglia
>
> LinkedIn: http://www.linkedin.com/in/scottbattaglia
>
> _______________________________________________
> Yale CAS mailing list
> [email protected]
> http://tp.its.yale.edu/mailman/listinfo/cas
>
>
--
View this message in context:
http://www.nabble.com/Services-Management-using-MySQL-with-Hibernate-tf4631681.html#a13235005
Sent from the CAS Users mailing list archive at Nabble.com.
_______________________________________________
Yale CAS mailing list
[email protected]
http://tp.its.yale.edu/mailman/listinfo/cas
