Character Sets & Firebird JCA
Hi all,
Can anyone please explain to me why the following exception is being thrown when I try to retreive an entity bean that is being persisted in Firebird.
The field which is causing this problem is a custom class. I am using the standard InterBase type mapping in my jbosscmp-jdbc.xml file. (Java objects stored in VARCHAR(2000) column)
The character set I chose when creating the database was NONE. I have scoured the DTD's and forums trying to find information about how to specify the character set required in my firebird-service.xml file but have not been able to locate anything.
I can create an entity bean fine, the problem occurs when I then try to load the entity.
21:29:38,063 DEBUG [LogInterceptor] InvokeHome: findNotAssigned()
21:29:38,063 DEBUG [FBManagedConnection] XAResource requested from FBManagedConnection
21:29:38,063 DEBUG [FBManagedConnection] start called: XidImpl [FormatId=257, GlobalId=cheech//7, BranchQual=1]
21:29:38,063 DEBUG [GDS_Impl] op_transaction
21:29:38,063 DEBUG [XdrOutputStream] writeSet: type: 3
21:29:38,063 DEBUG [XdrOutputStream] writeSet: value: 9
21:29:38,103 DEBUG [XdrOutputStream] writeSet: value: 6
21:29:38,103 DEBUG [XdrOutputStream] writeSet: padding 0 : 1
21:29:38,103 DEBUG [GDS_Impl] sent
21:29:38,103 DEBUG [GDS_Impl] op_response
21:29:38,103 DEBUG [GDS_Impl] op_response resp_object: 1
21:29:38,103 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,103 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,113 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,113 DEBUG [GDS_Impl] received
21:29:38,113 DEBUG [findNotAssigned] Executing SQL: SELECT ID FROM CASES WHERE WORKGROUP_ID IS NULL
21:29:38,113 DEBUG [GDS_Impl] op_allocate_statement
21:29:38,123 DEBUG [GDS_Impl] sent
21:29:38,123 DEBUG [GDS_Impl] op_response
21:29:38,123 DEBUG [GDS_Impl] op_response resp_object: 2
21:29:38,123 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,123 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,193 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,193 DEBUG [GDS_Impl] received
21:29:38,193 DEBUG [FBManagedConnection] preparing sql: SELECT ID FROM CASES WHERE WORKGROUP_ID IS NULL
21:29:38,213 DEBUG [GDS_Impl] op_prepare_statement
21:29:38,213 DEBUG [GDS_Impl] sent
21:29:38,213 DEBUG [GDS_Impl] op_response
21:29:38,223 DEBUG [GDS_Impl] op_response resp_object: 0
21:29:38,223 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,223 DEBUG [XdrInputStream] Available: 1036 trying to read to: 1024 at: 0
21:29:38,223 DEBUG [GDS_Impl] op_response resp_data size: 1024
21:29:38,223 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,223 DEBUG [GDS_Impl] received
21:29:38,223 DEBUG [GDS_Impl] parseSqlInfo started
21:29:38,223 DEBUG [GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
21:29:38,223 DEBUG [GDS_Impl] xsqlda.sqln read as 1
21:29:38,223 DEBUG [GDS_Impl] new xsqlvar 0
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_type 448
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_field ID
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,223 DEBUG [GDS_Impl] isc_info_sql_alias ID
21:29:38,223 DEBUG [GDS_Impl] parseSqlInfo ended
21:29:38,223 DEBUG [GDS_Impl] op_info_sql
21:29:38,223 DEBUG [GDS_Impl] sent
21:29:38,223 DEBUG [GDS_Impl] op_response
21:29:38,223 DEBUG [GDS_Impl] op_response resp_object: 2
21:29:38,223 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,223 DEBUG [XdrInputStream] Available: 1036 trying to read to: 1024 at: 0
21:29:38,223 DEBUG [GDS_Impl] op_response resp_data size: 1024
21:29:38,223 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,223 DEBUG [GDS_Impl] received
21:29:38,223 DEBUG [GDS_Impl] parseSqlInfo started
21:29:38,283 DEBUG [GDS_Impl] parseSqlInfo: first 2 bytes are 1797 or: 5, 7
21:29:38,283 DEBUG [GDS_Impl] xsqlda.sqln read as 0
21:29:38,283 DEBUG [GDS_Impl] parseSqlInfo ended
21:29:38,283 DEBUG [GDS_Impl] op_execute
21:29:38,283 DEBUG [GDS_Impl] sent
21:29:38,283 DEBUG [GDS_Impl] op_response
21:29:38,283 DEBUG [GDS_Impl] op_response resp_object: 1
21:29:38,283 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,283 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,283 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,283 DEBUG [GDS_Impl] received
21:29:38,283 DEBUG [FBResultSet] FBResultSet next - FBStatementFetcher
21:29:38,283 DEBUG [GDS_Impl] op_fetch
21:29:38,283 DEBUG [GDS_Impl] sent
21:29:38,293 DEBUG [XdrInputStream] Available: 24 trying to read to: 5 at: 0
21:29:38,293 DEBUG [GDS_Impl] all rows successfully fetched
21:29:38,293 DEBUG [FBResultSet] FBResultSet next - FBStatementFetcher
21:29:38,293 DEBUG [GDS_Impl] op_free_statement
21:29:38,293 DEBUG [GDS_Impl] sent
21:29:38,293 DEBUG [GDS_Impl] op_response
21:29:38,293 DEBUG [GDS_Impl] op_response resp_object: -1
21:29:38,293 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,293 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,293 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,293 DEBUG [GDS_Impl] received
21:29:38,293 DEBUG [FBManagedConnection] XAResource requested from FBManagedConnection
21:29:38,293 DEBUG [FBManagedConnection] End called: XidImpl [FormatId=257, GlobalId=cheech//7, BranchQual=1]21:29:38,303 DEBUG [LogInterceptor] Invoke: [B3211] getId()
21:29:38,303 DEBUG [FBManagedConnection] XAResource requested from FBManagedConnection
21:29:38,303 DEBUG [FBManagedConnection] start called: XidImpl [FormatId=257, GlobalId=cheech//7, BranchQual=1]
21:29:38,303 DEBUG [Case] Executing SQL: SELECT TITLE, FIRST_NAME, LAST_NAME, DAY_PHONE, EVE_PHONE, ADDRESSDATA, TIME_STAMP, REFERRER, DATA_PROTECT, EMAIL, BUDGET_AMOUNT, REPLACEMENT_POLICY, ADDITIONAL_PROPERTIES, WORKGROUP_ID FROM CASES WHERE (ID=?)
21:29:38,303 DEBUG [GDS_Impl] op_allocate_statement
21:29:38,303 DEBUG [GDS_Impl] sent
21:29:38,303 DEBUG [GDS_Impl] op_response
21:29:38,303 DEBUG [GDS_Impl] op_response resp_object: 2
21:29:38,303 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,303 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,303 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,303 DEBUG [GDS_Impl] received
21:29:38,303 DEBUG [FBManagedConnection] preparing sql: SELECT TITLE, FIRST_NAME, LAST_NAME, DAY_PHONE, EVE_PHONE, ADDRESSDATA, TIME_STAMP, REFERRER, DATA_PROTECT, EMAIL, BUDGET_AMOUNT, REPLACEMENT_POLICY, ADDITIONAL_PROPERTIES, WORKGROUP_ID FROM CASES WHERE (ID=?)
21:29:38,303 DEBUG [GDS_Impl] op_prepare_statement
21:29:38,303 DEBUG [GDS_Impl] sent
21:29:38,303 DEBUG [GDS_Impl] op_response
21:29:38,303 DEBUG [GDS_Impl] op_response resp_object: 0
21:29:38,303 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,303 DEBUG [XdrInputStream] Available: 1036 trying to read to: 1024 at: 0
21:29:38,303 DEBUG [GDS_Impl] op_response resp_data size: 1024
21:29:38,303 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,313 DEBUG [GDS_Impl] received
21:29:38,313 DEBUG [GDS_Impl] parseSqlInfo started
21:29:38,313 DEBUG [GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
21:29:38,313 DEBUG [GDS_Impl] xsqlda.sqln read as 14
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field TITLE
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias TITLE
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 1
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field FIRST_NAME
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias FIRST_NAME
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 2
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field LAST_NAME
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias LAST_NAME
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 3
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field DAY_PHONE
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias DAY_PHONE
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 4
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field EVE_PHONE
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias EVE_PHONE
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 5
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 2000
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field ADDRESSDATA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias ADDRESSDATA
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 6
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 511
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 8
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field TIME_STAMP
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias TIME_STAMP
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 7
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field REFERRER
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias REFERRER
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 8
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 496
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 4
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field DATA_PROTECT
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias DATA_PROTECT
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 9
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field EMAIL
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias EMAIL
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 10
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 482
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 4
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field BUDGET_AMOUNT
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias BUDGET_AMOUNT
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 11
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 500
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 2
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field REPLACEMENT_POLICY
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_alias REPLACEMENT_POLICY
21:29:38,313 DEBUG [GDS_Impl] new xsqlvar 12
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_length 2000
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_field ADDITIONAL_PROPERTIES
21:29:38,313 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,313 DEBUG [GDS_Impl] isc_info_truncated
21:29:38,313 DEBUG [GDS_Impl] op_info_sql
21:29:38,313 DEBUG [GDS_Impl] sent
21:29:38,313 DEBUG [GDS_Impl] op_response
21:29:38,323 DEBUG [GDS_Impl] op_response resp_object: 2
21:29:38,323 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,323 DEBUG [XdrInputStream] Available: 1036 trying to read to: 1024 at: 0
21:29:38,323 DEBUG [GDS_Impl] op_response resp_data size: 1024
21:29:38,323 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,323 DEBUG [GDS_Impl] received
21:29:38,323 DEBUG [GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
21:29:38,323 DEBUG [GDS_Impl] xsqlda.sqln read as 14
21:29:38,323 DEBUG [GDS_Impl] new xsqlvar 10
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_type 482
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_length 4
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_field BUDGET_AMOUNT
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_alias BUDGET_AMOUNT
21:29:38,323 DEBUG [GDS_Impl] new xsqlvar 11
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_type 500
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_length 2
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_field REPLACEMENT_POLICY
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_alias REPLACEMENT_POLICY
21:29:38,323 DEBUG [GDS_Impl] new xsqlvar 12
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_length 2000
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_field ADDITIONAL_PROPERTIES
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_alias ADDITIONAL_PROPERTIES
21:29:38,323 DEBUG [GDS_Impl] new xsqlvar 13
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_type 449
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_length 32
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_field WORKGROUP_ID
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_relation CASES
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_owner SYSDBA
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_alias WORKGROUP_ID
21:29:38,323 DEBUG [GDS_Impl] parseSqlInfo ended
21:29:38,323 DEBUG [GDS_Impl] op_info_sql
21:29:38,323 DEBUG [GDS_Impl] sent
21:29:38,323 DEBUG [GDS_Impl] op_response
21:29:38,323 DEBUG [GDS_Impl] op_response resp_object: 2
21:29:38,323 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,323 DEBUG [XdrInputStream] Available: 1036 trying to read to: 1024 at: 0
21:29:38,323 DEBUG [GDS_Impl] op_response resp_data size: 1024
21:29:38,323 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,323 DEBUG [GDS_Impl] received
21:29:38,323 DEBUG [GDS_Impl] parseSqlInfo started
21:29:38,323 DEBUG [GDS_Impl] parseSqlInfo: first 2 bytes are 1797 or: 5, 7
21:29:38,323 DEBUG [GDS_Impl] xsqlda.sqln read as 1
21:29:38,323 DEBUG [GDS_Impl] new xsqlvar 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_type 448
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_sub_type 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_scale 0
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_length 248
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_field
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_relation
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_owner
21:29:38,323 DEBUG [GDS_Impl] isc_info_sql_alias
21:29:38,323 DEBUG [GDS_Impl] parseSqlInfo ended
21:29:38,323 DEBUG [GDS_Impl] op_execute
21:29:38,323 DEBUG [GDS_Impl] sent
21:29:38,323 DEBUG [GDS_Impl] op_response
21:29:38,323 DEBUG [GDS_Impl] op_response resp_object: 1
21:29:38,323 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,323 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,323 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,323 DEBUG [GDS_Impl] received
21:29:38,323 DEBUG [FBResultSet] FBResultSet next - FBStatementFetcher
21:29:38,323 DEBUG [GDS_Impl] op_fetch
21:29:38,323 DEBUG [GDS_Impl] sent
21:29:38,323 DEBUG [GDS_Impl] op_response
21:29:38,323 DEBUG [GDS_Impl] op_response resp_object: 0
21:29:38,323 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,323 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,323 DEBUG [GDS_Impl] readStatusVector int: 335544321
21:29:38,323 DEBUG [GDS_Impl] readStatusVector int: 335544565
21:29:38,323 DEBUG [GDS_Impl] op_free_statement
21:29:38,323 DEBUG [GDS_Impl] sent
21:29:38,323 DEBUG [GDS_Impl] op_response
21:29:38,373 DEBUG [GDS_Impl] op_response resp_object: -1
21:29:38,373 DEBUG [GDS_Impl] op_response resp_blob_id: 0
21:29:38,373 DEBUG [GDS_Impl] op_response resp_data size: 0
21:29:38,373 DEBUG [GDS_Impl] readStatusVector int: 0
21:29:38,373 DEBUG [GDS_Impl] received
21:29:38,373 DEBUG [FBManagedConnection] XAResource requested from FBManagedConnection
21:29:38,373 DEBUG [FBManagedConnection] End called: XidImpl [FormatId=257, GlobalId=cheech//7, BranchQual=1]21:29:38,443 ERROR [LogInterceptor] TransactionRolledbackException, causedBy:
java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException: arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
at org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.next(FBResultSet.java:2535)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:157)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:122)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:62)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:495)
at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:410)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:353)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:310)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:193)
at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:107)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:69)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:96)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:61)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:129)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:166)
at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:493)
at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invoke(BaseLocalContainerInvoker.java:296)
at org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:38)
at $Proxy82.getId(Unknown Source)
at com.osiron.lab.model.facade.CaseProcessorBean.findUnassignedCases(CaseProcessorBean.java:72)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:664)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:96)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:61)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:129)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:166)
at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
at org.jboss.ejb.Container.invoke(Container.java:705)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:362)
at java.lang.reflect.Method.invoke(Native Method)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
at sun.rmi.transport.Transport$1.run(Transport.java:152)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:148)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:706)
at java.lang.Thread.run(Thread.java:484)
I have tried to resolve this problem by using a BLOB column in my database & changing the type-mapping for java.lang.Object in jbosscmp-jdbc.xml to store the attribute, but when I tried this approach I was getting an SQLException ("Unable to load a ResultSet column into a variable of type com.osiron.lab.model.dataviews.AddressData") thrown by the getResult method of the JDBCUtil class.
========================================================
System configuration:
JBoss 3.0.0
Firebird 1.0
Firebird JCA-JDBC connector 1.0
(All using default configuration, apart from deployment of firebird connector in JBoss)
========================================================
Q1) Is there any way to specify what character set the JCA connector should use? If not will I need to recreate my database using a specfic character set?
Q2) What is the reason for storing cmp fields of type java.lang.Object in a VARCHAR(2000) and not in a BLOB column?
Many thanks in advance.