I solved this problem for someone once before, but I can't remember what I said to do. :-) It might be in the archives though.
-Scott On 10/16/07, Harry Ng <[EMAIL PROTECTED]> wrote: > > > 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 > -- -Scott Battaglia LinkedIn: http://www.linkedin.com/in/scottbattaglia
_______________________________________________ Yale CAS mailing list [email protected] http://tp.its.yale.edu/mailman/listinfo/cas
