| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBM8 - Oracle 11g incorrect characters in logical tree |
« View previous topic :: View next topic » |
| Author |
Message
|
| khalednabil |
 Posted: Thu Nov 01, 2012 3:20 pm Post subject: WBM8 - Oracle 11g incorrect characters in logical tree |
 |
|
Newbie
Joined: 07 Oct 2012
Posts: 6
|
I am developing a project in WMB8 and Oracle DB 11g, I am running into issue that values being read into the logical tree is different from values stored in the DB
Here is my NLS Session and Database parameters
SQL> select * from NLS_SESSION_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
17 rows selected.
SQL> select * from NLS_DATABASE_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.2.0.1.0
20 rows selected.
ESQL code:
| Code: |
SET LOOKUP_TABLE.MEALCODE[] = SELECT SML.MEALCODE FROM Database.PCATDB.schema.TBL_SPECIAL_MEAL_LOOKUP AS SML;
|
Values in DB for Meal code stored as 'VGML' while it's being read as unreadable character after each character represented as "square" to be "V<square>G<square>M<square>L<square>"
I am not sure if that's encoding/char set issue or not, but this is the best I can think of, Please help |
|
| Back to top |
|
 |
| mqsiuser |
| Posted: Thu Nov 01, 2012 9:36 pm Post subject: Re: WBM8 - Oracle 11g incorrect characters in logical tree |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
| khalednabil wrote: |
Values in DB for Meal code stored as 'VGML' while it's being read as unreadable character after each character represented as "square" to be "V<square>G<square>M<square>L<square>"
I am not sure if that's encoding/char set issue or not |
"V<square>G<square>M<square>L<square>" that looks like as if your flow receives the data in UTF-16, but reads/interprets it as UTF-8.
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Thu Nov 01, 2012 11:41 pm Post subject: Re: WBM8 - Oracle 11g incorrect characters in logical tree |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| khalednabil wrote: |
| Code: |
SET LOOKUP_TABLE.MEALCODE[] = SELECT SML.MEALCODE FROM Database.PCATDB.schema.TBL_SPECIAL_MEAL_LOOKUP AS SML;
|
|
What is the Oracle datatype for the column MEALCODE? The broker does not support DBCS-only columns (NCHAR, NVARCHAR, NVARCHAR2, NCLOB). |
|
| Back to top |
|
|
| khalednabil |
| Posted: Fri Nov 02, 2012 8:38 am Post subject: |
|
|
Newbie
Joined: 07 Oct 2012
Posts: 6
|
I got it solved now.
It was all about wrong configuration of the ODBC Datasource, it was defined as Oracle driver while it should be Websphere Oracle Wire driver
Thanks all for your response, glad it was finally solved  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
