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
