Fórum Loja Virtual Completa aula 17- erro Teste #460748

Boa tarde ! Pessoal

Estou tentando fazer o teste da aula 17, porém o meu teste fica mais de meia hora executando e não finaliza.
Uso Netbeans 7
Glasfish Server
Mysql


Esta é minha classe de teste
@Test
public void testSaveUsers() throws Exception {
System.out.println("saveUsers");
Users us = new Users();
us.setEmail("alves@yahoo.com.br");
us.setName("Almir Alves");
us.setPassword("123");
us.setUser("alves");
Address addr = new Address();
addr.setAddress("Rua do Rosario");
addr.setApelido("Principal");
addr.setBairro("Centro");
addr.setCidade("Resende");
addr.setEstado("RJ");
addr.setNumero(123);
addr.setCountry(CountryType.BRASIL);
addr.setPostalCode("27511-291");
us.addAddress(addr);

UserSession instance = (UserSession) container.getContext().lookup("java:global/classes/UserSession");

Users result = instance.saveUsers(us);
idOfUser = result.getId();
assertTrue(result.getId().intValue() > 0);
assertTrue(result.getAddresses().get(0).getId().intValue() > 0);

}

Na Realidade tem um erro no teste ou na configuração pois fica dando esta msg warning abaixo varias vezes e não finaliza.
se vcs puderem me ajudar agradeço... estou gostando muito da aula

