Problem running my own tests based on the booking applicatio
I've added some code to the booking example and this seems to work but when writing a new test I get some problems with logging in that I don't understand? this is my statefull bean that I'm trying to test
package ivvo.drapier.logic;
import static javax.persistence.PersistenceContextType.EXTENDED;
import ivvo.drapier.model.Account;
import ivvo.drapier.model.Entry;
import ivvo.drapier.model.SummaryAccount;
import ivvo.drapier.model.Transaction;
import java.io.Serializable;
import java.util.List;
import javax.ejb.Interceptor;
import javax.ejb.Remove;
import javax.ejb.Stateful;
import javax.faces.context.FacesContext;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import org.hibernate.validator.Valid;
import org.jboss.logging.Logger;
import org.jboss.seam.annotations.Begin;
import org.jboss.seam.annotations.Conversational;
import org.jboss.seam.annotations.Destroy;
import org.jboss.seam.annotations.End;
import org.jboss.seam.annotations.In;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.annotations.Out;
import org.jboss.seam.annotations.datamodel.DataModel;
import org.jboss.seam.annotations.datamodel.DataModelSelectionIndex;
import org.jboss.seam.ejb.SeamInterceptor;
import org.jboss.seam.example.booking.LoggedIn;
/**
*
* @author Wim Drapier
*
*/
@Stateful
@Name("journalService")
@Interceptor(SeamInterceptor.class)
@Conversational(ifNotBegunOutcome="main")
@LoggedIn
public class JournalServiceBean implements JournalService, Serializable {
private static final Logger logger = Logger.getLogger(JournalServiceBean.class);
private static final long serialVersionUID = -7800004621220189670L;
@PersistenceContext(type=EXTENDED)
private EntityManager em;
@DataModel
private List<Account> accounts;
@DataModelSelectionIndex
private int accountIndex;
@Out(required=false)
private Account journal;
@Out(required=false)
private Account bookingAccount;
@In(required=false)
@Out(required=false)
@Valid
private Transaction transaction;
@Out(required=false)
@In(required=false)
private Entry entry;
@In
private transient FacesContext facesContext;
@SuppressWarnings("unchecked")
@Begin
public String loadJournals() {
journal = null;
accounts = em.createQuery("from JournalAccount")
.getResultList();
logger.info(accounts.size() + " Journals found");
return "journals";
}
public String selectJournal() {
if(accounts == null) {
return "main";
}
journal = accounts.get(accountIndex);
logger.info(accountIndex + " -> " + journal.getDescription());
return "selected";
}
public String loadAccountingSystem() {
bookingAccount = null;
accounts = em.createQuery
("from Account a where a.number between 1 and 7")
.getResultList();
logger.info(accounts.size() + " Accounts found");
return "accountingsystem";
}
public String loadSubAccounts() {
SummaryAccount s = (SummaryAccount) accounts.get(accountIndex);
accounts = s.getChildAccounts();
logger.info(accounts.size() + " Subaccounts found");
return "success";
}
public String selectBookingAccount() {
if(accounts == null) {
return "main";
}
bookingAccount = accounts.get(accountIndex);
logger.info(accountIndex + " -> " + bookingAccount.getDescription());
return "selected";
}
public String makeBooking() {
entry = new Entry();
entry.setAccount(bookingAccount);
//transaction.getEntries().add(entry);
logger.info("entry for account: " + bookingAccount.getDescription());
return "success";
}
public String registerAccountingEvent() {
// TODO Auto-generated method stub
return null;
}
@End
public String confirm() {
return "confirmed";
}
@Destroy @Remove
public void destroy() {
logger.info("destroyed");
}
}
And here is my test class
package ivvo.drapier.logic.test;
import ivvo.drapier.logic.JournalService;
import ivvo.drapier.model.JournalAccount;
import java.util.Map;
import javax.faces.model.DataModel;
import org.jboss.logging.Logger;
import org.jboss.seam.Component;
import org.jboss.seam.contexts.Contexts;
import org.jboss.seam.core.Ejb;
import org.jboss.seam.core.Init;
import org.jboss.seam.core.Manager;
import org.jboss.seam.example.booking.User;
import org.jboss.seam.mock.SeamTest;
import org.testng.annotations.Test;
public class JournalServiceTest extends SeamTest {
private static final Logger logger = Logger.getLogger(JournalServiceTest.class);
@Test
public void testJournalPost() throws Exception {
new Script() {
JournalService journalService;
@Override
protected void applyRequestValues() throws Exception {
Contexts.getSessionContext().set("LoggedIn", true);
Contexts.getSessionContext().set("user", new User("Gavin King", "foobar", "gavin"));
}
@Override
protected void updateModelValues() throws Exception {
journalService = (JournalService) Component.getInstance("journalService", true);
}
@Override
protected void invokeApplication() throws Exception {
String outcome = journalService.loadJournals();
logger.debug(outcome);
assert "journals".equals(outcome);
}
@Override
protected void renderResponse() throws Exception {
DataModel journals = (DataModel) Contexts.getConversationContext().get("accounts");
assert journals.getRowCount()==1;
assert ((JournalAccount) journals.getRowData()).getNumber()==700000;
assert Manager.instance().isLongRunningConversation();
}
}.run();
}
@Override
public void initServletContext(Map initParams) {
initParams.put(Init.MANAGED_PERSISTENCE_CONTEXTS, "bookingDatabase");
initParams.put(Init.COMPONENT_CLASSES, Ejb.class.getName());
}
}
When the test comes to invoking the journalService.loadJournals() method the outcome string is "login" where it schould be "journals"
In my logging I see that the user is not logged in and that's why I get "login" as return value. based on the BookingTest class this schould work or have I forgot something?
Just in case my logging
DEBUG 07-10 16:21:08,570 (EntityLoader.java:<init>:79) -Static select for entity ivvo.drapier.model.Account: select account0_.id as id0_0_, account0_.number as number0_0_, account0_.description as descript4_0_0_, account0_.account_type as account1_0_0_ from account account0_ where account0_.id=?
DEBUG 07-10 16:21:08,570 (CascadeEntityLoader.java:<init>:34) -Static select for action ACTION_MERGE on entity ivvo.drapier.model.Account: select account0_.id as id0_0_, account0_.number as number0_0_, account0_.description as descript4_0_0_, account0_.account_type as account1_0_0_ from account account0_ where account0_.id=?
DEBUG 07-10 16:21:08,570 (CascadeEntityLoader.java:<init>:34) -Static select for action ACTION_MERGE on entity ivvo.drapier.model.Account: select account0_.id as id0_0_, account0_.number as number0_0_, account0_.description as descript4_0_0_, account0_.account_type as account1_0_0_ from account account0_ where account0_.id=?
DEBUG 07-10 16:21:08,570 (CascadeEntityLoader.java:<init>:34) -Static select for action ACTION_REFRESH on entity ivvo.drapier.model.Account: select account0_.id as id0_0_, account0_.number as number0_0_, account0_.description as descript4_0_0_, account0_.account_type as account1_0_0_ from account account0_ where account0_.id=?
DEBUG 07-10 16:21:08,570 (CascadeEntityLoader.java:<init>:34) -Static select for action ACTION_REFRESH on entity ivvo.drapier.model.Account: select account0_.id as id0_0_, account0_.number as number0_0_, account0_.description as descript4_0_0_, account0_.account_type as account1_0_0_ from account account0_ where account0_.id=?
DEBUG 07-10 16:21:08,810 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.Transaction.entries: select entries0_.transaction_id as transact1_2_, entries0_.entries_id as entries2_2_, entry1_.id as id1_0_, entry1_.account_id as account4_1_0_, entry1_.CREDITAMOUNT as CREDITAM2_1_0_, entry1_.DEBETAMOUNT as DEBETAMO3_1_0_, account2_.id as id0_1_, account2_.number as number0_1_, account2_.description as descript4_0_1_, account2_.account_type as account1_0_1_ from transaction_entry entries0_ left outer join entry entry1_ on entries0_.entries_id=entry1_.id left outer join account account2_ on entry1_.account_id=account2_.id where entries0_.transaction_id=?
DEBUG 07-10 16:21:08,810 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.Transaction.entries: select entries0_.transaction_id as transact1_2_, entries0_.entries_id as entries2_2_, entry1_.id as id1_0_, entry1_.account_id as account4_1_0_, entry1_.CREDITAMOUNT as CREDITAM2_1_0_, entry1_.DEBETAMOUNT as DEBETAMO3_1_0_, account2_.id as id0_1_, account2_.number as number0_1_, account2_.description as descript4_0_1_, account2_.account_type as account1_0_1_ from transaction_entry entries0_ left outer join entry entry1_ on entries0_.entries_id=entry1_.id left outer join account account2_ on entry1_.account_id=account2_.id where entries0_.transaction_id=?
DEBUG 07-10 16:21:08,860 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.JournalAccount.posts: select posts0_.account_id as account1_1_, posts0_.posts_id as posts2_1_, transactio1_.id as id2_0_ from account_transaction posts0_ left outer join transaction transactio1_ on posts0_.posts_id=transactio1_.id where posts0_.account_id=?
DEBUG 07-10 16:21:08,860 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.JournalAccount.posts: select posts0_.account_id as account1_1_, posts0_.posts_id as posts2_1_, transactio1_.id as id2_0_ from account_transaction posts0_ left outer join transaction transactio1_ on posts0_.posts_id=transactio1_.id where posts0_.account_id=?
DEBUG 07-10 16:21:08,860 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.SummaryAccount.childAccounts: select childaccou0_.account_id as account1_1_, childaccou0_.childAccounts_id as childAcc2_1_, account1_.id as id0_0_, account1_.number as number0_0_, account1_.description as descript4_0_0_, account1_.account_type as account1_0_0_ from account_account childaccou0_ left outer join account account1_ on childaccou0_.childAccounts_id=account1_.id where childaccou0_.account_id=?
DEBUG 07-10 16:21:08,860 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.SummaryAccount.childAccounts: select childaccou0_.account_id as account1_1_, childaccou0_.childAccounts_id as childAcc2_1_, account1_.id as id0_0_, account1_.number as number0_0_, account1_.description as descript4_0_0_, account1_.account_type as account1_0_0_ from account_account childaccou0_ left outer join account account1_ on childaccou0_.childAccounts_id=account1_.id where childaccou0_.account_id=?
DEBUG 07-10 16:21:08,860 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.DetailAccount.bookings: select bookings0_.account_id as account1_2_, bookings0_.bookings_id as bookings2_2_, entry1_.id as id1_0_, entry1_.account_id as account4_1_0_, entry1_.CREDITAMOUNT as CREDITAM2_1_0_, entry1_.DEBETAMOUNT as DEBETAMO3_1_0_, account2_.id as id0_1_, account2_.number as number0_1_, account2_.description as descript4_0_1_, account2_.account_type as account1_0_1_ from account_entry bookings0_ left outer join entry entry1_ on bookings0_.bookings_id=entry1_.id left outer join account account2_ on entry1_.account_id=account2_.id where bookings0_.account_id=?
DEBUG 07-10 16:21:08,860 (BasicCollectionLoader.java:<init>:64) -Static select for collection ivvo.drapier.model.DetailAccount.bookings: select bookings0_.account_id as account1_2_, bookings0_.bookings_id as bookings2_2_, entry1_.id as id1_0_, entry1_.account_id as account4_1_0_, entry1_.CREDITAMOUNT as CREDITAM2_1_0_, entry1_.DEBETAMOUNT as DEBETAMO3_1_0_, account2_.id as id0_1_, account2_.number as number0_1_, account2_.description as descript4_0_1_, account2_.account_type as account1_0_1_ from account_entry bookings0_ left outer join entry entry1_ on bookings0_.bookings_id=entry1_.id left outer join account account2_ on entry1_.account_id=account2_.id where bookings0_.account_id=?
DEBUG 07-10 16:21:08,870 (SessionFactoryObjectFactory.java:<clinit>:39) -initializing class SessionFactoryObjectFactory
DEBUG 07-10 16:21:08,870 (SessionFactoryObjectFactory.java:<clinit>:39) -initializing class SessionFactoryObjectFactory
DEBUG 07-10 16:21:08,870 (SessionFactoryObjectFactory.java:addInstance:76) -registered: 402880e406cb74dc0106cb74eb7c0000 (unnamed)
DEBUG 07-10 16:21:08,870 (SessionFactoryObjectFactory.java:addInstance:76) -registered: 402880e406cb74dc0106cb74eb7c0000 (unnamed)
INFO 07-10 16:21:08,870 (SessionFactoryObjectFactory.java:addInstance:82) -Not binding factory to JNDI, no JNDI name configured
INFO 07-10 16:21:08,870 (SessionFactoryObjectFactory.java:addInstance:82) -Not binding factory to JNDI, no JNDI name configured
DEBUG 07-10 16:21:08,880 (SessionFactoryImpl.java:<init>:297) -instantiated session factory
DEBUG 07-10 16:21:08,880 (SessionFactoryImpl.java:<init>:297) -instantiated session factory
DEBUG 07-10 16:21:08,880 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:08,880 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:08,880 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:08,880 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:08,890 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:08,890 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:08,890 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
DEBUG 07-10 16:21:08,890 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
INFO 07-10 16:21:08,890 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
DEBUG 07-10 16:21:08,890 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:08,890 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:08,890 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:08,890 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:08,900 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:08,900 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:09,161 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:09,161 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:09,161 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:09,161 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:09,161 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:09,161 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:09,281 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:09,281 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:09,281 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:09,281 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:09,411 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:09,411 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:09,411 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:09,411 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:09,411 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:09,411 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:09,551 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:09,551 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:09,551 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:09,551 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:09,551 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:09,551 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:09,611 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
DEBUG 07-10 16:21:09,611 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
INFO 07-10 16:21:09,611 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:09,611 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:09,611 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:09,611 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:09,611 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:09,611 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:09,621 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
INFO 07-10 16:21:09,621 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
DEBUG 07-10 16:21:09,621 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:09,621 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:09,621 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:09,621 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:09,621 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:09,621 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:10,082 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:10,082 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:10,092 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
INFO 07-10 16:21:10,092 (SchemaExport.java:execute:153) -Running hbm2ddl schema export
INFO 07-10 16:21:10,092 (SchemaExport.java:execute:153) -Running hbm2ddl schema export
INFO 07-10 16:21:10,102 (SchemaExport.java:execute:180) -exporting generated schema to database
INFO 07-10 16:21:10,102 (SchemaExport.java:execute:180) -exporting generated schema to database
DEBUG 07-10 16:21:10,102 (SchemaExport.java:execute:283) -alter table Booking drop constraint FK6713A0396E4A3BD
DEBUG 07-10 16:21:10,102 (SchemaExport.java:execute:283) -alter table Booking drop constraint FK6713A0396E4A3BD
DEBUG 07-10 16:21:10,112 (SchemaExport.java:drop:272) -Unsuccessful: alter table Booking drop constraint FK6713A0396E4A3BD
DEBUG 07-10 16:21:10,112 (SchemaExport.java:drop:272) -Unsuccessful: alter table Booking drop constraint FK6713A0396E4A3BD
DEBUG 07-10 16:21:10,112 (SchemaExport.java:drop:273) -Table not found: BOOKING in statement [alter table Booking]
DEBUG 07-10 16:21:10,112 (SchemaExport.java:drop:273) -Table not found: BOOKING in statement [alter table Booking]
DEBUG 07-10 16:21:10,112 (SchemaExport.java:execute:283) -alter table Booking drop constraint FK6713A03951897512
DEBUG 07-10 16:21:10,112 (SchemaExport.java:execute:283) -alter table Booking drop constraint FK6713A03951897512
DEBUG 07-10 16:21:10,112 (SchemaExport.java:drop:272) -Unsuccessful: alter table Booking drop constraint FK6713A03951897512
DEBUG 07-10 16:21:10,112 (SchemaExport.java:drop:272) -Unsuccessful: alter table Booking drop constraint FK6713A03951897512
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:273) -Table not found: BOOKING in statement [alter table Booking]
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:273) -Table not found: BOOKING in statement [alter table Booking]
DEBUG 07-10 16:21:10,122 (SchemaExport.java:execute:283) -alter table account_account drop constraint FK71143E1BE92C0436
DEBUG 07-10 16:21:10,122 (SchemaExport.java:execute:283) -alter table account_account drop constraint FK71143E1BE92C0436
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_account drop constraint FK71143E1BE92C0436
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_account drop constraint FK71143E1BE92C0436
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ACCOUNT in statement [alter table account_account]
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ACCOUNT in statement [alter table account_account]
DEBUG 07-10 16:21:10,122 (SchemaExport.java:execute:283) -alter table account_account drop constraint FK71143E1BD5013DC3
DEBUG 07-10 16:21:10,122 (SchemaExport.java:execute:283) -alter table account_account drop constraint FK71143E1BD5013DC3
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_account drop constraint FK71143E1BD5013DC3
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_account drop constraint FK71143E1BD5013DC3
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ACCOUNT in statement [alter table account_account]
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ACCOUNT in statement [alter table account_account]
DEBUG 07-10 16:21:10,122 (SchemaExport.java:execute:283) -alter table account_entry drop constraint FKDFDBDFE0F4D18A7
DEBUG 07-10 16:21:10,122 (SchemaExport.java:execute:283) -alter table account_entry drop constraint FKDFDBDFE0F4D18A7
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_entry drop constraint FKDFDBDFE0F4D18A7
DEBUG 07-10 16:21:10,122 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_entry drop constraint FKDFDBDFE0F4D18A7
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ENTRY in statement [alter table account_entry]
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ENTRY in statement [alter table account_entry]
DEBUG 07-10 16:21:10,132 (SchemaExport.java:execute:283) -alter table account_entry drop constraint FKDFDBDFE0459F3250
DEBUG 07-10 16:21:10,132 (SchemaExport.java:execute:283) -alter table account_entry drop constraint FKDFDBDFE0459F3250
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_entry drop constraint FKDFDBDFE0459F3250
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_entry drop constraint FKDFDBDFE0459F3250
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ENTRY in statement [alter table account_entry]
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_ENTRY in statement [alter table account_entry]
DEBUG 07-10 16:21:10,132 (SchemaExport.java:execute:283) -alter table account_transaction drop constraint FK7E69DFCCD0128785
DEBUG 07-10 16:21:10,132 (SchemaExport.java:execute:283) -alter table account_transaction drop constraint FK7E69DFCCD0128785
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_transaction drop constraint FK7E69DFCCD0128785
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_transaction drop constraint FK7E69DFCCD0128785
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_TRANSACTION in statement [alter table account_transaction]
DEBUG 07-10 16:21:10,132 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_TRANSACTION in statement [alter table account_transaction]
DEBUG 07-10 16:21:10,132 (SchemaExport.java:execute:283) -alter table account_transaction drop constraint FK7E69DFCC37EDE303
DEBUG 07-10 16:21:10,132 (SchemaExport.java:execute:283) -alter table account_transaction drop constraint FK7E69DFCC37EDE303
DEBUG 07-10 16:21:10,162 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_transaction drop constraint FK7E69DFCC37EDE303
DEBUG 07-10 16:21:10,162 (SchemaExport.java:drop:272) -Unsuccessful: alter table account_transaction drop constraint FK7E69DFCC37EDE303
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_TRANSACTION in statement [alter table account_transaction]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: ACCOUNT_TRANSACTION in statement [alter table account_transaction]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -alter table entry drop constraint FK5C308727041F4B8
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -alter table entry drop constraint FK5C308727041F4B8
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:272) -Unsuccessful: alter table entry drop constraint FK5C308727041F4B8
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:272) -Unsuccessful: alter table entry drop constraint FK5C308727041F4B8
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: ENTRY in statement [alter table entry]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: ENTRY in statement [alter table entry]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -alter table transaction_entry drop constraint FKABC21FD146FD2C18
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -alter table transaction_entry drop constraint FKABC21FD146FD2C18
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:272) -Unsuccessful: alter table transaction_entry drop constraint FKABC21FD146FD2C18
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:272) -Unsuccessful: alter table transaction_entry drop constraint FKABC21FD146FD2C18
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: TRANSACTION_ENTRY in statement [alter table transaction_entry]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: TRANSACTION_ENTRY in statement [alter table transaction_entry]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -alter table transaction_entry drop constraint FKABC21FD1A14E293A
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -alter table transaction_entry drop constraint FKABC21FD1A14E293A
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:272) -Unsuccessful: alter table transaction_entry drop constraint FKABC21FD1A14E293A
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:272) -Unsuccessful: alter table transaction_entry drop constraint FKABC21FD1A14E293A
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: TRANSACTION_ENTRY in statement [alter table transaction_entry]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:drop:273) -Table not found: TRANSACTION_ENTRY in statement [alter table transaction_entry]
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table Booking if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table Booking if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table Hotel if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table Hotel if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table User if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table User if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account_account if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account_account if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account_entry if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account_entry if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account_transaction if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table account_transaction if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table entry if exists
DEBUG 07-10 16:21:10,172 (SchemaExport.java:execute:283) -drop table entry if exists
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -drop table transaction if exists
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -drop table transaction if exists
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -drop table transaction_entry if exists
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -drop table transaction_entry if exists
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -create table Booking (id bigint generated by default as identity (start with 1), checkinDate date not null, checkoutDate date not null, creditCard varchar(16) not null, hotel_id bigint, user_username varchar(255), primary key (id))
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -create table Booking (id bigint generated by default as identity (start with 1), checkinDate date not null, checkoutDate date not null, creditCard varchar(16) not null, hotel_id bigint, user_username varchar(255), primary key (id))
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -create table Hotel (id bigint generated by default as identity (start with 1), city varchar(20) not null, zip varchar(5) not null, address varchar(100) not null, name varchar(50) not null, state varchar(2) not null, primary key (id))
DEBUG 07-10 16:21:10,182 (SchemaExport.java:execute:283) -create table Hotel (id bigint generated by default as identity (start with 1), city varchar(20) not null, zip varchar(5) not null, address varchar(100) not null, name varchar(50) not null, state varchar(2) not null, primary key (id))
DEBUG 07-10 16:21:10,433 (SchemaExport.java:execute:283) -create table User (username varchar(255) not null, name varchar(100) not null, password varchar(15) not null, primary key (username))
DEBUG 07-10 16:21:10,433 (SchemaExport.java:execute:283) -create table User (username varchar(255) not null, name varchar(100) not null, password varchar(15) not null, primary key (username))
DEBUG 07-10 16:21:10,433 (SchemaExport.java:execute:283) -create table account (account_type varchar(10) not null, id bigint generated by default as identity (start with 1), number integer not null, description varchar(255), primary key (id))
DEBUG 07-10 16:21:10,433 (SchemaExport.java:execute:283) -create table account (account_type varchar(10) not null, id bigint generated by default as identity (start with 1), number integer not null, description varchar(255), primary key (id))
DEBUG 07-10 16:21:10,443 (SchemaExport.java:execute:283) -create table account_account (account_id bigint not null, childAccounts_id bigint not null, unique (childAccounts_id))
DEBUG 07-10 16:21:10,443 (SchemaExport.java:execute:283) -create table account_account (account_id bigint not null, childAccounts_id bigint not null, unique (childAccounts_id))
DEBUG 07-10 16:21:10,453 (SchemaExport.java:execute:283) -create table account_entry (account_id bigint not null, bookings_id bigint not null, unique (bookings_id))
DEBUG 07-10 16:21:10,453 (SchemaExport.java:execute:283) -create table account_entry (account_id bigint not null, bookings_id bigint not null, unique (bookings_id))
DEBUG 07-10 16:21:10,453 (SchemaExport.java:execute:283) -create table account_transaction (account_id bigint not null, posts_id bigint not null, unique (posts_id))
DEBUG 07-10 16:21:10,453 (SchemaExport.java:execute:283) -create table account_transaction (account_id bigint not null, posts_id bigint not null, unique (posts_id))
DEBUG 07-10 16:21:10,453 (SchemaExport.java:execute:283) -create table entry (id bigint generated by default as identity (start with 1), CREDITAMOUNT double, DEBETAMOUNT double, account_id bigint, primary key (id))
DEBUG 07-10 16:21:10,453 (SchemaExport.java:execute:283) -create table entry (id bigint generated by default as identity (start with 1), CREDITAMOUNT double, DEBETAMOUNT double, account_id bigint, primary key (id))
DEBUG 07-10 16:21:10,683 (SchemaExport.java:execute:283) -create table transaction (id bigint generated by default as identity (start with 1), primary key (id))
DEBUG 07-10 16:21:10,683 (SchemaExport.java:execute:283) -create table transaction (id bigint generated by default as identity (start with 1), primary key (id))
DEBUG 07-10 16:21:10,683 (SchemaExport.java:execute:283) -create table transaction_entry (transaction_id bigint not null, entries_id bigint not null, unique (entries_id))
DEBUG 07-10 16:21:10,683 (SchemaExport.java:execute:283) -create table transaction_entry (transaction_id bigint not null, entries_id bigint not null, unique (entries_id))
DEBUG 07-10 16:21:10,683 (SchemaExport.java:execute:283) -alter table Booking add constraint FK6713A0396E4A3BD foreign key (user_username) references User
DEBUG 07-10 16:21:10,683 (SchemaExport.java:execute:283) -alter table Booking add constraint FK6713A0396E4A3BD foreign key (user_username) references User
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table Booking add constraint FK6713A03951897512 foreign key (hotel_id) references Hotel
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table Booking add constraint FK6713A03951897512 foreign key (hotel_id) references Hotel
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_account add constraint FK71143E1BE92C0436 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_account add constraint FK71143E1BE92C0436 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_account add constraint FK71143E1BD5013DC3 foreign key (childAccounts_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_account add constraint FK71143E1BD5013DC3 foreign key (childAccounts_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_entry add constraint FKDFDBDFE0F4D18A7 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_entry add constraint FKDFDBDFE0F4D18A7 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_entry add constraint FKDFDBDFE0459F3250 foreign key (bookings_id) references entry
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_entry add constraint FKDFDBDFE0459F3250 foreign key (bookings_id) references entry
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_transaction add constraint FK7E69DFCCD0128785 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_transaction add constraint FK7E69DFCCD0128785 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_transaction add constraint FK7E69DFCC37EDE303 foreign key (posts_id) references transaction
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table account_transaction add constraint FK7E69DFCC37EDE303 foreign key (posts_id) references transaction
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table entry add constraint FK5C308727041F4B8 foreign key (account_id) references account
DEBUG 07-10 16:21:10,693 (SchemaExport.java:execute:283) -alter table entry add constraint FK5C308727041F4B8 foreign key (account_id) references account
DEBUG 07-10 16:21:10,703 (SchemaExport.java:execute:283) -alter table transaction_entry add constraint FKABC21FD146FD2C18 foreign key (transaction_id) references transaction
DEBUG 07-10 16:21:10,703 (SchemaExport.java:execute:283) -alter table transaction_entry add constraint FKABC21FD146FD2C18 foreign key (transaction_id) references transaction
DEBUG 07-10 16:21:10,703 (SchemaExport.java:execute:283) -alter table transaction_entry add constraint FKABC21FD1A14E293A foreign key (entries_id) references entry
DEBUG 07-10 16:21:10,703 (SchemaExport.java:execute:283) -alter table transaction_entry add constraint FKABC21FD1A14E293A foreign key (entries_id) references entry
INFO 07-10 16:21:10,703 (SchemaExport.java:importScript:234) -Executing import script: /import.sql
INFO 07-10 16:21:10,703 (SchemaExport.java:importScript:234) -Executing import script: /import.sql
DEBUG 07-10 16:21:10,703 (SchemaExport.java:importScript:238) -insert into User (username, password, name) values ('gavin', 'foobar', 'Gavin King')
DEBUG 07-10 16:21:10,703 (SchemaExport.java:importScript:238) -insert into User (username, password, name) values ('gavin', 'foobar', 'Gavin King')
DEBUG 07-10 16:21:10,713 (SchemaExport.java:importScript:238) -insert into User (username, password, name) values ('demo', 'demo', 'Demo User')
DEBUG 07-10 16:21:10,713 (SchemaExport.java:importScript:238) -insert into User (username, password, name) values ('demo', 'demo', 'Demo User')
DEBUG 07-10 16:21:10,713 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (1, 'Marriott Courtyard', 'Tower Place, Buckhead', 'Atlanta', 'GA', '30305')
DEBUG 07-10 16:21:10,713 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (1, 'Marriott Courtyard', 'Tower Place, Buckhead', 'Atlanta', 'GA', '30305')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (2, 'Doubletree', 'Tower Place, Buckhead', 'Atlanta', 'GA', '30305')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (2, 'Doubletree', 'Tower Place, Buckhead', 'Atlanta', 'GA', '30305')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (3, 'W Hotel', 'Union Square, Manhattan', 'NY', 'NY', '10011')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (3, 'W Hotel', 'Union Square, Manhattan', 'NY', 'NY', '10011')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (4, 'W Hotel', 'Lexington Ave, Manhattan', 'NY', 'NY', '10011')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (4, 'W Hotel', 'Lexington Ave, Manhattan', 'NY', 'NY', '10011')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (5, 'Hotel Rouge', 'Dupont Circle', 'Washington', 'DC', '20036')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (5, 'Hotel Rouge', 'Dupont Circle', 'Washington', 'DC', '20036')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (6, '70 Park Avenue Hotel', '70 Park Avenue', 'NY', 'NY', '10011')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (6, '70 Park Avenue Hotel', '70 Park Avenue', 'NY', 'NY', '10011')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (8, 'Conrad Miami', '1395 Brickell Ave', 'Miami', 'FL', '33131')
DEBUG 07-10 16:21:10,723 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (8, 'Conrad Miami', '1395 Brickell Ave', 'Miami', 'FL', '33131')
DEBUG 07-10 16:21:10,733 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (9, 'Sea Horse Inn', '2106 N Clairemont Ave', 'Eau Claire', 'WI', '54703')
DEBUG 07-10 16:21:10,733 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (9, 'Sea Horse Inn', '2106 N Clairemont Ave', 'Eau Claire', 'WI', '54703')
DEBUG 07-10 16:21:10,743 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (10, 'Super 8 Eau Claire Campus Area', '1151 W Macarthur Ave', 'Eau Claire', 'WI', '54701')
DEBUG 07-10 16:21:10,743 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (10, 'Super 8 Eau Claire Campus Area', '1151 W Macarthur Ave', 'Eau Claire', 'WI', '54701')
DEBUG 07-10 16:21:10,743 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (11, 'Marriot Downtown', '55 Fourth Street', 'San Francisco', 'CA', '94103')
DEBUG 07-10 16:21:10,743 (SchemaExport.java:importScript:238) -insert into Hotel (id, name, address, city, state, zip) values (11, 'Marriot Downtown', '55 Fourth Street', 'San Francisco', 'CA', '94103')
DEBUG 07-10 16:21:10,743 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 1, 'Eigen vermogen, voorzieningen voor risico''s, kosten en schulden op meer dan een jaar')
DEBUG 07-10 16:21:10,743 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 1, 'Eigen vermogen, voorzieningen voor risico''s, kosten en schulden op meer dan een jaar')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 2, 'Oprichtingskosten, vaste activa en vorderingen op meer dan een jaar')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 2, 'Oprichtingskosten, vaste activa en vorderingen op meer dan een jaar')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 3, 'Voorraden en bestellingen in uitvoering')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 3, 'Voorraden en bestellingen in uitvoering')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 4, 'Vorderingen en schulden op ten hoogste een jaar')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 4, 'Vorderingen en schulden op ten hoogste een jaar')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 5, 'Geldbeleggingen en liquide middelen')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 5, 'Geldbeleggingen en liquide middelen')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 6, 'Kosten')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 6, 'Kosten')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 7, 'Opbrengsten')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 7, 'Opbrengsten')
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 40, 'Handelsvorderingen');
DEBUG 07-10 16:21:10,753 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('S', 40, 'Handelsvorderingen');
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('D', 400000, 'Debiteuren (klanten)');
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('D', 400000, 'Debiteuren (klanten)');
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('J', 700000, 'debiteuren')
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account (ACCOUNT_TYPE,NUMBER,DESCRIPTION) values ('J', 700000, 'debiteuren')
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account_account values (4,8);
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account_account values (4,8);
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account_account values (8,9);
DEBUG 07-10 16:21:10,763 (SchemaExport.java:importScript:238) -insert into account_account values (8,9);
INFO 07-10 16:21:10,763 (SchemaExport.java:execute:200) -schema export complete
INFO 07-10 16:21:10,763 (SchemaExport.java:execute:200) -schema export complete
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
DEBUG 07-10 16:21:10,773 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
INFO 07-10 16:21:10,773 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
DEBUG 07-10 16:21:10,773 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:10,773 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:10,973 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:10,973 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:10,973 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:10,973 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:10,983 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:10,983 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:10,983 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:10,983 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,003 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,003 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:11,003 (AnnotationConfiguration.java:secondPassCompile:181) -Execute first pass mapping processing
DEBUG 07-10 16:21:11,003 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:11,003 (AnnotationConfiguration.java:processArtifactsOfType:238) -Process hbm files
DEBUG 07-10 16:21:11,003 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:11,003 (AnnotationConfiguration.java:processArtifactsOfType:246) -Process annotated classes
DEBUG 07-10 16:21:11,013 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
DEBUG 07-10 16:21:11,013 (AnnotationConfiguration.java:secondPassCompile:208) -processing manytoone fk mappings
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:996) -processing extends queue
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:1000) -processing collection mappings
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:1009) -processing association property references
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
INFO 07-10 16:21:11,013 (Configuration.java:secondPassCompile:1031) -processing foreign key constraints
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.User
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: org.jboss.seam.example.booking.Hotel
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.SummaryAccount
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:11,013 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.DetailAccount
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.JournalAccount
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Account
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Transaction
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,023 (Configuration.java:secondPassCompileForeignKeys:1082) -resolving reference to class: ivvo.drapier.model.Entry
DEBUG 07-10 16:21:11,023 (SessionFactoryImpl.java:<init>:305) -obtaining JTA TransactionManager
DEBUG 07-10 16:21:11,023 (SessionFactoryImpl.java:<init>:305) -obtaining JTA TransactionManager
INFO 07-10 16:21:11,033 (NamingHelper.java:getInitialContext:26) -JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
INFO 07-10 16:21:11,033 (NamingHelper.java:getInitialContext:26) -JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
INFO 07-10 16:21:11,033 (SessionFactoryImpl.java:checkNamedQueries:432) -Checking 0 named queries
INFO 07-10 16:21:11,033 (SessionFactoryImpl.java:checkNamedQueries:432) -Checking 0 named queries
INFO 07-10 16:21:11,214 (Ejb3Deployment.java:initializeManagedEntityManagerFactory:520) -Create EntityManager with JNDI name: bookingDatabase
INFO 07-10 16:21:11,234 (Ejb3Deployment.java:create:257) -EJB3 deployment time took: 13169
DEBUG 07-10 16:21:11,234 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatefulManager
DEBUG 07-10 16:21:11,504 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@1549ceb
INFO 07-10 16:21:11,634 (ProxyDeployer.java:start:64) -no declared remote bindings for : ivvo.drapier.logic.JournalServiceBean
DEBUG 07-10 16:21:11,754 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatefulManager
DEBUG 07-10 16:21:11,764 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatelessManager
DEBUG 07-10 16:21:11,774 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@343bb6
INFO 07-10 16:21:11,815 (ProxyDeployer.java:start:64) -no declared remote bindings for : org.jboss.seam.example.booking.BookingListAction
DEBUG 07-10 16:21:11,845 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatelessManager
DEBUG 07-10 16:21:11,845 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatefulManager
DEBUG 07-10 16:21:11,845 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@ae3da8
INFO 07-10 16:21:11,875 (ProxyDeployer.java:start:64) -no declared remote bindings for : org.jboss.seam.example.booking.ChangePasswordAction
DEBUG 07-10 16:21:11,885 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatefulManager
DEBUG 07-10 16:21:11,885 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatefulManager
DEBUG 07-10 16:21:11,895 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@3c86e9
INFO 07-10 16:21:11,925 (ProxyDeployer.java:start:64) -no declared remote bindings for : org.jboss.seam.example.booking.HotelBookingAction
INFO 07-10 16:21:11,925 (ProxyDeployer.java:start:67) -there is remote interfaces for org.jboss.seam.example.booking.HotelBookingAction
INFO 07-10 16:21:11,925 (ProxyDeployer.java:start:69) -default remote binding has jndiName of org.jboss.seam.example.booking.HotelBooking
DEBUG 07-10 16:21:11,985 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatefulManager
DEBUG 07-10 16:21:11,985 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatelessManager
DEBUG 07-10 16:21:11,995 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@1ed54a0
INFO 07-10 16:21:12,005 (ProxyDeployer.java:start:64) -no declared remote bindings for : org.jboss.seam.example.booking.LoginAction
DEBUG 07-10 16:21:12,015 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatelessManager
DEBUG 07-10 16:21:12,015 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatelessManager
DEBUG 07-10 16:21:12,025 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@160f5bf
INFO 07-10 16:21:12,025 (ProxyDeployer.java:start:64) -no declared remote bindings for : org.jboss.seam.example.booking.LogoutAction
DEBUG 07-10 16:21:12,035 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatelessManager
DEBUG 07-10 16:21:12,035 (ServiceMBeanSupport.java:jbossInternalStart:277) -Starting StatefulManager
DEBUG 07-10 16:21:12,035 (UserTransactionImpl.java:<init>:41) -new UserTx: org.jboss.ejb3.tx.UserTransactionImpl@2982d8
INFO 07-10 16:21:12,045 (ProxyDeployer.java:start:64) -no declared remote bindings for : org.jboss.seam.example.booking.RegisterAction
DEBUG 07-10 16:21:12,055 (ServiceMBeanSupport.java:jbossInternalStart:299) -Started StatefulManager
DEBUG 07-10 16:21:12,065 (?:lookupInStatefulContexts:?) -found in application context: org.jboss.seam.core.ejb.component
DEBUG 07-10 16:21:12,065 (?:lookupInStatefulContexts:?) -