Integration Tests fail

[krimple]

Drat, was worth a try

OK, at least you are approaching it the right way. I'm not sure what else could be happening. Last suggestion is to trace your SQL very carefully and see what is being outputted from Hibernate.

Anyway, Happy New Year!

Ken

[sanjoykr78]

Hi,
Thank you very much. Looking forward to see your book in Roo. It is a great RAD tool. Happy New Year.

[gowtamcs]

Guys, I have similar question in Spring roo. I tried to create a entity using 'database reverse engineer' command and generated the test classes using 'test integration entity name'. Then I ran the 'perform tests' command and all my tests fails. I db configurations are for oracle using hibernate.

Please help me out if I am doing any thing wrong

-------------------------------------------------------------------------------
Test set: com.enets.db.NetPackageIntegrationTest
-------------------------------------------------------------------------------
Tests run: 7, Failures: 0, Errors: 7, Skipped: 0, Time elapsed: 22.186 sec <<< FAILURE!
testMarkerMethod(com.enets.db.NetPackageIntegratio nTest) Time elapsed: 4.733 sec <<< ERROR!
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.TestContext.getAp plicationContext(TestContext.java:308)
at org.springframework.test.context.support.Dependenc yInjectionTestExecutionListener.injectDependencies (DependencyInjectionTestExecutionListener.java:109 )
at org.springframework.test.context.support.Dependenc yInjectionTestExecutionListener.prepareTestInstanc e(DependencyInjectionTestExecutionListener.java:75 )
at org.springframework.test.context.TestContextManage r.prepareTestInstance(TestContextManager.java:321)
at org.springframework.test.context.junit4.SpringJUni t4ClassRunner.createTest(SpringJUnit4ClassRunner.j ava:220)
at org.springframework.test.context.junit4.SpringJUni t4ClassRunner$1.runReflectiveCall(SpringJUnit4Clas sRunner.java:301)
at org.junit.internal.runners.model.ReflectiveCallabl e.run(ReflectiveCallable.java:15)
at org.springframework.test.context.junit4.SpringJUni t4ClassRunner.methodBlock(SpringJUnit4ClassRunner. java:303)
at org.springframework.test.context.junit4.SpringJUni t4ClassRunner.runChild(SpringJUnit4ClassRunner.jav a:240)
at org.junit.runners.BlockJUnit4ClassRunner.runChild( BlockJUnit4ClassRunner.java:50)
at org.junit.runners.ParentRunner$3.run(ParentRunner. java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRu nner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentR unner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRu nner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRu nner.java:184)
at org.springframework.test.context.junit4.statements .RunBeforeTestClassCallbacks.evaluate(RunBeforeTes tClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements .RunAfterTestClassCallbacks.evaluate(RunAfterTestC lassCallbacks.java:70)
at org.junit.runners.ParentRunner.run(ParentRunner.ja va:236)
at org.springframework.test.context.junit4.SpringJUni t4ClassRunner.run(SpringJUnit4ClassRunner.java:180 )
at org.apache.maven.surefire.junit4.JUnit4TestSet.exe cute(JUnit4TestSet.java:59)
at org.apache.maven.surefire.suite.AbstractDirectoryT estSuite.executeTestSet(AbstractDirectoryTestSuite .java:115)
at org.apache.maven.surefire.suite.AbstractDirectoryT estSuite.execute(AbstractDirectoryTestSuite.java:1 02)
at org.apache.maven.surefire.Surefire.run(Surefire.ja va:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.maven.surefire.booter.SurefireBooter.ru nSuitesInProcess(SurefireBooter.java:350)
at org.apache.maven.surefire.booter.SurefireBooter.ma in(SurefireBooter.java:1021)
Caused by: org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'transactionManager' defined in class path resource [META-INF/spring/applicationContext.xml]: Cannot resolve reference to bean 'entityManagerFactory' while setting bean property 'entityManagerFactory'; nested exception is org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'entityManagerFactory' defined in class path resource [META-INF/spring/applicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: netsDev] Unable to build EntityManagerFactory
at org.springframework.beans.factory.support.BeanDefi nitionValueResolver.resolveReference(BeanDefinitio nValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefi nitionValueResolver.resolveValueIfNecessary(BeanDe finitionValueResolver.java:106)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.applyPropertyValues(Abs tractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.populateBean(AbstractAu towireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.doCreateBean(AbstractAu towireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getObject(AbstractBeanFactory.java:2 91)
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:222)
at org.springframework.beans.factory.support.Abstract BeanFactory.doGetBean(AbstractBeanFactory.java:288 )
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.preInstantiateSingletons(Defaul tListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplic ationContext.finishBeanFactoryInitialization(Abstr actApplicationContext.java:895)
at org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContext.ja va:425)
at org.springframework.test.context.support.AbstractG enericContextLoader.loadContext(AbstractGenericCon textLoader.java:84)
at org.springframework.test.context.support.AbstractG enericContextLoader.loadContext(AbstractGenericCon textLoader.java:1)
at org.springframework.test.context.TestContext.loadA pplicationContext(TestContext.java:280)
at org.springframework.test.context.TestContext.getAp plicationContext(TestContext.java:304)
... 28 more
Caused by: org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'entityManagerFactory' defined in class path resource [META-INF/spring/applicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: netsDev] Unable to build EntityManagerFactory
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.initializeBean(Abstract AutowireCapableBeanFactory.java:1420)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.doCreateBean(AbstractAu towireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getObject(AbstractBeanFactory.java:2 91)
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:222)
at org.springframework.beans.factory.support.Abstract BeanFactory.doGetBean(AbstractBeanFactory.java:288 )
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefi nitionValueResolver.resolveReference(BeanDefinitio nValueResolver.java:322)
... 44 more
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: netsDev] Unable to build EntityManagerFactory
at org.hibernate.ejb.Ejb3Configuration.buildEntityMan agerFactory(Ejb3Configuration.java:911)
at org.hibernate.ejb.HibernatePersistence.createConta inerEntityManagerFactory(HibernatePersistence.java :74)
at org.springframework.orm.jpa.LocalContainerEntityMa nagerFactoryBean.createNativeEntityManagerFactory( LocalContainerEntityManagerFactoryBean.java:225)
at org.springframework.orm.jpa.AbstractEntityManagerF actoryBean.afterPropertiesSet(AbstractEntityManage rFactoryBean.java:308)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.invokeInitMethods(Abstr actAutowireCapableBeanFactory.java:1477)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.initializeBean(Abstract AutowireCapableBeanFactory.java:1417)
... 51 more
Caused by: org.hibernate.HibernateException: Wrong column type in schema.NET_PACKAGE for column NET_PACKAGE_ID. Found: char, expected: varchar2(255)
at org.hibernate.mapping.Table.validateColumns(Table. java:283)
at org.hibernate.cfg.Configuration.validateSchema(Con figuration.java:1313)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validat e(SchemaValidator.java:139)
at org.hibernate.impl.SessionFactoryImpl.<init>(Sessi onFactoryImpl.java:376)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1842)
at org.hibernate.ejb.Ejb3Configuration.buildEntityMan agerFactory(Ejb3Configuration.java:902)
... 56 more

[krimple]

Can you tell us more? Seems like a problem with the datatype mappings - what database? Can you show us the entity and it's _Roo_Entity / rev engineered version?

Ken

[gowtamcs]

Hello karen, here is the _roo_entity. I am using Hibernate with oracle as my database am conencting to is oracle.

// WARNING: DO NOT EDIT THIS FILE. THIS FILE IS MANAGED BY SPRING ROO.
// You may push code into the target .java compilation unit if you wish to edit any member(s).

package com.enets.db;

import com.enets.db.NetPackage;
import java.lang.String;
import java.util.List;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityManager;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.PersistenceContext;
import javax.persistence.Table;
import org.springframework.transaction.annotation.Transac tional;

privileged aspect NetPackage_Roo_Entity {

declare @type: NetPackage: @Entity;

declare @type: NetPackage: @Table(name = "NET_PACKAGE", schema = "DBA");

@PersistenceContext
transient EntityManager NetPackage.entityManager;

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "NET_PACKAGE_ID")
private String NetPackage.netPackageId;

public String NetPackage.getNetPackageId() {
return this.netPackageId;
}

public void NetPackage.setNetPackageId(String id) {
this.netPackageId = id;
}

@Transactional
public void NetPackage.persist() {
if (this.entityManager == null) this.entityManager = entityManager();
this.entityManager.persist(this);
}

@Transactional
public void NetPackage.remove() {
if (this.entityManager == null) this.entityManager = entityManager();
if (this.entityManager.contains(this)) {
this.entityManager.remove(this);
} else {
NetPackage attached = NetPackage.findNetPackage(this.netPackageId);
this.entityManager.remove(attached);
}
}

@Transactional
public void NetPackage.flush() {
if (this.entityManager == null) this.entityManager = entityManager();
this.entityManager.flush();
}

@Transactional
public NetPackage NetPackage.merge() {
if (this.entityManager == null) this.entityManager = entityManager();
NetPackage merged = this.entityManager.merge(this);
this.entityManager.flush();
return merged;
}

public static final EntityManager NetPackage.entityManager() {
EntityManager em = new NetPackage().entityManager;
if (em == null) throw new IllegalStateException("Entity manager has not been injected (is the Spring Aspects JAR configured as an AJC/AJDT aspects library?)");
return em;
}

public static long NetPackage.countNetPackages() {
return entityManager().createQuery("select count(o) from NetPackage o", Long.class).getSingleResult();
}

public static List<NetPackage> NetPackage.findAllNetPackages() {
return entityManager().createQuery("select o from NetPackage o", NetPackage.class).getResultList();
}

public static NetPackage NetPackage.findNetPackage(String id) {
if (id == null || 0 == id.length()) return null;
return entityManager().find(NetPackage.class, id);
}

public static List<NetPackage> NetPackage.findNetPackageEntries(int firstResult, int maxResults) {
return entityManager().createQuery("select o from NetPackage o", NetPackage.class).setFirstResult(firstResult).setM axResults(maxResults).getResultList();
}

}

[gowtamcs]

Funny thing is I found the below exceptions for Type mismatch also. But even before this it complains it cannot load application context. This is the logs I pasted in the first instance. is there any thing I need to do to load the applicationconect , because I expect roo generates all these classes and I dont have to do any thing.

Caused by: org.hibernate.HibernateException: Wrong column type in DBA.NET_PACKAGE for column NET_PACKAGE_ID. Found: char, expected: varchar2(255)
at org.hibernate.mapping.Table.validateColumns(Table. java:283)
at org.hibernate.cfg.Configuration.validateSchema(Con figuration.java:1313)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validat e(SchemaValidator.java:139)
at org.hibernate.impl.SessionFactoryImpl.<init>(Sessi onFactoryImpl.java:376)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1842)
at org.hibernate.ejb.Ejb3Configuration.buildEntityMan agerFactory(Ejb3Configuration.java:902)
... 56 more

[krimple]

tell me more about NET_PACKAGE_ID. it is a string? Auto key generation on Oracle would default to a sequence - the default will be hibernate_sequence.
But you have this as a string which the db tells us is a char field. I don't think the built-in key generators will take that as a datatype.

How do you assign primary keys today?

My guess would be that you should push-in the primary key and its related getter/setter to the Java entity, and tailor the strategy - for example if you are using a uuid or guid generated into a string, that is not out-of-the-box behavior in JPA or Spring - you have to adjust your @GeneratedVAlue and pick the right generation strategy.

Ken

[gowtamcs]

Thanks Ken. NET_PACKAGE_ID is generated by our application and its a alphanumeric value, ex - '4KV16ICJCH6QB1ZPC22XV'.Do you suggest to push NET_PACKAGE_ID to the entity object and try it out? Does the @GeneratedVAlue for this attribute has to be done in the Entity?

[gowtamcs]

After Push-In I am still getting the same problem. Seems like Application context is not loading properly. Any suggestions?


ASPECTJ: aspectj.overweaving=true: overweaving switched ON
Jan 18, 2011 9:27:29 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
[TomcatWeavingInsightClassLoader@1e17cff] warning javax.* types are not being woven because the weaver option '-Xset:weaveJavaxPackages=true' has not been specified
2011-01-18 21:27:46,657 [main] ERROR org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'transactionManager' defined in file [C:\sts\tc-server-developer-2.1.1.RELEASE\spring-insight-instance\wtpwebapps\NETSPACKAGE\WEB-INF\classes\META-INF\spring\applicationContext.xml]: Cannot resolve reference to bean 'entityManagerFactory' while setting bean property 'entityManagerFactory'; nested exception is org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'entityManagerFactory' defined in file [C:\sts\tc-server-developer-2.1.1.RELEASE\spring-insight-instance\wtpwebapps\NETSPACKAGE\WEB-INF\classes\META-INF\spring\applicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: netsDev] Unable to build EntityManagerFactory
at org.springframework.beans.factory.support.BeanDefi nitionValueResolver.resolveReference(BeanDefinitio nValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefi nitionValueResolver.resolveValueIfNecessary(BeanDe finitionValueResolver.java:106)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.applyPropertyValues(Abs tractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.populateBean(AbstractAu towireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.doCreateBean(AbstractAu towireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getObject(AbstractBeanFactory.java:2 91)
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:222)
at org.springframework.beans.factory.support.Abstract BeanFactory.doGetBean(AbstractBeanFactory.java:288 )
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultL istableBeanFactory.preInstantiateSingletons(Defaul tListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplic ationContext.finishBeanFactoryInitialization(Abstr actApplicationContext.java:895)
at org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContext.ja va:425)
at org.springframework.web.context.ContextLoader.crea teWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.init WebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListe ner.contextInitialized(ContextLoaderListener.java: 47)
at org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:4135)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4630)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:568)
at org.apache.catalina.startup.HostConfig.deployDescr iptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescr iptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1282)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:807)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:445)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:519)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:414)
Caused by: org.springframework.beans.factory.BeanCreationExce ption: Error creating bean with name 'entityManagerFactory' defined in file [C:\sts\tc-server-developer-2.1.1.RELEASE\spring-insight-instance\wtpwebapps\NETSPACKAGE\WEB-INF\classes\META-INF\spring\applicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: netsDev] Unable to build EntityManagerFactory
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.initializeBean(Abstract AutowireCapableBeanFactory.java:1420)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.doCreateBean(AbstractAu towireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.Abstract AutowireCapableBeanFactory.createBean(AbstractAuto wireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.Abstract BeanFactory$1.getObject(AbstractBeanFactory.java:2 91)
at org.springframework.beans.factory.support.DefaultS ingletonBeanRegistry.getSingleton(DefaultSingleton BeanRegistry.java:222)
at org.springframework.beans.factory.support.Abstract BeanFactory.doGetBean(AbstractBeanFactory.java:288 )
at org.springframework.beans.factory.support.Abstract BeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.BeanDefi nitionValueResolver.resolveReference(BeanDefinitio nValueResolver.java:322)

[krimple]

Thanks Ken. NET_PACKAGE_ID is generated by our application and its a alphanumeric value, ex - '4KV16ICJCH6QB1ZPC22XV'.Do you suggest to push NET_PACKAGE_ID to the entity object and try it out? Does the @GeneratedVAlue for this attribute has to be done in the Entity?

OK, that's helpful. You could push in the primary key and the setters/getters for it and remove that @GeneratedValue annotation (I don't know if you will have any problems with the DB Reverse Engineering synchronization or not, let us know). Sounds like the application has to define the primary key before it is used.

Ken