desde já um muito Obrigado.

Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE SELL (ID INTEGER NOT NULL, CLOSED TINYINT(1) default 0, DATEOFSELL DATE NOT NULL, STATUS VARCHAR(255) NOT NULL, TIMES INTEGER NOT NULL, TOTAL DECIMAL(38) NOT NULL, ADRESSTOSEND_ID INTEGER, CREDITCARD_ID INTEGER, USERNAME_ID INTEGER, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sell' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE CALLONAVALIABLE (ID INTEGER NOT NULL, CALLED TINYINT(1) default 0, EMAIL VARCHAR(255), PRODUCT_ID INTEGER, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'callonavaliable' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE USERS (ID INTEGER NOT NULL, EMAIL VARCHAR(255) NOT NULL, NAME VARCHAR(255) NOT NULL, PASSWORD VARCHAR(32) NOT NULL, USERNAME VARCHAR(255) NOT NULL, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'users' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE CATEGORY (ID INTEGER NOT NULL, ACTIVE TINYINT(1) default 0, NAME VARCHAR(255) NOT NULL UNIQUE, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'category' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE CREDITCARD (ID INTEGER NOT NULL, DATEOFVALIDATION DATE NOT NULL, FLAG VARCHAR(255) NOT NULL, NAMEOFCARDOWNER VARCHAR(255) NOT NULL, NUMBER VARCHAR(255) NOT NULL, USERNAME_ID INTEGER, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'creditcard' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE SELLITEM (ID INTEGER NOT NULL, COSTUNIT DECIMAL(38) NOT NULL, QNT INTEGER NOT NULL, PRODUCT_ID INTEGER, SELL_ID INTEGER, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sellitem' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE ADDRESS (ID INTEGER NOT NULL, ADDRESS VARCHAR(255) NOT NULL, APELIDO VARCHAR(255) NOT NULL, BAIRRO VARCHAR(255) NOT NULL, CIDADE VARCHAR(255) NOT NULL, COUNTRY VARCHAR(255) NOT NULL, ESTADO VARCHAR(2) NOT NULL, NUMERO INTEGER NOT NULL, POSTALCODE VARCHAR(255) NOT NULL, username INTEGER, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'address' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE PRODUCT (ID INTEGER NOT NULL, COST DECIMAL(38) NOT NULL, NAME VARCHAR(255) NOT NULL UNIQUE, SPEC VARCHAR(255) NOT NULL, STOCK INTEGER NOT NULL, CATEGORY_ID INTEGER, PRIMARY KEY (ID))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'product' already exists
Nov 11, 2013 6:55:28 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE SELL ADD CONSTRAINT FK_SELL_ADRESSTOSEND_ID FOREIGN KEY (ADRESSTOSEND_ID) REFERENCES ADDRESS (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:29 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE SELL ADD CONSTRAINT FK_SELL_USERNAME_ID FOREIGN KEY (USERNAME_ID) REFERENCES USERS (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:29 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE SELL ADD CONSTRAINT FK_SELL_CREDITCARD_ID FOREIGN KEY (CREDITCARD_ID) REFERENCES CREDITCARD (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:29 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE CALLONAVALIABLE ADD CONSTRAINT FK_CALLONAVALIABLE_PRODUCT_ID FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:29 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE CREDITCARD ADD CONSTRAINT FK_CREDITCARD_USERNAME_ID FOREIGN KEY (USERNAME_ID) REFERENCES USERS (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:30 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE SELLITEM ADD CONSTRAINT FK_SELLITEM_PRODUCT_ID FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:30 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE SELLITEM ADD CONSTRAINT FK_SELLITEM_SELL_ID FOREIGN KEY (SELL_ID) REFERENCES SELL (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:30 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE ADDRESS ADD CONSTRAINT FK_ADDRESS_username FOREIGN KEY (username) REFERENCES USERS (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:30 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "ALTER TABLE PRODUCT ADD CONSTRAINT FK_PRODUCT_CATEGORY_ID FOREIGN KEY (CATEGORY_ID) REFERENCES CATEGORY (ID)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-510_6f'
Nov 11, 2013 6:55:30 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))": com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'sequence' already exists
Nov 11, 2013 6:55:30 PM org.glassfish.persistence.common.Java2DBProcessorHelper executeDDLs
WARNING: PER01000: Got SQLException executing statement "INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)": com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'SEQ_GEN' for key 'PRIMARY'
Nov 11, 2013 6:55:31 PM com.sun.ejb.containers.BaseContainer initializeHome
INFO: EJB5181:Portable JNDI names for EJB SellSession: [java:global/classes/SellSession, java:global/classes/SellSession!br.com.devmedia.session.SellSession]
Nov 11, 2013 6:55:31 PM com.sun.ejb.containers.BaseContainer initializeHome
INFO: EJB5181:Portable JNDI names for EJB UserSession: [java:global/classes/UserSession!br.com.devmedia.session.UserSession, java:global/classes/UserSession]
Nov 11, 2013 6:55:31 PM org.glassfish.ejb.persistent.timer.PersistentEJBTimerService deployEJBTimerService
INFO: Loading EJBTimerService. Please wait.
Nov 11, 2013 6:55:33 PM com.sun.enterprise.web.WebContainer configureHost
SEVERE: Network listener http-listener-1 referenced by virtual server server does not exist
Nov 11, 2013 6:55:33 PM com.sun.enterprise.web.WebContainer configureHost
SEVERE: Network listener http-listener-2 referenced by virtual server server does not exist
Nov 11, 2013 6:55:33 PM com.sun.enterprise.web.WebContainer createHosts
INFO: Created virtual server server
Nov 11, 2013 6:55:33 PM com.sun.enterprise.web.WebContainer configureHost
SEVERE: Network listener admin-listener referenced by virtual server __asadmin does not exist
Nov 11, 2013 6:55:33 PM com.sun.enterprise.web.WebContainer createHosts
INFO: Created virtual server __asadmin
Nov 11, 2013 6:55:35 PM org.apache.catalina.realm.JAASRealm setContainer
INFO: Setting JAAS app name glassfish-web
Nov 11, 2013 6:55:35 PM com.sun.enterprise.web.WebContainer loadSystemDefaultWebModules
INFO: Virtual server server loaded default web module
Nov 11, 2013 6:55:38 PM org.eclipse.persistence.session.file:/C:/Users/Almir/AppData/Local/Temp/gfembed4765444618155200951tmp/applications/ejb-timer-service-app/WEB-INF/classes/___EJB__Timer__App
INFO: EclipseLink, version: Eclipse Persistence Services - 2.5.0.v20130507-3faac2b
Nov 11, 2013 6:55:46 PM org.eclipse.persistence.session.file:/C:/Users/Almir/AppData/Local/Temp/gfembed4765444618155200951tmp/applications/ejb-timer-service-app/WEB-INF/classes/___EJB__Timer__App.connection
INFO: file:/C:/Users/Almir/AppData/Local/Temp/gfembed4765444618155200951tmp/applications/ejb-timer-service-app/WEB-INF/classes/___EJB__Timer__App login successful
Nov 11, 2013 6:55:46 PM org.eclipse.persistence.session.file:/C:/Users/Almir/AppData/Local/Temp/gfembed4765444618155200951tmp/applications/ejb-timer-service-app/WEB-INF/classes/___EJB__Timer__App.server
WARNING: Failed to find MBean Server: null or empty List returned from MBeanServerFactory.findMBeanServer(null)
Nov 11, 2013 6:55:46 PM com.sun.ejb.containers.BaseContainer initializeHome
INFO: EJB5181:Portable JNDI names for EJB TimerBean: [java:global/ejb-timer-service-app/TimerBean, java:global/ejb-timer-service-app/TimerBean!org.glassfish.ejb.persistent.timer.TimerLocal]
Nov 11, 2013 6:55:47 PM com.sun.enterprise.web.WebApplication start
INFO: Loading application [ejb-timer-service-app] at [/ejb-timer-service-app]
Nov 11, 2013 6:55:47 PM org.glassfish.ejb.persistent.timer.PersistentEJBTimerService initEJBTimerService
INFO: EJB5109:EJB Timer Service started successfully for data source [jdbc/__TimerPool]
Nov 11, 2013 6:55:47 PM org.glassfish.ejb.persistent.timer.PersistentEJBTimerService resetEJBTimers
INFO: ==> Restoring Timers ...
Nov 11, 2013 6:55:47 PM org.glassfish.ejb.persistent.timer.PersistentEJBTimerService restoreEJBTimers
INFO: There are no EJB Timers owned by this server
Nov 11, 2013 6:55:47 PM org.glassfish.ejb.persistent.timer.PersistentEJBTimerService resetEJBTimers
INFO: <== ... Timers Restored.
Nov 11, 2013 6:55:47 PM com.sun.ejb.containers.BaseContainer initializeHome
INFO: EJB5181:Portable JNDI names for EJB ProductSession: [java:global/classes/ProductSession, java:global/classes/ProductSession!br.com.devmedia.session.ProductSession]
Nov 11, 2013 6:55:47 PM org.jboss.weld.bootstrap.WeldBootstrap <clinit>
INFO: WELD-000900 2.0.0 (SP1)
Nov 11, 2013 6:55:49 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:49 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:49 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:49 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:51 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:52 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:55 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:56 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:55:58 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:00 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:01 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:02 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:03 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:04 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:05 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:06 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:07 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:12 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:31 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:39 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:40 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:41 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:43 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:56:47 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:57:00 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:57:36 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:57:52 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:58:11 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:58:28 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:58:47 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005
Nov 11, 2013 6:59:12 PM org.glassfish.weld.BeanDeploymentArchiveImpl handleEntry
WARNING: AS-CDI-005