Hi.

I have a problem.

I have recently migrated form hibernate 2 to 3.1.2. Now, when I go to either add or edit user in my application, it gives me this error:

ERROR - IllegalArgumentException in class: com.oysterware.akoya.model.domain.User, setter method of property: administrator
ERROR - expected type: java.lang.String, actual value: java.lang.Boolean

It is probably something I have not configured correctly. I would be grateful if someone knows what causing this problem can give me a few pointers.

Thanks.

Hibernate version:

3.1.2

Name and version of the database you are using:

Oracle 9i

Mapping documents:

User.hbm.xml

<class name="com.oysterware.akoya.model.domain.User" table="USERS" lazy="false">

<id name="userID" column="USER_ID" type="long" unsaved-value="null">
<generator class="sequence">
<param name="sequence">USERS_S</param>
</generator>
</id>

<property name="userName" column="USER_NAME" type="string" not-null="true" unique="true"/>

<property name="firstName" column="FIRST_NAME" type="string" not-null="true"/>

<property name="lastName" column="LAST_NAME" type="string" not-null="true"/>

<property name="companyID" column="COMPANY_ID" type="long" not-null="true"/>

<property name="accountLocked" column="ACCOUNT_LOCKED" type="char" not-null="true"/>

<property name="title" column="TITLE" type="string"/>

<property name="emailAddress" column="EMAIL_ADDRESS" type="string"/>

<property name="workPhone" column="WORK_PHONE" type="string"/>

<property name="userPassword" column="USER_PASSWORD" type="string"/>

<property name="hintQuestion" column="HINT_QUESTION" type="string"/>

<property name="hintAnswer" column="HINT_ANSWER" type="string"/>

<property name="logonAttempts" column="LOGON_ATTEMPTS" type="short"/>

<property name="passwordExpiry" column="PASSWORD_EXPIRY" type="date"/>

<property name="languageID" column="LANGUAGE_ID" type="long"/>

<property name="jobTitle" column="JOB_TITLE" type="string"/>
<property name="administrator" column="IS_ADMINISTRATOR" type="string" not-null="true"/>

<set name="usersRoles" table="USERS_ROLES" lazy="true" inverse="false" cascade="none" order-by="ROLE_ID">
<key column="USER_ID"/>
<many-to-many class="com.oysterware.akoya.model.domain.Role" column="ROLE_ID" />
</set>

</class>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

12:14:44 GMT 2006 ***

