0 Replies Latest reply on Jul 22, 2002 5:55 PM by Alex Borshik

    Character Sets & Firebird JCA

    Alex Borshik Newbie

      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.