Invoking test method [public void intouch.salesTracker.business.TaskTest.testConstructor()]
prepareTestInstance(): instance [intouch.salesTracker.business.TaskTest@2585e]
Performing dependency injection for test context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = [null], testException = [null]]].
Found injected method on class [intouch.salesTracker.business.TaskTest]: ResourceElement for public void intouch.tests.BaseSpringTransacationalTests.setCoreService(intouch.core.services.CoreService)
Found injected method on class [intouch.salesTracker.business.TaskTest]: ResourceElement for public void intouch.tests.BaseSpringTransacationalTests.setDataSource(javax.sql.DataSource)
Getting BeanInfo for class [intouch.salesTracker.business.TaskTest]
Caching PropertyDescriptors for class [intouch.salesTracker.business.TaskTest]
Found bean property 'applicationContext' of type [org.springframework.context.ApplicationContext]
Found bean property 'class' of type [java.lang.Class]
Found bean property 'coreService' of type [intouch.core.services.CoreService]
Found bean property 'dataSource' of type [javax.sql.DataSource]
Found bean property 'sqlScriptEncoding' of type [java.lang.String]
Found bean property 'stampDateFields' of type [intouch.model.core.IStampedObject]
Processing injected method of bean 'intouch.salesTracker.business.TaskTest': ResourceElement for public void intouch.tests.BaseSpringTransacationalTests.setCoreService(intouch.core.services.CoreService)
Returning cached instance of singleton bean 'coreService'
Processing injected method of bean 'intouch.salesTracker.business.TaskTest': ResourceElement for public void intouch.tests.BaseSpringTransacationalTests.setDataSource(javax.sql.DataSource)
Returning cached instance of singleton bean 'dataSource'
Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor'
Adding transactional method [testConstructor] with attribute [PROPAGATION_REQUIRED,ISOLATION_DEFAULT]
Creating [java.util.concurrent.ConcurrentHashMap]
Creating implicit proxy for bean 'intouch.salesTracker.business.TaskTest' with 0 common interceptors and 1 specific interceptors
Creating JDK dynamic proxy: target source is SingletonTargetSource for target object [intouch.salesTracker.business.TaskTest@2585e]
beforeTestMethod(): instance [intouch.salesTracker.business.TaskTest@2585e], method [public void intouch.salesTracker.business.TaskTest.testConstructor()]
Adding transactional method [testConstructor] with attribute [PROPAGATION_REQUIRED,ISOLATION_DEFAULT]
Explicit transaction definition [PROPAGATION_REQUIRED,ISOLATION_DEFAULT] found for test context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = testConstructor@TaskTest, testException = [null]]]
Retrieved @TransactionConfiguration [@org.springframework.test.context.transaction.TransactionConfiguration(defaultRollback=true, transactionManager=transactionManager)] for test class [class intouch.salesTracker.business.TaskTest]
Retrieved TransactionConfigurationAttributes [[TransactionConfigurationAttributes@9e75f6 transactionManagerName = 'transactionManager', defaultRollback = true]] for class [class intouch.salesTracker.business.TaskTest]
Returning cached instance of singleton bean 'transactionManager'
Creating new transaction with name [testConstructor]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
Acquired Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for JDBC transaction
Bound value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] to thread [main]
Initializing transaction synchronization
Retrieved @TransactionConfiguration [@org.springframework.test.context.transaction.TransactionConfiguration(defaultRollback=true, transactionManager=transactionManager)] for test class [class intouch.salesTracker.business.TaskTest]
Retrieved TransactionConfigurationAttributes [[TransactionConfigurationAttributes@1d4eeb5 transactionManagerName = 'transactionManager', defaultRollback = true]] for class [class intouch.salesTracker.business.TaskTest]
No method-level @Rollback override: using default rollback [true] for test context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = testConstructor@TaskTest, testException = [null]]]
Began transaction (1): transaction manager [org.springframework.jdbc.datasource.DataSourceTransactionManager@e2fbeb]; rollback [true]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@83e35b] for iBATIS operation
{conn-100644} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100644} Preparing Statement:              SELECT nextVal('enterprises_enterprise_id_seq')
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100645} Executing Statement:              SELECT nextVal('enterprises_enterprise_id_seq')
{pstm-100645} Parameters: []
{pstm-100645} Types: []
{rset-100646} ResultSet
{rset-100646} Header: [nextval]
{rset-100646} Result: [2578]
{conn-100644} Preparing Statement:          INSERT INTO enterprises(enterprise_id, name, notes, lease_expire, is_template, is_customer, can_delete )   VALUES(?, ?, ?, ?, ?, ?, ? )
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100647} Executing Statement:          INSERT INTO enterprises(enterprise_id, name, notes, lease_expire, is_template, is_customer, can_delete )   VALUES(?, ?, ?, ?, ?, ?, ? )
{pstm-100647} Parameters: [2578, Test enterprise, enterprise notes, null, false, false, false]
{pstm-100647} Types: [java.lang.Integer, java.lang.String, java.lang.String, null, java.lang.Boolean, java.lang.Boolean, java.lang.Boolean]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@1cbd4f7] for iBATIS operation
{conn-100648} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100648} Preparing Statement:              SELECT nextVal('clubs_club_id_seq')
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100649} Executing Statement:              SELECT nextVal('clubs_club_id_seq')
{pstm-100649} Parameters: []
{pstm-100649} Types: []
{rset-100650} ResultSet
{rset-100650} Header: [nextval]
{rset-100650} Result: [2527]
{conn-100648} Preparing Statement:          INSERT INTO clubs(club_id, enterprise_id, parent_club_id, name,     address, city, state, country, zipcode,    url, telephone, email, fax,    locale, timezone_id, uuid)   VALUES(?, ?, ?, ?,     ?, ?, ?, ?, ?,    ?, ?, ?, ?,    ?, ?, ?::uuid)
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100651} Executing Statement:          INSERT INTO clubs(club_id, enterprise_id, parent_club_id, name,     address, city, state, country, zipcode,    url, telephone, email, fax,    locale, timezone_id, uuid)   VALUES(?, ?, ?, ?,     ?, ?, ?, ?, ?,    ?, ?, ?, ?,    ?, ?, ?::uuid)
{pstm-100651} Parameters: [2527, 2578, -1234, Test club, address, city, state, US, zipcode, url, telephone, email, fax, en_US, 14758, 0f7e5043-d8c9-442b-b23c-c645780b1413]
{pstm-100651} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.Integer, java.lang.String]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@10ade7e] for iBATIS operation
{conn-100652} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100652} Preparing Statement:              SELECT nextVal('pp_roles_role_id_seq')
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100653} Executing Statement:              SELECT nextVal('pp_roles_role_id_seq')
{pstm-100653} Parameters: []
{pstm-100653} Types: []
{rset-100654} ResultSet
{rset-100654} Header: [nextval]
{rset-100654} Result: [59753]
{conn-100652} Preparing Statement:          INSERT INTO pp_roles(role_id, name, comments, club_id, permissions, ismembersrole)   VALUES(?, ?, ?, ?, ?, ?)
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100655} Executing Statement:          INSERT INTO pp_roles(role_id, name, comments, club_id, permissions, ismembersrole)   VALUES(?, ?, ?, ?, ?, ?)
{pstm-100655} Parameters: [59753, role name, new comments, 2527, perms, true]
{pstm-100655} Types: [java.lang.Integer, java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.Boolean]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@956254] for iBATIS operation
{conn-100656} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100656} Preparing Statement:              SELECT nextVal('users_user_id_seq')
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100657} Executing Statement:              SELECT nextVal('users_user_id_seq')
{pstm-100657} Parameters: []
{pstm-100657} Types: []
{rset-100658} ResultSet
{rset-100658} Header: [nextval]
{rset-100658} Result: [416509]
{conn-100656} Preparing Statement:          INSERT INTO users(user_id, enterprise_id, club_id, uuid,    firstname, lastname, username, password, gender,     birthDate,    user_type, user_status,     email, mobile, home_phone, work_phone, fax,     street, city, state, zipcode, country,     membership_id, joined_date, social_number, company,    div1, div2, div3, div4, role_id,       created_user_id, created_date, modified_user_id, modified_date)   VALUES( ?, ?, ?, ?::uuid,    ?, ?, ?, ?, ?,     ?,    ?::user_types, ?::user_statuses,    ?, ?, ?, ?, ?,     ?, ?, ?, ?, ?,     ?, ?, ?, ?,    ?, ?, ?, ?, ?,       ?, ?, ?, ?)
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100659} Executing Statement:          INSERT INTO users(user_id, enterprise_id, club_id, uuid,    firstname, lastname, username, password, gender,     birthDate,    user_type, user_status,     email, mobile, home_phone, work_phone, fax,     street, city, state, zipcode, country,     membership_id, joined_date, social_number, company,    div1, div2, div3, div4, role_id,       created_user_id, created_date, modified_user_id, modified_date)   VALUES( ?, ?, ?, ?::uuid,    ?, ?, ?, ?, ?,     ?,    ?::user_types, ?::user_statuses,    ?, ?, ?, ?, ?,     ?, ?, ?, ?, ?,     ?, ?, ?, ?,    ?, ?, ?, ?, ?,       ?, ?, ?, ?)
{pstm-100659} Parameters: [416509, 2578, 2527, 197b594c-db2a-43b5-9dad-bd84a794cbd1, Test, Staff, staff123, password, null, null, STAFF, ACTIVE, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, -1, 2010-05-31 12:24:40.606, -1, 2010-05-31 12:24:40.606]
{pstm-100659} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, null, null, java.lang.String, java.lang.String, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, java.lang.Integer, java.sql.Timestamp, java.lang.Integer, java.sql.Timestamp]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@16aa42e] for iBATIS operation
{conn-100660} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100660} Preparing Statement:    SELECT  user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,           appointment_email, notification_email, notification_sms, appointment_sms,            notification_email_offset_minutes, notification_sms_offset_minutes,            appointment_email_offset_minutes, appointment_sms_offset_minutes,           locale, timezone_id, set_by_user         FROM    user_preferences          WHERE   user_id = ?
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100661} Executing Statement:    SELECT  user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,           appointment_email, notification_email, notification_sms, appointment_sms,            notification_email_offset_minutes, notification_sms_offset_minutes,            appointment_email_offset_minutes, appointment_sms_offset_minutes,           locale, timezone_id, set_by_user         FROM    user_preferences          WHERE   user_id = ?
{pstm-100661} Parameters: [416509]
{pstm-100661} Types: [java.lang.Integer]
{rset-100662} ResultSet
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@14d659d] for iBATIS operation
{conn-100663} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100663} Preparing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100664} Executing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
{pstm-100664} Parameters: [416509]
{pstm-100664} Types: [java.lang.Integer]
{rset-100665} ResultSet
{rset-100665} Header: [club_id, enterprise_id, parent_club_id, name, address, city, state, country, zipcode, url, telephone, email, fax, locale, zone_identifier, timezone_id, uuid]
{rset-100665} Result: [2527, 2578, -1234, Test club, address, city, state, US, zipcode, url, telephone, email, fax, en_US, US/Pacific, 14758, 0f7e5043-d8c9-442b-b23c-c645780b1413]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@4a3158] for iBATIS operation
{conn-100666} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100666} Preparing Statement:    UPDATE user_preferences SET     is_subscribed_to_general_emails = ?,    is_subscribed_to_announcement_emails = ?,    appointment_email = ?,     notification_email = ?,    notification_sms = ?,     appointment_sms = ?,     notification_email_offset_minutes = ?,     notification_sms_offset_minutes = ?,     appointment_email_offset_minutes = ?,     appointment_sms_offset_minutes = ?,     locale = ?,     timezone_id = ?,     set_by_user = ?   WHERE user_id = ?
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100667} Executing Statement:    UPDATE user_preferences SET     is_subscribed_to_general_emails = ?,    is_subscribed_to_announcement_emails = ?,    appointment_email = ?,     notification_email = ?,    notification_sms = ?,     appointment_sms = ?,     notification_email_offset_minutes = ?,     notification_sms_offset_minutes = ?,     appointment_email_offset_minutes = ?,     appointment_sms_offset_minutes = ?,     locale = ?,     timezone_id = ?,     set_by_user = ?   WHERE user_id = ?
{pstm-100667} Parameters: [-1, -1, -1, -1, -1, -1, 240, 240, 60, 60, en_US, 14758, false, 416509]
{pstm-100667} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.Integer, java.lang.Boolean, java.lang.Integer]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@ed8eb5] for iBATIS operation
{conn-100668} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100668} Preparing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100669} Executing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
{pstm-100669} Parameters: [416509]
{pstm-100669} Types: [java.lang.Integer]
{rset-100670} ResultSet
{rset-100670} Header: [club_id, enterprise_id, parent_club_id, name, address, city, state, country, zipcode, url, telephone, email, fax, locale, zone_identifier, timezone_id, uuid]
{rset-100670} Result: [2527, 2578, -1234, Test club, address, city, state, US, zipcode, url, telephone, email, fax, en_US, US/Pacific, 14758, 0f7e5043-d8c9-442b-b23c-c645780b1413]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@343bb6] for iBATIS operation
{conn-100671} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100671} Preparing Statement:    INSERT into user_preferences (user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,       appointment_email, notification_email, notification_sms, appointment_sms,       notification_email_offset_minutes, notification_sms_offset_minutes, appointment_email_offset_minutes,       appointment_sms_offset_minutes, locale, set_by_user, timezone_id)       VALUES (?, ?, ?,          ?, ?, ?, ?,           ?, ?, ?,           ?, ?, ?, ?)
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100672} Executing Statement:    INSERT into user_preferences (user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,       appointment_email, notification_email, notification_sms, appointment_sms,       notification_email_offset_minutes, notification_sms_offset_minutes, appointment_email_offset_minutes,       appointment_sms_offset_minutes, locale, set_by_user, timezone_id)       VALUES (?, ?, ?,          ?, ?, ?, ?,           ?, ?, ?,           ?, ?, ?, ?)
{pstm-100672} Parameters: [416509, -1, -1, -1, -1, -1, -1, 240, 240, 60, 60, en_US, false, 14758]
{pstm-100672} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.Boolean, java.lang.Integer]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@13c3b45] for iBATIS operation
{conn-100673} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100673} Preparing Statement:              SELECT nextVal('users_user_id_seq')
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100674} Executing Statement:              SELECT nextVal('users_user_id_seq')
{pstm-100674} Parameters: []
{pstm-100674} Types: []
{rset-100675} ResultSet
{rset-100675} Header: [nextval]
{rset-100675} Result: [416510]
{conn-100673} Preparing Statement:          INSERT INTO users(user_id, enterprise_id, club_id, uuid,    firstname, lastname, username, password, gender,     birthDate,    user_type, user_status,     email, mobile, home_phone, work_phone, fax,     street, city, state, zipcode, country,     membership_id, joined_date, social_number, company,    div1, div2, div3, div4, role_id,       created_user_id, created_date, modified_user_id, modified_date)   VALUES( ?, ?, ?, ?::uuid,    ?, ?, ?, ?, ?,     ?,    ?::user_types, ?::user_statuses,    ?, ?, ?, ?, ?,     ?, ?, ?, ?, ?,     ?, ?, ?, ?,    ?, ?, ?, ?, ?,       ?, ?, ?, ?)
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100676} Executing Statement:          INSERT INTO users(user_id, enterprise_id, club_id, uuid,    firstname, lastname, username, password, gender,     birthDate,    user_type, user_status,     email, mobile, home_phone, work_phone, fax,     street, city, state, zipcode, country,     membership_id, joined_date, social_number, company,    div1, div2, div3, div4, role_id,       created_user_id, created_date, modified_user_id, modified_date)   VALUES( ?, ?, ?, ?::uuid,    ?, ?, ?, ?, ?,     ?,    ?::user_types, ?::user_statuses,    ?, ?, ?, ?, ?,     ?, ?, ?, ?, ?,     ?, ?, ?, ?,    ?, ?, ?, ?, ?,       ?, ?, ?, ?)
{pstm-100676} Parameters: [416510, 2578, 2527, e88c835e-1219-48f3-8393-c566f83e7fa1, Test, Contact, test123, password, null, null, PUBLIC, ACTIVE, test@intouchtechnology.com, 16047028374, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 416509, 2010-05-31 12:24:40.616, 416509, 2010-05-31 12:24:40.616]
{pstm-100676} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, null, null, java.lang.String, java.lang.String, java.lang.String, java.lang.String, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, java.lang.Integer, java.sql.Timestamp, java.lang.Integer, java.sql.Timestamp]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@15738e0] for iBATIS operation
{conn-100677} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100677} Preparing Statement:    SELECT  user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,           appointment_email, notification_email, notification_sms, appointment_sms,            notification_email_offset_minutes, notification_sms_offset_minutes,            appointment_email_offset_minutes, appointment_sms_offset_minutes,           locale, timezone_id, set_by_user         FROM    user_preferences          WHERE   user_id = ?
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100678} Executing Statement:    SELECT  user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,           appointment_email, notification_email, notification_sms, appointment_sms,            notification_email_offset_minutes, notification_sms_offset_minutes,            appointment_email_offset_minutes, appointment_sms_offset_minutes,           locale, timezone_id, set_by_user         FROM    user_preferences          WHERE   user_id = ?
{pstm-100678} Parameters: [416510]
{pstm-100678} Types: [java.lang.Integer]
{rset-100679} ResultSet
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@15726ec] for iBATIS operation
{conn-100680} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100680} Preparing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100681} Executing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
{pstm-100681} Parameters: [416510]
{pstm-100681} Types: [java.lang.Integer]
{rset-100682} ResultSet
{rset-100682} Header: [club_id, enterprise_id, parent_club_id, name, address, city, state, country, zipcode, url, telephone, email, fax, locale, zone_identifier, timezone_id, uuid]
{rset-100682} Result: [2527, 2578, -1234, Test club, address, city, state, US, zipcode, url, telephone, email, fax, en_US, US/Pacific, 14758, 0f7e5043-d8c9-442b-b23c-c645780b1413]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@bc6007] for iBATIS operation
{conn-100683} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100683} Preparing Statement:    UPDATE user_preferences SET     is_subscribed_to_general_emails = ?,    is_subscribed_to_announcement_emails = ?,    appointment_email = ?,     notification_email = ?,    notification_sms = ?,     appointment_sms = ?,     notification_email_offset_minutes = ?,     notification_sms_offset_minutes = ?,     appointment_email_offset_minutes = ?,     appointment_sms_offset_minutes = ?,     locale = ?,     timezone_id = ?,     set_by_user = ?   WHERE user_id = ?
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100684} Executing Statement:    UPDATE user_preferences SET     is_subscribed_to_general_emails = ?,    is_subscribed_to_announcement_emails = ?,    appointment_email = ?,     notification_email = ?,    notification_sms = ?,     appointment_sms = ?,     notification_email_offset_minutes = ?,     notification_sms_offset_minutes = ?,     appointment_email_offset_minutes = ?,     appointment_sms_offset_minutes = ?,     locale = ?,     timezone_id = ?,     set_by_user = ?   WHERE user_id = ?
{pstm-100684} Parameters: [-1, -1, -1, -1, -1, -1, 240, 240, 60, 60, en_US, 14758, false, 416510]
{pstm-100684} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.Integer, java.lang.Boolean, java.lang.Integer]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@144752d] for iBATIS operation
{conn-100685} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100685} Preparing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100686} Executing Statement:       SELECT c.*, tz.zone_identifier          FROM clubs c, timezones tz          WHERE club_id = (          SELECT club_id           FROM users           WHERE user_id = ?         )         AND c.timezone_id = tz.timezone_id
{pstm-100686} Parameters: [416510]
{pstm-100686} Types: [java.lang.Integer]
{rset-100687} ResultSet
{rset-100687} Header: [club_id, enterprise_id, parent_club_id, name, address, city, state, country, zipcode, url, telephone, email, fax, locale, zone_identifier, timezone_id, uuid]
{rset-100687} Result: [2527, 2578, -1234, Test club, address, city, state, US, zipcode, url, telephone, email, fax, en_US, US/Pacific, 14758, 0f7e5043-d8c9-442b-b23c-c645780b1413]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@168e429] for iBATIS operation
{conn-100688} Connection
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Obtained JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] for iBATIS operation
{conn-100688} Preparing Statement:    INSERT into user_preferences (user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,       appointment_email, notification_email, notification_sms, appointment_sms,       notification_email_offset_minutes, notification_sms_offset_minutes, appointment_email_offset_minutes,       appointment_sms_offset_minutes, locale, set_by_user, timezone_id)       VALUES (?, ?, ?,          ?, ?, ?, ?,           ?, ?, ?,           ?, ?, ?, ?)
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
{pstm-100689} Executing Statement:    INSERT into user_preferences (user_id, is_subscribed_to_general_emails, is_subscribed_to_announcement_emails,       appointment_email, notification_email, notification_sms, appointment_sms,       notification_email_offset_minutes, notification_sms_offset_minutes, appointment_email_offset_minutes,       appointment_sms_offset_minutes, locale, set_by_user, timezone_id)       VALUES (?, ?, ?,          ?, ?, ?, ?,           ?, ?, ?,           ?, ?, ?, ?)
{pstm-100689} Parameters: [416510, -1, -1, -1, -1, -1, -1, 240, 240, 60, 60, en_US, false, 14758]
{pstm-100689} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.String, java.lang.Boolean, java.lang.Integer]
Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] bound to thread [main]
Test method [public void intouch.salesTracker.business.TaskTest.testConstructor()] threw exception: null
afterTestMethod(): instance [intouch.salesTracker.business.TaskTest@2585e], method [public void intouch.salesTracker.business.TaskTest.testConstructor()], exception [null]
Retrieved @TransactionConfiguration [@org.springframework.test.context.transaction.TransactionConfiguration(defaultRollback=true, transactionManager=transactionManager)] for test class [class intouch.salesTracker.business.TaskTest]
Retrieved TransactionConfigurationAttributes [[TransactionConfigurationAttributes@15b4492 transactionManagerName = 'transactionManager', defaultRollback = true]] for class [class intouch.salesTracker.business.TaskTest]
No method-level @Rollback override: using default rollback [true] for test context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = testConstructor@TaskTest, testException = [null]]]
Ending transaction for test context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = testConstructor@TaskTest, testException = [null]]]; transaction manager [org.springframework.transaction.support.DefaultTransactionStatus@f2f0d0]; rollback [true]
Triggering beforeCompletion synchronization
Initiating transaction rollback
Rolling back JDBC transaction on Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver]
Triggering afterCompletion synchronization
Clearing transaction synchronization
Removed value [org.springframework.jdbc.datasource.ConnectionHolder@1e22c75] for key [org.apache.commons.dbcp.BasicDataSource@1ef3d1b] from thread [main]
Releasing JDBC Connection [jdbc:postgresql://intdevel:5432/intouch_devel_db2, UserName=mcrtdbms, PostgreSQL Native Driver] after transaction
Returning JDBC Connection to DataSource
Rolled back transaction after test execution for test context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = testConstructor@TaskTest, testException = [null]]]
After test method: context [[TestContext@1f796d0 testClass = TaskTest, locations = array<String>['classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:*ApplicationContext.xml', 'classpath*:applicationContext-junit.xml', 'classpath*:applicationContext-junit-db.xml', 'classpath*:coreApplicationContext.xml', 'classpath*:salesTrackerApplicationContext.xml', 'classpath*:calendarApplicationContext.xml', 'classpath*:messagingQueueApplicationContext.xml', 'classpath*:historyApplicationContext.xml', 'classpath*:partitioningApplicationContext.xml'], testInstance = intouch.salesTracker.business.TaskTest@2585e, testMethod = testConstructor@TaskTest, testException = [null]]], dirtiesContext [false].