Services Management using MySQL with Hibernate
Scott Battaglia
scott.battaglia at gmail.com
Tue Oct 16 11:18:34 EDT 2007
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 <harryworld at gmail.com> 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 <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
> >
> > _______________________________________________
> > Yale CAS mailing list
> > cas at tp.its.yale.edu
> > 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
> 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/20071016/29fd5f4c/attachment.html
More information about the cas
mailing list