[12:14:44.765] dispatcher: init
INFO - MLog clients using log4j logging.
DEBUG - awaitAvailable(): [unknown]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 0, unused: 0, excluded: 0]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 1, unused: 1, excluded: 0]
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e ---> age: 0 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 4, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 5, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - Creating new CacheManager with default config
DEBUG - Configuring ehcache from classpath.
WARN - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:
DEBUG - Disk Store Path:
DEBUG - Trying to logon User: AdminUser
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@deeebd ---> age: 39203 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select user0_.USER_ID as USER1_33_, user0_.USER_NAME as USER2_33_, user0_.FIRST_NAME as FIRST3_33_, user0_.LAST_NAME as LAST4_33_, user0_.COMPANY_ID as COMPANY5_33_, user0_.ACCOUNT_LOCKED as ACCOUNT6_33_, user0_.TITLE as TITLE33_, user0_.EMAIL_ADDRESS as EMAIL8_33_, user0_.WORK_PHONE as WORK9_33_, user0_.USER_PASSWORD as USER10_33_, user0_.HINT_QUESTION as HINT11_33_, user0_.HINT_ANSWER as HINT12_33_, user0_.LOGON_ATTEMPTS as LOGON13_33_, user0_.PASSWORD_EXPIRY as PASSWORD14_33_, user0_.LANGUAGE_ID as LANGUAGE15_33_, user0_.JOB_TITLE as JOB16_33_, user0_.IS_ADMINISTRATOR as IS17_33_ from GOLD.USERS user0_ where user0_.USER_NAME=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - User now logged on: AdminUser
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e ---> age: 40453 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select usersroles0_.USER_ID as USER1_1_, usersroles0_.ROLE_ID as ROLE2_1_, role1_.ROLE_ID as ROLE1_35_0_, role1_.ROLE_NAME as ROLE2_35_0_, role1_.ROLE_DESCRIPTION as ROLE3_35_0_ from GOLD.USERS_ROLES usersroles0_ left outer join GOLD.ROLES role1_ on usersroles0_.ROLE_ID=role1_.ROLE_ID where usersroles0_.USER_ID=? order by usersroles0_.ROLE_ID
Hibernate: select applicatio0_.LOCALE_ID as LOCALE1_51_0_, applicatio0_.DESCRIPTION as DESCRIPT2_51_0_, applicatio0_.LANGUAGE_ISO as LANGUAGE3_51_0_, applicatio0_.LANGUAGE_COUNTRY as LANGUAGE4_51_0_, applicatio0_.DATE_PATTERN as DATE5_51_0_, applicatio0_.SCRIPT_PATTERN as SCRIPT6_51_0_, applicatio0_.TIME_PATTERN as TIME7_51_0_ from GOLD.LOCALE applicatio0_ where applicatio0_.LOCALE_ID=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
[12:16:58.531] resin-file: init
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@52f73e ---> age: 46657 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select company0_.COMPANY_ID as COMPANY1_30_0_, company0_.COMPANY_NAME as COMPANY2_30_0_, company0_.ADDRESS_1 as ADDRESS3_30_0_, company0_.ADDRESS_2 as ADDRESS4_30_0_, company0_.ADDRESS_3 as ADDRESS5_30_0_, company0_.CITY_ID as CITY6_30_0_, company0_.COUNTY_ID as COUNTY7_30_0_, company0_.COUNTRY_ID as COUNTRY8_30_0_, company0_.OTHER_CITY as OTHER9_30_0_, company0_.OTHER_COUNTY as OTHER10_30_0_, company0_.OTHER_COUNTRY as OTHER11_30_0_, company0_.POST_CODE as POST12_30_0_, company0_.WEB_URL as WEB13_30_0_, company0_.BASE_MEDIA_DRIVE as BASE14_30_0_, company0_.SERVICE_PROVIDER as SERVICE15_30_0_, company0_.APPLICATION_ADMIN as APPLICA16_30_0_, company0_.SWITCHBOARD as SWITCHB17_30_0_ from GOLD.COMPANY company0_ where company0_.COMPANY_ID=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1ac7fbb ---> age: 46750 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select company0_.COMPANY_ID as COMPANY1_30_, company0_.COMPANY_NAME as COMPANY2_30_, company0_.ADDRESS_1 as ADDRESS3_30_, company0_.ADDRESS_2 as ADDRESS4_30_, company0_.ADDRESS_3 as ADDRESS5_30_, company0_.CITY_ID as CITY6_30_, company0_.COUNTY_ID as COUNTY7_30_, company0_.COUNTRY_ID as COUNTRY8_30_, company0_.OTHER_CITY as OTHER9_30_, company0_.OTHER_COUNTY as OTHER10_30_, company0_.OTHER_COUNTRY as OTHER11_30_, company0_.POST_CODE as POST12_30_, company0_.WEB_URL as WEB13_30_, company0_.BASE_MEDIA_DRIVE as BASE14_30_, company0_.SERVICE_PROVIDER as SERVICE15_30_, company0_.APPLICATION_ADMIN as APPLICA16_30_, company0_.SWITCHBOARD as SWITCHB17_30_ from GOLD.COMPANY company0_ order by company0_.COMPANY_NAME
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - Entering Company Manager
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@f3cf72 ---> age: 55109 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select companytyp0_.COMPANY_TYPES_LOOKUP_ID as COMPANY1_57_, companytyp0_.COMPANY_TYPES_DESCRIPTION as COMPANY2_57_, companytyp0_.LOCALE_GROUP as LOCALE3_57_, companytyp0_.COMPANY_TYPES_ID as COMPANY4_57_ from GOLD.COMPANY_TYPES_LOOKUP companytyp0_ where companytyp0_.LOCALE_GROUP=? order by companytyp0_.COMPANY_TYPES_DESCRIPTION
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@deeebd ---> age: 15954 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select companytyp0_.COMPANY_TYPES_LOOKUP_ID as COMPANY1_57_, companytyp0_.COMPANY_TYPES_DESCRIPTION as COMPANY2_57_, companytyp0_.LOCALE_GROUP as LOCALE3_57_, companytyp0_.COMPANY_TYPES_ID as COMPANY4_57_ from GOLD.COMPANY_TYPES_LOOKUP companytyp0_ where companytyp0_.LOCALE_GROUP=? order by companytyp0_.COMPANY_TYPES_DESCRIPTION
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e ---> age: 15500 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select group0_.GROUP_ID as GROUP1_39_, group0_.GROUP_CODE as GROUP2_39_, group0_.GROUP_NAME as GROUP3_39_, group0_.GROUP_DESCRIPTION as GROUP4_39_, group0_.GROUP_OWNER as GROUP5_39_, group0_.CREATOR as CREATOR39_, group0_.CREATION_DATE as CREATION7_39_, group0_.MODIFIER as MODIFIER39_, group0_.MODIFICATION_DATE as MODIFICA9_39_, group0_.TOTAL_DISPLAY_POINT as TOTAL10_39_, group0_.TOTAL_NO_OF_SCREENS as TOTAL11_39_, group0_.MARKET_ID as MARKET12_39_ from GOLD.GROUPS group0_ order by group0_.GROUP_NAME
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@52f73e ---> age: 9516 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select market0_.MARKET_ID as MARKET1_44_, market0_.MARKET_NAME as MARKET2_44_, market0_.MARKET_DESCRIPTION as MARKET3_44_, market0_.CREATOR as CREATOR44_, market0_.CREATION_DATE as CREATION5_44_, market0_.MODIFIER as MODIFIER44_, market0_.MODIFICATION_DATE as MODIFICA7_44_ from GOLD.MARKET market0_ order by market0_.MARKET_NAME
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - Entering new Company
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1ac7fbb ---> age: 12297 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select company0_.COMPANY_ID as COMPANY1_30_0_, company0_.COMPANY_NAME as COMPANY2_30_0_, company0_.ADDRESS_1 as ADDRESS3_30_0_, company0_.ADDRESS_2 as ADDRESS4_30_0_, company0_.ADDRESS_3 as ADDRESS5_30_0_, company0_.CITY_ID as CITY6_30_0_, company0_.COUNTY_ID as COUNTY7_30_0_, company0_.COUNTRY_ID as COUNTRY8_30_0_, company0_.OTHER_CITY as OTHER9_30_0_, company0_.OTHER_COUNTY as OTHER10_30_0_, company0_.OTHER_COUNTRY as OTHER11_30_0_, company0_.POST_CODE as POST12_30_0_, company0_.WEB_URL as WEB13_30_0_, company0_.BASE_MEDIA_DRIVE as BASE14_30_0_, company0_.SERVICE_PROVIDER as SERVICE15_30_0_, company0_.APPLICATION_ADMIN as APPLICA16_30_0_, company0_.SWITCHBOARD as SWITCHB17_30_0_ from GOLD.COMPANY company0_ where company0_.COMPANY_ID=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@f3cf72 ---> age: 5875 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select company0_.COMPANY_ID as COMPANY1_30_, company0_.COMPANY_NAME as COMPANY2_30_, company0_.ADDRESS_1 as ADDRESS3_30_, company0_.ADDRESS_2 as ADDRESS4_30_, company0_.ADDRESS_3 as ADDRESS5_30_, company0_.CITY_ID as CITY6_30_, company0_.COUNTY_ID as COUNTY7_30_, company0_.COUNTRY_ID as COUNTRY8_30_, company0_.OTHER_CITY as OTHER9_30_, company0_.OTHER_COUNTY as OTHER10_30_, company0_.OTHER_COUNTRY as OTHER11_30_, company0_.POST_CODE as POST12_30_, company0_.WEB_URL as WEB13_30_, company0_.BASE_MEDIA_DRIVE as BASE14_30_, company0_.SERVICE_PROVIDER as SERVICE15_30_, company0_.APPLICATION_ADMIN as APPLICA16_30_, company0_.SWITCHBOARD as SWITCHB17_30_ from GOLD.COMPANY company0_ order by company0_.COMPANY_NAME
[12:17:18.890] Compiling _jsp/_web_22dinf/_jsp/_companymanager/_addnewcompany__jsp.java
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - Entering Company Manager
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@deeebd ---> age: 9922 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select user0_.USER_ID as USER1_33_, user0_.USER_NAME as USER2_33_, user0_.FIRST_NAME as FIRST3_33_, user0_.LAST_NAME as LAST4_33_, user0_.COMPANY_ID as COMPANY5_33_, user0_.ACCOUNT_LOCKED as ACCOUNT6_33_, user0_.TITLE as TITLE33_, user0_.EMAIL_ADDRESS as EMAIL8_33_, user0_.WORK_PHONE as WORK9_33_, user0_.USER_PASSWORD as USER10_33_, user0_.HINT_QUESTION as HINT11_33_, user0_.HINT_ANSWER as HINT12_33_, user0_.LOGON_ATTEMPTS as LOGON13_33_, user0_.PASSWORD_EXPIRY as PASSWORD14_33_, user0_.LANGUAGE_ID as LANGUAGE15_33_, user0_.JOB_TITLE as JOB16_33_, user0_.IS_ADMINISTRATOR as IS17_33_ from GOLD.USERS user0_ where user0_.COMPANY_ID=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - Entering User Manager
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e ---> age: 19265 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select roleslooku0_.ROLES_LOOKUP_ID as ROLES1_53_, roleslooku0_.ROLE_DESCRIPTION as ROLE2_53_, roleslooku0_.LOCALE_GROUP as LOCALE3_53_, roleslooku0_.ROLE_ID as ROLE4_53_ from GOLD.ROLES_LOOKUP roleslooku0_ where roleslooku0_.LOCALE_GROUP=? order by roleslooku0_.ROLE_DESCRIPTION
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@52f73e ---> age: 19266 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select lookuptype0_.LOOKUP_TYPE_ID as col_0_0_ from GOLD.LOOKUP_TYPE lookuptype0_ where lookuptype0_.LOOKUP_TYPE=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1ac7fbb ---> age: 13890 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select lookupvalu0_.LOOKUP_VALUE_ID as LOOKUP1_38_, lookupvalu0_.LOOKUP_TYPE_ID as LOOKUP2_38_, lookupvalu0_.LOOKUP_VALUE as LOOKUP3_38_, lookupvalu0_.DESCRIPTION as DESCRIPT4_38_, lookupvalu0_.IS_ACTIVE as IS5_38_, lookupvalu0_.VALUE_ORDER as VALUE6_38_, lookupvalu0_.LANGUAGE_ID as LANGUAGE7_38_, lookupvalu0_.OPTION_VALUE as OPTION8_38_ from GOLD.LOOKUP_VALUE lookupvalu0_ where lookupvalu0_.LOOKUP_TYPE_ID=? and lookupvalu0_.LANGUAGE_ID=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@f3cf72 ---> age: 12828 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select supportedl0_.SUPPORTED_LANGUAGES_ID as SUPPORTED1_52_, supportedl0_.SUPPORTED_LANGUAGE as SUPPORTED2_52_, supportedl0_.LOCALE_ID as LOCALE3_52_, supportedl0_.LOCALE_GROUP as LOCALE4_52_ from GOLD.SUPPORTED_LANGUAGES supportedl0_ where supportedl0_.LOCALE_GROUP=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@deeebd ---> age: 7125 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select group0_.GROUP_ID as GROUP1_39_, group0_.GROUP_CODE as GROUP2_39_, group0_.GROUP_NAME as GROUP3_39_, group0_.GROUP_DESCRIPTION as GROUP4_39_, group0_.GROUP_OWNER as GROUP5_39_, group0_.CREATOR as CREATOR39_, group0_.CREATION_DATE as CREATION7_39_, group0_.MODIFIER as MODIFIER39_, group0_.MODIFICATION_DATE as MODIFICA9_39_, group0_.TOTAL_DISPLAY_POINT as TOTAL10_39_, group0_.TOTAL_NO_OF_SCREENS as TOTAL11_39_, group0_.MARKET_ID as MARKET12_39_ from GOLD.GROUPS group0_ order by group0_.GROUP_NAME
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - Entering New User
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e ---> age: 28891 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select user0_.USER_ID as USER1_33_, user0_.USER_NAME as USER2_33_, user0_.FIRST_NAME as FIRST3_33_, user0_.LAST_NAME as LAST4_33_, user0_.COMPANY_ID as COMPANY5_33_, user0_.ACCOUNT_LOCKED as ACCOUNT6_33_, user0_.TITLE as TITLE33_, user0_.EMAIL_ADDRESS as EMAIL8_33_, user0_.WORK_PHONE as WORK9_33_, user0_.USER_PASSWORD as USER10_33_, user0_.HINT_QUESTION as HINT11_33_, user0_.HINT_ANSWER as HINT12_33_, user0_.LOGON_ATTEMPTS as LOGON13_33_, user0_.PASSWORD_EXPIRY as PASSWORD14_33_, user0_.LANGUAGE_ID as LANGUAGE15_33_, user0_.JOB_TITLE as JOB16_33_, user0_.IS_ADMINISTRATOR as IS17_33_ from GOLD.USERS user0_ where user0_.USER_NAME=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@52f73e ---> age: 28875 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select role0_.ROLE_ID as ROLE1_35_0_, role0_.ROLE_NAME as ROLE2_35_0_, role0_.ROLE_DESCRIPTION as ROLE3_35_0_ from GOLD.ROLES role0_ where role0_.ROLE_ID=?
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1ac7fbb ---> age: 28796 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@18a2977]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
Hibernate: select users0_.ROLE_ID as ROLE2_1_, users0_.USER_ID as USER1_1_, user1_.USER_ID as USER1_33_0_, user1_.USER_NAME as USER2_33_0_, user1_.FIRST_NAME as FIRST3_33_0_, user1_.LAST_NAME as LAST4_33_0_, user1_.COMPANY_ID as COMPANY5_33_0_, user1_.ACCOUNT_LOCKED as ACCOUNT6_33_0_, user1_.TITLE as TITLE33_0_, user1_.EMAIL_ADDRESS as EMAIL8_33_0_, user1_.WORK_PHONE as WORK9_33_0_, user1_.USER_PASSWORD as USER10_33_0_, user1_.HINT_QUESTION as HINT11_33_0_, user1_.HINT_ANSWER as HINT12_33_0_, user1_.LOGON_ATTEMPTS as LOGON13_33_0_, user1_.PASSWORD_EXPIRY as PASSWORD14_33_0_, user1_.LANGUAGE_ID as LANGUAGE15_33_0_, user1_.JOB_TITLE as JOB16_33_0_, user1_.IS_ADMINISTRATOR as IS17_33_0_ from GOLD.USERS_ROLES users0_ left outer join GOLD.USERS user1_ on users0_.USER_ID=user1_.USER_ID where users0_.ROLE_ID=?
Hibernate: select GOLD.USERS_S.nextval from dual
ERROR - IllegalArgumentException in class: com.oysterware.akoya.model.domain.User, setter method of property: administrator
ERROR - expected type: java.lang.String, actual value: java.lang.Boolean
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@18a2977 [managed: 5, unused: 4, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@44ac5e)
ERROR - Rolled back transaction - Persistance error: org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of com.oysterware.akoya.model.domain.User.administrator
ERROR - Rolled back transaction - Persistance error: org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of com.oysterware.akoya.model.domain.User.administrator

Please ignore this post. I have found what was causing the problem.

Good to know you found out but maybe you think of sharing the solution too...

Probably it has to do with



in the mapping file. Looks like the type in the database is a boolean by the name of the database column. And here the typs is set to String.