more specifically from the DEBUG. It looks like i'm losing the transaction. Below is the problem for the bad database, and below that is the good database (one that works).
2006-04-18 15:28:32,355 INFO [STDOUT] ************ gettting id: null 2006-04-18 15:28:32,371 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] executing identity-insert immediately 2006-04-18 15:28:32,371 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2006-04-18 15:28:32,371 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2006-04-18 15:28:32,371 DEBUG [org.hibernate.SQL] insert into skxshop_user (password, email, registration_date, last_login_date, cancelled, store_id, banned, zip, password_exp_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?) 2006-04-18 15:28:32,371 INFO [STDOUT] Hibernate: insert into skxshop_user (password, email, registration_date, last_login_date, cancelled, store_id, banned, zip, password_exp_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?) 2006-04-18 15:28:32,402 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 2006-04-18 15:28:32,402 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection 2006-04-18 15:28:32,402 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 2006-04-18 15:28:32,402 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered 2006-04-18 15:28:32,402 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered 2006-04-18 15:28:32,402 DEBUG [org.jboss.ejb3.entity.ManagedEntityManagerFactory] ************** closing entity managersession ************** 2006-04-18 15:28:32,402 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered 2006-04-18 15:28:32,402 DEBUG [org.apache.struts.util.PropertyMessageResources] getMessage(en_US,unhandledException) 2006-04-18 15:41:49,459 INFO [STDOUT] ************ gettting id: null 2006-04-18 15:41:49,475 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] executing identity-insert immediately 2006-04-18 15:41:49,475 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2006-04-18 15:41:49,475 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2006-04-18 15:41:49,475 DEBUG [org.hibernate.SQL] insert into skxshop_user (password, email, registration_date, last_login_date, cancelled, store_id, banned, zip, password_exp_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?) 2006-04-18 15:41:49,475 INFO [STDOUT] Hibernate: insert into skxshop_user (password, email, registration_date, last_login_date, cancelled, store_id, banned, zip, password_exp_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?) 2006-04-18 15:41:49,537 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 2006-04-18 15:41:49,537 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection 2006-04-18 15:41:49,537 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 2006-04-18 15:41:49,537 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2006-04-18 15:41:49,537 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2006-04-18 15:41:49,537 DEBUG [org.hibernate.SQL] select dbinfo('sqlca.sqlerrd1') from systables where tabid=1 2006-04-18 15:41:49,537 INFO [STDOUT] Hibernate: select dbinfo('sqlca.sqlerrd1') from systables where tabid=1 2006-04-18 15:41:49,537 DEBUG [org.hibernate.id.IdentifierGeneratorFactory] Natively generated identity: 1 2006-04-18 15:41:49,537 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 2006-04-18 15:41:49,553 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection 2006-04-18 15:41:49,553 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 2006-04-18 15:41:49,553 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2006-04-18 15:41:49,553 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2006-04-18 15:41:49,553 DEBUG [org.hibernate.SQL] insert into skxshop_user_profile (opt_in, gender, first_name, last_name, birth_year, birth_month, birth_day, last_purc_date, user_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?) 2006-04-18 15:41:49,553 INFO [STDOUT] Hibernate: insert into skxshop_user_profile (opt_in, gender, first_name, last_name, birth_year, birth_month, birth_day, last_purc_date, user_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?) 2006-04-18 15:41:49,569 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3938031#3938031 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3938031 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user