[Hibernate-JIRA] Created: (BVAL-116) BuiltinConstraints doesn't contain @Digits
by Juergen Zimmermann (JIRA)
BuiltinConstraints doesn't contain @Digits
------------------------------------------
Key: BVAL-116
URL: http://opensource.atlassian.com/projects/hibernate/browse/BVAL-116
Project: Bean Validation
Issue Type: Bug
Components: ri-general
Affects Versions: 4.0.0.Alpha1
Reporter: Juergen Zimmermann
I'll get this stacktrace:
javax.validation.ValidationException: Unable to find constraints for interface javax.validation.constraints.Digits
at org.hibernate.validation.engine.BuiltinConstraints.getBuiltInConstraints(BuiltinConstraints.java:114)
at org.hibernate.validation.engine.ConstraintDescriptorImpl.findConstraintClasses(ConstraintDescriptorImpl.java:126)
at org.hibernate.validation.engine.ConstraintDescriptorImpl.<init>(ConstraintDescriptorImpl.java:119)
at org.hibernate.validation.engine.ConstraintDescriptorImpl.<init>(ConstraintDescriptorImpl.java:101)
at org.hibernate.validation.engine.BeanMetaDataImpl.buildConstraintDescriptor(BeanMetaDataImpl.java:261)
at org.hibernate.validation.engine.BeanMetaDataImpl.findConstraintAnnotations(BeanMetaDataImpl.java:246)
at org.hibernate.validation.engine.BeanMetaDataImpl.findFieldLevelConstraints(BeanMetaDataImpl.java:329)
at org.hibernate.validation.engine.BeanMetaDataImpl.initFieldConstraints(BeanMetaDataImpl.java:189)
at org.hibernate.validation.engine.BeanMetaDataImpl.initClass(BeanMetaDataImpl.java:135)
at org.hibernate.validation.engine.BeanMetaDataImpl.createMetaData(BeanMetaDataImpl.java:106)
at org.hibernate.validation.engine.BeanMetaDataImpl.<init>(BeanMetaDataImpl.java:94)
at org.hibernate.validation.engine.ValidatorImpl.getBeanMetaData(ValidatorImpl.java:428)
at org.hibernate.validation.engine.ValidatorImpl.expandGroup(ValidatorImpl.java:406)
at org.hibernate.validation.engine.ValidatorImpl.validateInContext(ValidatorImpl.java:117)
at org.hibernate.validation.engine.ValidatorImpl.validate(ValidatorImpl.java:87)
at de.hska.kundenverwaltung.awk.KundenverwaltungBean.validate(KundenverwaltungBean.java:330)
at de.hska.kundenverwaltung.awk.KundenverwaltungBean.createKunden(KundenverwaltungBean.java:274)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor$InvocationContext.proceed(InvocationContextInterceptor.java:138)
at de.hska.util.StacktraceInterceptor.log(StacktraceInterceptor.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:83)
at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:70)
at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:59)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_4437435.invoke(InvocationContextInterceptor_z_fillMethod_4437435.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_4437435.invoke(InvocationContextInterceptor_z_setup_4437435.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.RunAsSecurityInterceptorv2.invoke(RunAsSecurityInterceptorv2.java:94)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptorv2.invoke(RoleBasedAuthorizationInterceptorv2.java:201)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:159)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:65)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:219)
at org.jboss.ejb3.proxy.handler.ProxyInvocationHandlerBase.invoke(ProxyInvocationHandlerBase.java:261)
at org.jboss.ejb3.proxy.handler.session.SessionSpecProxyInvocationHandlerBase.invoke(SessionSpecProxyInvocationHandlerBase.java:101)
at $Proxy454.createKunden(Unknown Source)
at de.hska.test.KundenverwaltungTestBean.createKunden(KundenverwaltungTestBean.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_4437435.invoke(InvocationContextInterceptor_z_fillMethod_4437435.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_4437435.invoke(InvocationContextInterceptor_z_setup_4437435.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.RunAsSecurityInterceptorv2.invoke(RunAsSecurityInterceptorv2.java:94)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptorv2.invoke(RoleBasedAuthorizationInterceptorv2.java:201)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:159)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:65)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:486)
at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:56)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:908)
at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:742)
at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:695)
at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:522)
at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:230)
at org.jboss.remoting.MicroRemoteClientInvoker.invoke(MicroRemoteClientInvoker.java:206)
at org.jboss.remoting.Client.invoke(Client.java:1708)
at org.jboss.remoting.Client.invoke(Client.java:612)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:60)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:61)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.client.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)
at $Proxy15.invoke(Unknown Source)
at org.jboss.ejb3.proxy.handler.ProxyInvocationHandlerBase.invoke(ProxyInvocationHandlerBase.java:261)
at org.jboss.ejb3.proxy.handler.session.SessionSpecProxyInvocationHandlerBase.invoke(SessionSpecProxyInvocationHandlerBase.java:101)
at $Proxy14.createKunden(Unknown Source)
at de.hska.test.KundenverwaltungTest.updateUpdateKunde(KundenverwaltungTest.java:440)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.experimental.theories.Theories$TheoryAnchor$2.evaluate(Theories.java:157)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.experimental.theories.Theories$TheoryAnchor$1$1.evaluate(Theories.java:123)
at org.junit.experimental.theories.Theories$TheoryAnchor.runWithCompleteAssignment(Theories.java:109)
at org.junit.experimental.theories.Theories$TheoryAnchor.runWithAssignment(Theories.java:93)
at org.junit.experimental.theories.Theories$TheoryAnchor.evaluate(Theories.java:79)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:72)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:61)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.client.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)
at $Proxy15.invoke(Unknown Source)
at org.jboss.ejb3.proxy.handler.ProxyInvocationHandlerBase.invoke(ProxyInvocationHandlerBase.java:261)
at org.jboss.ejb3.proxy.handler.session.SessionSpecProxyInvocationHandlerBase.invoke(SessionSpecProxyInvocationHandlerBase.java:101)
at $Proxy14.createKunden(Unknown Source)
at de.hska.test.KundenverwaltungTest.updateUpdateKunde(KundenverwaltungTest.java:440)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.experimental.theories.Theories$TheoryAnchor$2.evaluate(Theories.java:157)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.experimental.theories.Theories$TheoryAnchor$1$1.evaluate(Theories.java:123)
at org.junit.experimental.theories.Theories$TheoryAnchor.runWithCompleteAssignment(Theories.java:109)
at org.junit.experimental.theories.Theories$TheoryAnchor.runWithAssignment(Theories.java:93)
at org.junit.experimental.theories.Theories$TheoryAnchor.evaluate(Theories.java:79)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:45)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
17 years, 1 month
[Hibernate-JIRA] Created: (HBX-1102) @Temporal Annotation not generated in Composite-ID-Pojo
by Nils M (JIRA)
@Temporal Annotation not generated in Composite-ID-Pojo
-------------------------------------------------------
Key: HBX-1102
URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1102
Project: Hibernate Tools
Issue Type: Bug
Components: reverse-engineer
Affects Versions: 3.2.4 Beta1
Environment: Database: DB2
Hibernate-Tools: 3.2.4.Beta1, Hibernate-Tools.3.2.4.CR1
Reporter: Nils M
We do have a problem with generating pojos from a DB using hibernate tools.
We have several tables with a composite ID, e.g. in table T100 these are the fields 'DATE_FROM' and 'UB_ID'. The Hibernate Tool generate the following pojos from that table. The problem we have is, that within the first class the Annotation '@Temporal' is used, but in the second class the Annotation is missing. The DB (IBM DB2) responds with an error without this Annotation.
We used the Hibernate Tools 3.2.4.Beta1 and 3.2.4.CR1. The result is the same with both versions.
Table T100Ub
===========
@Entity
@Table(name="T100_UB"
)
public class T100Ub implements java.io.Serializable {
private T100UbId id;
private Date dateUntil;
....
@Temporal(TemporalType.DATE)
@Column(name="DATE_UNTIL", nullable=false, length=10)
public Date getDateUntil() {
return this.dateUntil;
}
...
}
Table T100UbId
=============
@Embeddable
public class T100UbId implements java.io.Serializable {
private int ubId;
private Date dateFrom;
...
@Column(name="DATE_FROM", nullable=false, length=10)
public Date getDateFrom() {
return this.dateFrom;
}
...
}
Thanks a lot in advance!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
17 years, 1 month
[Hibernate-JIRA] Deleted: (HHH-2623) DB2 Alias name too long
by Christian Bauer (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2623?page=c... ]
Christian Bauer deleted HHH-2623:
---------------------------------
> DB2 Alias name too long
> ------------------------
>
> Key: HHH-2623
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2623
> Project: Hibernate Core
> Issue Type: Bug
> Environment: DB2 v. 7, OS390.
> Reporter: Eric Scott
> Priority: Critical
>
> I am getting DB2 SQL error: SQLCODE: -107 (name too long) exceptions when trying to select rows based on Many-to-one or one-to-many relationships.
> Looking at the generated sql I can see that the Alias name generated for the TimeStamp column is one character too long for DB2's max of 18.
> The alias when not searching using a many-to-one or one-to-many relationship is SUBMISSION28_48_9_ but for the same property the alias changes to SUBMISSION28_48_10_ which is 19 chars long, one too many for DB2.
> Is this a bug in Hibernate's DB2390 dialect? I've seen similar problems in the forums and the only solution is to extend the dialect or Column class.
> Is there any other way to get rid of this problem?
> [b]Hibernate version:[/b]
> 3.0
> [b]Mapping documents:[/b]
> <?xml version="1.0"?>
> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
> >
> <hibernate-mapping>
> <class name="ca.gc.rcmp.rtid.npsnistserver.dao.submission.UISubmission" table="SUBMISSION" >
> <id name="submissionId" column="SUBMISSION_ID" type="java.lang.Long">
> <generator class="identity"/>
> </id>
>
> <property name="civilApplicationType" column="CIVIL_APP_TP" type="java.lang.Integer" />
> <property name="submissionTypeId" column="TOT_ID" type="java.lang.Integer" />
> <property name="originatingAgencyId" column="ORIG_AGCY_ORI" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType7" />
> <property name="dcn" column="DCN" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType20" />
> <property name="paperConversionNote" column="PAPER_CONV_NT" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType255" />
> <property name="paperConversionIndicator" column="PAPER_CONV_IND" type="java.lang.Boolean" />
> <property name="remandIndicator" column="REMAND_IND" type="java.lang.Boolean" not-null="true" />
> <property name="dispositionIndicator" column="DISPOSITION_IND" type="java.lang.Boolean" not-null="true" />
> <property name="sensitiveIndicator" column="SENSITIVE_IND" type="java.lang.Boolean" not-null="true" />
> <property name="foreignIndicator" column="FOREIGN_IND" type="java.lang.Boolean" not-null="true" />
> <property name="wipIndicator" column="WIP_IND" type="java.lang.Boolean" not-null="true" />
> <property name="thirdPartyAuthObtainedIndicator" column="TPTY_WAIVER_IND" type="java.lang.Boolean" not-null="true" />
> <property name="retentionDate" column="RETENTION_DT" type="java.util.Date" />
> <property name="biodataPurgeDate" column="BIODATA_PURGE_DT" type="java.util.Date" />
> <property name="caseFileNumber" column="CASE_FILE_NO" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType50" />
> <property name="responsiblePersonName" column="RESPBL_PRSN_NM" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType50" />
> <property name="slaId" column="SLA_ID" type="java.lang.Integer" />
> <property name="stateId" column="STATE_ID" type="java.lang.Integer" />
>
> <property name="foreignSearchReason" column="FOREIGN_SEARCH_RSN" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType500" />
> <property name="externalTCN" column="EXT_TCN" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType40" />
> <property name="civilApplicationTypeSpecify" column="CIVIL_APP_TP_SPEC" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType50" />
> <property name="agencyReferenceNumber" column="AGCY_REF_NO" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType32" />
>
> <property name="priority" column="PRIORITY" type="java.lang.Integer" />
> <property name="employmentInVulnerableSectorIndicator" column="EMP_VULNERABLE_IND" type="java.lang.Boolean" />
>
> <property name="endTimestamp" column="END_TMSTMP" type="java.util.Date" />
> <property name="submissionTimestamp" column="SUBMISSION_TMSTMP" type="java.util.Date" />
> <property name="sendResults" column="SEND_RESULTS" type="java.lang.Integer" />
> <property name="language" column="LANGUAGE" type="java.lang.Integer" />
> <property name="processID" column="PROCESS_ID" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType60" />
> <property name="outputScenarioID" column="OUTPUT_SCENARIO_ID" type="java.lang.Integer" />
> <property name="dnaIndicator" column="DNA_IND" type="java.lang.Boolean" not-null="true" />
>
>
> <property name="fbiStateId" column="FBI_STATE_ID" type="java.lang.Integer" />
> <property name="palmReverseSearchStateId" column="PLM_RSRH_STATE_ID" type="java.lang.Integer" />
> <property name="fingerReverseSearchStateId" column="FING_RSRH_STATE_ID" type="java.lang.Integer" />
> <property name="releaseRuleType" column="RELEASE_RULE_TP" type="java.lang.Integer" />
> <property name="latentFileId" column="LATENT_FILE_ID" type="java.lang.Integer" />
> <property name="resubmittedIndicator" column="RESUBMITTED_IND" type="java.lang.Boolean" not-null="true" />
> <property name="captureNodeLocation" column="CAPTURE_NODE_LOC" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType32" />
> <property name="operatorName" column="OPERATOR_NM" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType50" />
> <property name="forwardToOverride" column="FORWARD_TO_OVRD" type="ca.gc.rcmp.rtid.npsnistserver.util.TruncateStringType$TruncateStringType80" />
>
>
>
> <many-to-one name="crimsTeam" column="CRIMS_TEAM_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.icd.CommonCodeValue" insert="false" update="false" />
>
> <many-to-one name="sla" column="SLA_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.SLA" lazy="false" insert="false" update="false" />
> <many-to-one name="submissionType" column="TOT_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.icd.ICDSubmissionType" insert="false" update="false" />
> <many-to-one name="mainState" column="STATE_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.State" insert="false" update="false" />
> <many-to-one name="fbiState" column="FBI_STATE_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.State" insert="false" update="false" />
> <many-to-one name="palmReverseSearchState" column="PLM_RSRH_STATE_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.State" insert="false" update="false" />
> <many-to-one name="fingerReverseSearchState" column="FING_RSRH_STATE_ID" class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.State" insert="false" update="false" />
>
> <many-to-one name="originatingAgency" column="ORIG_AGCY_ORI" class="ca.gc.rcmp.rtid.npsnistserver.dao.agency.Agency" insert="false" update="false" />
>
> <bag name="biodataList" table="BIODATA" inverse="true"
> lazy="true" cascade="delete">
> <key column="SUBMISSION_ID" not-null="true"/>
> <one-to-many class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.Biodata" />
> </bag>
>
> <bag name="transactionList" table="TRANSACTION" inverse="true"
> lazy="true" cascade="all">
> <key column="SUBMISSION_ID" not-null="true"/>
> <one-to-many class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.Transaction" />
> </bag>
>
> <bag name="submissionFileNumbers" table="SUB_FILE_NUM" inverse="true"
> lazy="true" cascade="all">
> <key column="SUBMISSION_ID" not-null="true"/>
> <one-to-many class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.SubmissionFileNumber" />
> </bag>
> <bag name="activityLogs" table="ACTIVITY_LOG" inverse="true"
> lazy="true" cascade="all">
> <key column="SUBMISSION_ID" not-null="true"/>
> <one-to-many class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.ActivityLog" />
> </bag>
> <bag name="compressionRatioLogList" table="CMPRS_RTIO_LOG" inverse="true"
> lazy="true" cascade="all">
> <key column="SUBMISSION_ID" not-null="true"/>
> <one-to-many class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.CompressionRatioLog" />
> </bag>
>
> <bag name="masterDocumentReferenceNumbers" table="MASTER_DOC_REF" inverse="true"
> lazy="true" cascade="none">
> <key column="SUBMISSION_ID" />
> <one-to-many class="ca.gc.rcmp.rtid.npsnistserver.dao.submission.MasterDocumentReference" />
> </bag>
>
> </class>
>
> </hibernate-mapping>
> [b]Full stack trace of any exception that occurs:[/b]
> ca.gc.rcmp.rtid.npsnistserver.dao.NISTServerDAOException: org.hibernate.exception.SQLGrammarException: could not execute
> query
> at ca.gc.rcmp.rtid.npsnistserver.dao.SubmissionConsoleDAO.advancedSubmissionSearch(SubmissionConsoleDAO.java:648
> )
> at SubmissionConsole.SubmissionConsoleController.doAdvancedSubmissionSearch(SubmissionConsoleController.jpf:2419
> )
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at com.bea.wlw.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:1510)
> at com.bea.wlw.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:1445)
> at com.bea.wlw.netui.pageflow.FlowController.internalExecute(FlowController.java:776)
> at com.bea.wlw.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:211)
> at com.bea.wlw.netui.pageflow.FlowController.execute(FlowController.java:606)
> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
> at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:1354)
> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:650)
> at com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
> at com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
> at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
> at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at ca.gc.rcmp.rtid.npsnistserver.ui.filter.HibernateSessionRequestFilter.doFilter(HibernateSessionRequestFilter.
> java:56)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at ca.gc.rcmp.rtid.npsnistserver.ui.filter.CredentialsFilter.doFilter(CredentialsFilter.java:112)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:326)
> at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.superForward(PageFlowRequestProcessor.java:1301)
> at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor$DefaultHttpRedirector.forward(PageFlowRequestProcessor.ja
> va:1317)
> at com.bea.wlw.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:554)
> at com.bea.wlw.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:527)
> at com.bea.wlw.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:152)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072)
> at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
> at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at ca.gc.rcmp.rtid.npsnistserver.ui.filter.HibernateSessionRequestFilter.doFilter(HibernateSessionRequestFilter.
> java:56)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at ca.gc.rcmp.rtid.npsnistserver.ui.filter.CredentialsFilter.doFilter(CredentialsFilter.java:112)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
> at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6987)
> at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
> at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
> at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892)
> at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
> Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
> at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.loader.Loader.doList(Loader.java:1570)
> at org.hibernate.loader.Loader.list(Loader.java:1550)
> at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1252)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:299)
> at ca.gc.rcmp.rtid.npsnistserver.dao.SubmissionConsoleDAO.advancedSubmissionSearch(SubmissionConsoleDAO.java:645
> )
> ... 55 more
> Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -107, SQLSTATE: 42622, SQLERRMC: SUBMISSION28_48_10_;
> 18
> at com.ibm.db2.jcc.b.zc.e(zc.java:1606)
> at com.ibm.db2.jcc.b.zc.a(zc.java:1206)
> at com.ibm.db2.jcc.b.zc.a(zc.java:1192)
> at com.ibm.db2.jcc.a.db.h(db.java:142)
> at com.ibm.db2.jcc.a.db.a(db.java:43)
> at com.ibm.db2.jcc.a.r.a(r.java:30)
> at com.ibm.db2.jcc.a.sb.g(sb.java:152)
> at com.ibm.db2.jcc.b.zc.n(zc.java:1186)
> at com.ibm.db2.jcc.b.ad.db(ad.java:1763)
> at com.ibm.db2.jcc.b.ad.d(ad.java:2205)
> at com.ibm.db2.jcc.b.ad.U(ad.java:489)
> at com.ibm.db2.jcc.b.ad.executeQuery(ad.java:472)
> at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:124)
> at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:117)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1249)
> at org.hibernate.loader.Loader.doQuery(Loader.java:369)
> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:209)
> at org.hibernate.loader.Loader.doList(Loader.java:1567)
> ... 60 more
> [b]Name and version of the database you are using:[/b]
> DB2 v. 7 using DB2390Dialect.
> [b]The generated SQL (show_sql=true):[/b]
> Hibernate: select this_.SUBMISSION_ID as SUBMISSION1_10_, this_.CIVIL_APP_TP as CIVIL2_48_10_, this_.TOT_ID as TOT3_48_1
> 0_, this_.ORIG_AGCY_ORI as ORIG4_48_10_, this_.DCN as DCN48_10_, this_.PAPER_CONV_NT as PAPER6_48_10_, this_.PAPER_CONV_
> IND as PAPER7_48_10_, this_.REMAND_IND as REMAND8_48_10_, this_.DISPOSITION_IND as DISPOSIT9_48_10_, this_.SENSITIVE_IND
> as SENSITIVE10_48_10_, this_.FOREIGN_IND as FOREIGN11_48_10_, this_.WIP_IND as WIP12_48_10_, this_.TPTY_WAIVER_IND as T
> PTY13_48_10_, this_.RETENTION_DT as RETENTION14_48_10_, this_.BIODATA_PURGE_DT as BIODATA15_48_10_, this_.CASE_FILE_NO a
> s CASE17_48_10_, this_.RESPBL_PRSN_NM as RESPBL18_48_10_, this_.SLA_ID as SLA19_48_10_, this_.STATE_ID as STATE20_48_10_
> , this_.FOREIGN_SEARCH_RSN as FOREIGN21_48_10_, this_.EXT_TCN as EXT22_48_10_, this_.CIVIL_APP_TP_SPEC as CIVIL23_48_10_
> , this_.AGCY_REF_NO as AGCY24_48_10_, this_.PRIORITY as PRIORITY48_10_, this_.EMP_VULNERABLE_IND as EMP26_48_10_, this_.
> END_TMSTMP as END27_48_10_, this_.SUBMISSION_TMSTMP as SUBMISSION28_48_10_, this_.SEND_RESULTS as SEND29_48_10_, this_.L
> ANGUAGE as LANGUAGE48_10_, this_.PROCESS_ID as PROCESS31_48_10_, this_.OUTPUT_SCENARIO_ID as OUTPUT32_48_10_, this_.DNA_
> IND as DNA33_48_10_, this_.FBI_STATE_ID as FBI34_48_10_, this_.PLM_RSRH_STATE_ID as PLM35_48_10_, this_.FING_RSRH_STATE_
> ID as FING36_48_10_, this_.RELEASE_RULE_TP as RELEASE37_48_10_, this_.LATENT_FILE_ID as LATENT38_48_10_, this_.RESUBMITT
> ED_IND as RESUBMI39_48_10_, this_.CAPTURE_NODE_LOC as CAPTURE40_48_10_, this_.OPERATOR_NM as OPERATOR41_48_10_, this_.FO
> RWARD_TO_OVRD as FORWARD42_48_10_, this_.CRIMS_TEAM_ID as CRIMS43_48_10_, commoncode4_.COMMON_CD_VAL_ID as COMMON1_0_, c
> ommoncode4_.COMMON_CD_TBL_ID as COMMON2_36_0_, commoncode4_.CODE as CODE36_0_, commoncode4_.NAME_EN as NAME4_36_0_, comm
> oncode4_.NAME_FR as NAME5_36_0_, icdsubmiss5_.TOT_ID as TOT1_1_, icdsubmiss5_.TOT_ACRONYM as TOT2_2_1_, icdsubmiss5_.NAM
> E_EN as NAME3_2_1_, icdsubmiss5_.NAME_FR as NAME4_2_1_, icdsubmiss5_.SERVICE_NAME_EN as SERVICE5_2_1_, icdsubmiss5_.SERV
> ICE_NAME_FR as SERVICE6_2_1_, icdsubmiss5_.RETAIN_FL as RETAIN7_2_1_, icdsubmiss5_.INCOMING_TX as INCOMING8_2_1_, icdsub
> miss5_.SUBMISSION_CAT_ID as SUBMISSION9_2_1_, icdsubmiss6_.SUBMISSION_CAT_ID as SUBMISSION1_2_, icdsubmiss6_.NAME_EN as
> NAME2_3_2_, icdsubmiss6_.NAME_FR as NAME3_3_2_, state1_.STATE_ID as STATE1_3_, state1_.NAME_EN as NAME2_63_3_, state1_.N
> AME_FR as NAME3_63_3_, state1_.INSERVICE as INSERVICE63_3_, agency8_.RTID_ORI as RTID1_4_, agency8_.XREF_ORI as XREF2_44
> _4_, agency8_.FORMAL_NAME as FORMAL3_44_4_, agency8_.CMN_NAME_EN as CMN4_44_4_, agency8_.CMN_NAME_FR as CMN5_44_4_, agen
> cy8_.SECTION_NAME as SECTION6_44_4_, agency8_.HOST_CPIC_ORI as HOST7_44_4_, agency8_.RTID_TRANS_ORI as RTID8_44_4_, agen
> cy8_.CPIC_AGCY_ST as CPIC9_44_4_, agency8_.NON_CDN_IND as NON10_44_4_, agency8_.CVL_BULK_BILL_IND as CVL11_44_4_, agency
> 8_.CPIC_USR_AGCY_IND as CPIC12_44_4_, agency8_.NON_CNV_ELG_IND as NON13_44_4_, agency8_.YOUNG_PRSN_ELG_IND as YOUNG14_44
> _4_, agency8_.VUL_SCTR_ELIG_IND as VUL15_44_4_, agency8_.AGENCY_GROUP_ID as AGENCY16_44_4_, agency8_.AGENCY_TP_ID as AGE
> NCY17_44_4_, agency8_.PREFERRED_LANG as PREFERRED18_44_4_, agency8_.AUTO_RELEASE_LVL as AUTO19_44_4_, agency8_.CONTACT_T
> ITLE as CONTACT20_44_4_, agency8_.PHY_CIVIC_ADDR as PHY21_44_4_, agency8_.PHY_MUNIC as PHY22_44_4_, agency8_.PHY_POSTAL_
> CD as PHY23_44_4_, agency8_.PHY_PROV_ST_CD as PHY24_44_4_, agency8_.PHY_CNTRY_ISO_CD as PHY25_44_4_, agency8_.PHY_PHONE_
> NO as PHY26_44_4_, agency8_.PHY_PHONE_EXTN as PHY27_44_4_, agency8_.PHY_FAX_NO as PHY28_44_4_, agency8_.OPERATIONAL_EMAI
> L as OPERATI29_44_4_, agency8_.SYSTEM_TP_ID as SYSTEM30_44_4_, agency8_.RIN as RIN44_4_, agency8_.MLG_ATTENTION_NM as ML
> G32_44_4_, agency8_.MLG_CIVIC_ADDR as MLG33_44_4_, agency8_.MLG_MUNIC as MLG34_44_4_, agency8_.MLG_POSTAL_CD as MLG35_44
> _4_, agency8_.MLG_CNTRY_SUBDV_CD as MLG36_44_4_, agency8_.MLG_CNTRY_ISO_CD as MLG37_44_4_, agency8_.DEVICE_INTR_TP_ID as
> DEVICE38_44_4_, agency8_.TRANS_ROUTING_LOC as TRANS39_44_4_, agency8_.FBI_ORDER_IND as FBI40_44_4_, agency8_.CREATED_DT
> as CREATED41_44_4_, agency8_.LAST_MODIFIED_DT as LAST42_44_4_, commoncode9_.COMMON_CD_VAL_ID as COMMON1_5_, commoncode9
> _.COMMON_CD_TBL_ID as COMMON2_36_5_, commoncode9_.CODE as CODE36_5_, commoncode9_.NAME_EN as NAME4_36_5_, commoncode9_.N
> AME_FR as NAME5_36_5_, commoncode10_.COMMON_CD_VAL_ID as COMMON1_6_, commoncode10_.COMMON_CD_TBL_ID as COMMON2_36_6_, co
> mmoncode10_.CODE as CODE36_6_, commoncode10_.NAME_EN as NAME4_36_6_, commoncode10_.NAME_FR as NAME5_36_6_, commoncode11_
> .COMMON_CD_VAL_ID as COMMON1_7_, commoncode11_.COMMON_CD_TBL_ID as COMMON2_36_7_, commoncode11_.CODE as CODE36_7_, commo
> ncode11_.NAME_EN as NAME4_36_7_, commoncode11_.NAME_FR as NAME5_36_7_, commoncode12_.COMMON_CD_VAL_ID as COMMON1_8_, com
> moncode12_.COMMON_CD_TBL_ID as COMMON2_36_8_, commoncode12_.CODE as CODE36_8_, commoncode12_.NAME_EN as NAME4_36_8_, com
> moncode12_.NAME_FR as NAME5_36_8_, submission2_.SUB_FILE_NUM_ID as SUB1_9_, submission2_.SUBMISSION_ID as SUBMISSION2_55
> _9_, submission2_.FILE_TP_ID as FILE3_55_9_, submission2_.FILE_NO as FILE4_55_9_, submission2_.SUBMITTED_IND as SUBMITTE
> D5_55_9_, submission2_.ASSIGNED_IND as ASSIGNED6_55_9_, submission2_.CERTIFIED_IND as CERTIFIED7_55_9_, submission2_.HIT
> _IND as HIT8_55_9_, submission2_.FAIL_CERT_IND as FAIL9_55_9_ from NPSNIST.SUBMISSION this_ left outer join NPSNIST.COMM
> ON_CODE_VALUE commoncode4_ on this_.CRIMS_TEAM_ID=commoncode4_.COMMON_CD_VAL_ID left outer join NPSNIST.SUBMISSION_TYPE
> icdsubmiss5_ on this_.TOT_ID=icdsubmiss5_.TOT_ID left outer join NPSNIST.SUBMISSION_CAT icdsubmiss6_ on icdsubmiss5_.SUB
> MISSION_CAT_ID=icdsubmiss6_.SUBMISSION_CAT_ID inner join NPSNIST.STATE state1_ on this_.STATE_ID=state1_.STATE_ID left o
> uter join NPSNIST.AGENCY agency8_ on this_.ORIG_AGCY_ORI=agency8_.RTID_ORI left outer join NPSNIST.COMMON_CODE_VALUE com
> moncode9_ on agency8_.AGENCY_GROUP_ID=commoncode9_.COMMON_CD_VAL_ID left outer join NPSNIST.COMMON_CODE_VALUE commoncode
> 10_ on agency8_.AGENCY_TP_ID=commoncode10_.COMMON_CD_VAL_ID left outer join NPSNIST.COMMON_CODE_VALUE commoncode11_ on a
> gency8_.DEVICE_INTR_TP_ID=commoncode11_.COMMON_CD_VAL_ID left outer join NPSNIST.COMMON_CODE_VALUE commoncode12_ on agen
> cy8_.SYSTEM_TP_ID=commoncode12_.COMMON_CD_VAL_ID inner join NPSNIST.SUB_FILE_NUM submission2_ on this_.SUBMISSION_ID=sub
> mission2_.SUBMISSION_ID where (this_.TOT_ID=? or this_.TOT_ID=? or this_.TOT_ID=? or this_.TOT_ID=? or this_.TOT_ID=? or
> this_.TOT_ID=? or this_.TOT_ID=?) and (state1_.INSERVICE=?) and submission2_.FILE_TP_ID=? and submission2_.FILE_NO like
> ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
17 years, 1 month
[Hibernate-JIRA] Created: (EJB-414) getSingleResult breaks native queries
by ChB (JIRA)
getSingleResult breaks native queries
-------------------------------------
Key: EJB-414
URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-414
Project: Hibernate Entity Manager
Issue Type: Bug
Components: EntityManager
Affects Versions: 3.4.0.GA
Environment: Hibernate 3.3.1.GA, Oracle 9i
Reporter: ChB
Mapping:
@NamedNativeQuery(name = "X", query = "{? = call XYZ(?, ?)}", resultSetMapping = "XM", hints = { @QueryHint(name = "org.hibernate.callable", value = "true") })
@SqlResultSetMapping(name = XM", columns = { @ColumnResult(name = "x") })
DAO:
final Query q = this.em.createNamedQuery("X");
q.setParameter(1, "whatever");
q.setParameter(2, "whatever");
final String x = (String) q.getSingleResult();
Causes hibernate to die with:
[main] org.hibernate.SQL: select * from ( {? = call XYZ(?, ?)} ) where rownum <= ?
This happens because the query (class SQLQueryImpl) has a selection.maxRows value of 2 for no reason by the following line (QueryImpl.java:87)
if (maxResults != 1) query.setMaxResults( 2 );
This line should not be executed if the underlying query is a native query. As it will break like shown in http://forum.hibernate.org/viewtopic.php?p=2406045 and you have no chance of fixing it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
17 years, 1 month
[Hibernate-JIRA] Created: (HHH-3775) Generated SQL query size is unacceptable
by Loïc Lefèvre (JIRA)
Generated SQL query size is unacceptable
----------------------------------------
Key: HHH-3775
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3775
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: 3.2.6, Oracle platform
Reporter: Loïc Lefèvre
Priority: Critical
Attachments: query_original.sql, query_without_column_aliases.sql
In the attachment, there is a query generated by Hibernate.
The size of the query text is 96579 bytes. This is an extreme example just to show the problem.
There are 22993 bytes used for alias purpose which represents 24% of the size of the query.
According to a recent audit from Oracle, it appears that this kind of query just overflow the SQL area
thus degrading overall performances: library cache miss ratio: 97-99% during peak activity.
Please stop column aliases generation for Oracle and use real column names *when appropriate*
(count(*) may need a column alias).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
17 years, 1 month