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
