I cannot get this test through, please help

[transvia]

I creat a project from seam-gen2.0 CR. I am using Jboss server 4.2.1, Seam2.0 CR, MySQL 5.0. The project can be built, depoyed and run correctly. Then I create a simple test case, but I cannot make it works.

I tested that entity factory can be created; entity manager can also be created. But I cannot do database operation, including select and insert. Please help!

Test code:

package persistentTier;

import java.util.List;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.hibernate.Session;
import org.jboss.seam.annotations.In;
import org.jboss.seam.mock.SeamTest;
import org.testng.annotations.Test;
import org.tt.user.User;

public class EntityManagerTest extends SeamTest {

 //@PersistenceContext
 private EntityManager em;

 @Test
 public void unitTestEntityManager() throws Exception{

 EntityManagerFactory emf = Persistence.createEntityManagerFactory("tt");

 em =emf.createEntityManager();
 User user=em.find(User.class, new Double(1));
 assert user.getPassword().equals("5527686");

 em.close();

 }

}

User class:

package org.tt.user;

import java.io.Serializable;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.validator.NotNull;
import org.jboss.seam.annotations.Name;

@Entity
@Name ("user")
@Table (name="user")
public class User implements Serializable {

 private double id;
 private String username;
 private String password;

 public User (){
 username="";
 password="";
 }

 @Id @GeneratedValue(strategy =GenerationType.AUTO)
 public double getId () {return this.id;}
 public void setId(long id){this.id=id;}

 public String getUsername(){return this.username;}
 public void setUsername(String username){this.username=username;}

 public String getPassword(){return this.password;}
 public void setPassword(String password){this.password=password;}
}

Database, MySQL 5.0

CREATE TABLE `user` (
 `id` double NOT NULL auto_increment,
 `username` varchar(50) NOT NULL,
 `password` varchar(50) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `user` */

insert into `user`(`id`,`username`,`password`) values (1,'oldreaper','5527686');

Erro message

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [org.tt.user.User#1.0]
 at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:647)
 at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:194)
 at persistentTier.EntityManagerTest.unitTestEntityManager(EntityManagerTest.java:29)
Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [org.tt.user.User#1.0]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.Loader.loadEntity(Loader.java:1865)
 at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
 at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
 at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2992)
 at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
 at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
 at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
 at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
 at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
 at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
 at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
 at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
 at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:174)
 ... 23 more
Caused by: java.sql.SQLException: Table not found in statement [select user0_.id as id2_0_, user0_.username as username2_0_, user0_.password as password2_0_ from user user0_ where user0_.id=?]
 at org.hsqldb.jdbc.Util.throwError(Unknown Source)
 at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
 at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
 at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:386)
 at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:374)
 at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1538)
 at org.hibernate.loader.Loader.doQuery(Loader.java:661)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
 at org.hibernate.loader.Loader.loadEntity(Loader.java:1851)
 ... 35 more
... Removed 22 stack frames

[matt.drees]

Seam gen tests run off an in-memory hsql database, not your mysql database. So, if in your persistence-test.xml you don't have something like

<property name="hibernate.hbm2ddl.auto" value="create-drop"/>

, no tables will created for your test. I'm guessing you're missing that. If you're not, post what you have instead.

[transvia]

The problems are that:

1)I don't want to use HSQLDB
2)I don't want the test drop and create tables for me for every test.

So, can I configure the datasource and persistence files that allow me to use MySQL with existing data? if I can, please let me know how can I do it?

thanks

[matt.drees]

Yes. Edit persistence-test.xml.

[transvia]

I tried for serveral time, it report connectiong errors when I change the test database to MySQL. What I did is copy the persistence-dev.xml and edit it for a little. However, it seems does not work correctly.

can you provide more details about how to do this? or suggest an example?

[pmuir]

Have you made sure the datasource is available to jboss embedded?

[saeediqbal1]

seam-gen for me has been buggy so i use this now http://chiralsoftware.com/master-sauce/ Master Sauce

for mysql connection in the resources folder in the **ds.xml i have this

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE datasources
 PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
 "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">

<datasources>

 <local-tx-datasource>
 <jndi-name>sdeskoneDatasource</jndi-name>
 <connection-url>jdbc:mysql://localhost:3306/test</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>root</user-name>
 <password></password>
<!--
 <exception-sorter-class-name>
 org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
 </exception-sorter-class-name>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
-->
 </local-tx-datasource>

</datasources>

and in META-INF/persistence*.xml i have this

<?xml version="1.0" encoding="UTF-8"?>
<!-- Persistence deployment descriptor for dev profile -->
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
 version="1.0">

 <persistence-unit name="sdeskone">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/sdeskoneDatasource</jta-data-source>
 <properties>
 <property name="hibernate.hbm2ddl.auto" value="validate"/>
 <property name="hibernate.cache.use_query_cache" value="true"/>
 <property name="hibernate.show_sql" value="true"/>
 <property name="jboss.entity.manager.factory.jndi.name" value="java:/sdeskoneEntityManagerFactory"/>
 </properties>
 </persistence-unit>

</persistence>

seems to do the work but really seam-gen wasted "days/weeks" of my time.

[transvia]

Thank you for your replies.

First, my datasourse should works. I can connect it through eclipse database perspective. I can also compile and deploye the EAR to Jboss. I can see Jboss load the datasource.

Second the, the configure files seems correct. I check them also.

I guess the Seam test defualtly use some configure parameters that I don't know.

There are three persistence files under META-INF folder. They are persistence-dev.xml, -prod.xml and -test.xml. Each file should be related to a datasource file.

However, under the resources folder, there is no datasource related to persistence-test.xml. There are only two files. One is project-dev-ds.xml and another is project-prod-ds.xml

So, I think the project created from Seam-gen defaultly use some build-in configurartion to connect datasource. Is there any way that I can make the test take in the test datasource file?

Thank you

[transvia]

I found the test defaultly use datasource files under the folder project/bootstrap/deploy. I try to put mysql datasource file to this fold. But I get an error when the test is loaded:

org.jboss.deployers.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

*** DEPLOYMENTS IN ERROR: Name -> Error

vfsfile:/C:/workspace/tt/bootstrap/deploy/test-ds.xml -> java.lang.IllegalStateException: jboss.jca:name=DefaultDS,service=ManagedConnectionFactory is already installed.


 at org.jboss.embedded.Bootstrap.checkIncomplete(Bootstrap.java:144)
 at org.jboss.embedded.Bootstrap.bootstrapURL(Bootstrap.java:169)
 at org.jboss.embedded.Bootstrap.bootstrap(Bootstrap.java:201)
 at org.jboss.embedded.Bootstrap.bootstrap(Bootstrap.java:214)
 at org.jboss.seam.mock.EmbeddedBootstrap.startAndDeployResources(EmbeddedBootstrap.java:11)
 at org.jboss.seam.mock.BaseSeamTest.startJbossEmbeddedIfNecessary(BaseSeamTest.java:968)
 at org.jboss.seam.mock.BaseSeamTest.init(BaseSeamTest.java:893)
 at org.jboss.seam.mock.SeamTest.init(SeamTest.java:42)
... Removed 22 stack frames