Services Management using MySQL with Hibernate

Scott Battaglia scott.battaglia at gmail.com
Mon Oct 15 22:47:43 EDT 2007 

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 <harryworld at gmail.com> 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
> cas at tp.its.yale.edu
> http://tp.its.yale.edu/mailman/listinfo/cas
>
>


-- 
-Scott Battaglia

LinkedIn: http://www.linkedin.com/in/scottbattaglia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://tp.its.yale.edu/pipermail/cas/attachments/20071015/6c0aa4ec/attachment.html

More information about the cas mailing list