ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle 10g configuration for MB v 6.0

Post new topic  Reply to topic
 Oracle 10g configuration for MB v 6.0 « View previous topic :: View next topic » 
Author Message
sebastia
PostPosted: Wed Jul 05, 2006 1:31 am    Post subject: Oracle 10g configuration for MB v 6.0 Reply with quote

Grand Master

Joined: 07 Oct 2004
Posts: 1003
We need to use Oracle 10g as database for Message Broker v 6.0

Can someone provide a pointer or a URL
where to find the specificication of the Oracle settings ?

I mean, Oracle people ask me about the TABLESPACE to use ...
And the profile of the "db_user" ....

And the defaults seem not to work :

a) we send the command

mqsicreatebroker BROKER_NAME
-i broker_user -a broker_pwd
-q QM_NAME -n DB_NAME
-u db_user -p db_pwd

b) and see

1) in command line output :

++++++++++++++++++++++++++++++++++++++++++
BIP2322E: Database error:
SQL State ''HYC00'';
Native Error Code '0';
Error Text ''[Oracle][ODBC]Optional feature not implemented.''.
++++++++++++++++++++++++++++++++++++++++++

2) and in ODBC trace file, SQL.LOG :

++++++++++++++++++++++++++++++++++++++
.
mqsicreatebroke d84-85c ENTER SQLAllocEnv
HENV * 00C718A4

mqsicreatebroke d84-85c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x00C718A4 ( 0x00b11540)

mqsicreatebroke d84-85c ENTER SQLSetEnvAttr
SQLHENV 00B11540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003
SQLINTEGER 0

mqsicreatebroke d84-85c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 00B11540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER 0

mqsicreatebroke d84-85c ENTER SQLAllocConnect
HENV 00B11540
HDBC * 003F33B8

mqsicreatebroke d84-85c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00B11540
HDBC * 0x003F33B8 ( 0x00b115e8)

mqsicreatebroke d84-85c ENTER SQLSetConnectOption
HDBC 00B115E8
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

mqsicreatebroke d84-85c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

mqsicreatebroke d84-85c ENTER SQLSetConnectOption
HDBC 00B115E8
SQLINTEGER 2535 <unknown>
SQLPOINTER [Unknown attribute 2535]

mqsicreatebroke d84-85c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
SQLINTEGER 2535 <unknown>
SQLPOINTER [Unknown attribute 2535]

mqsicreatebroke d84-85c ENTER SQLConnectW
HDBC 00B115E8
WCHAR * 0x00B11740 [ -3] "BLBRKD00\ 0"
SWORD -3
WCHAR * 0x4BF78088 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x4BF78088 [ -3] "******\ 0"
SWORD -3

mqsicreatebroke d84-85c EXIT SQLConnectW with return code 1 (SQL_SUCCESS_WITH_INFO)
HDBC 00B115E8
WCHAR * 0x00B11740 [ -3] "BLBRKD00\ 0"
SWORD -3
WCHAR * 0x4BF78088 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x4BF78088 [ -3] "******\ 0"
SWORD -3

DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

mqsicreatebroke d84-85c ENTER SQLSetConnectOption
HDBC 00B115E8
SQLINTEGER 1041 <unknown>
SQLPOINTER [Unknown attribute 1041]

mqsicreatebroke d84-85c EXIT SQLSetConnectOption with return code -1 (SQL_ERROR)
HDBC 00B115E8
SQLINTEGER 1041 <unknown>
SQLPOINTER [Unknown attribute 1041]

DIAG [HYC00] [Oracle][ODBC]Optional feature not implemented. (0)

mqsicreatebroke d84-85c ENTER SQLSetConnectOption
HDBC 00B115E8
SQLINTEGER 1042 <unknown>
SQLPOINTER [Unknown attribute 1042]

mqsicreatebroke d84-85c EXIT SQLSetConnectOption with return code -1 (SQL_ERROR)
HDBC 00B115E8
SQLINTEGER 1042 <unknown>
SQLPOINTER [Unknown attribute 1042]

DIAG [HYC00] [Oracle][ODBC]Optional feature not implemented. (0)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x00B11E30
SWORD 128
SWORD * 0x0012F6BC

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x00B11E30 [ 12] "Oracle"
SWORD 128
SWORD * 0x0012F6BC (12)

mqsicreatebroke d84-85c ENTER SQLSetConnectAttr
SQLHDBC 00B115E8
SQLINTEGER 1061 <unknown>
SQLPOINTER [Unknown attribute 1061]
SQLINTEGER 0

mqsicreatebroke d84-85c EXIT SQLSetConnectAttr with return code -1 (SQL_ERROR)
SQLHDBC 00B115E8
SQLINTEGER 1061 <unknown>
SQLPOINTER [Unknown attribute 1061]
SQLINTEGER 0

DIAG [HYC00] [Oracle][ODBC]Optional feature not implemented. (0)

mqsicreatebroke d84-85c ENTER SQLAllocStmt
HDBC 00B115E8
HSTMT * 01463B74

mqsicreatebroke d84-85c EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
HSTMT * 0x01463B74 ( 0x00b11ec8)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0012F94C
SWORD 2
SWORD * 0x0012F88A

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0012F94C (0)
SWORD 2
SWORD * 0x0012F88A (2)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0012F94E
SWORD 2
SWORD * 0x0012F88A

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0012F94E (30)
SWORD 2
SWORD * 0x0012F88A (2)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0012F950
SWORD 2
SWORD * 0x0012F88A

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0012F950 (30)
SWORD 2
SWORD * 0x0012F88A (2)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 105 <SQL_MAX_STATEMENT_LEN>
PTR 0x0012F954
SWORD 4
SWORD * 0x0012F88A

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 105 <SQL_MAX_STATEMENT_LEN>
PTR 0x0012F954 (0)
SWORD 4
SWORD * 0x0012F88A (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0012F958
SWORD 2
SWORD * 0x0012F88A

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0012F958 (30)
SWORD 2
SWORD * 0x0012F88A (2)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x00B11E30
SWORD 128
SWORD * 0x0012F428

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x00B11E30 [ 12] "Oracle"
SWORD 128
SWORD * 0x0012F428 (12)

mqsicreatebroke d84-85c ENTER SQLAllocStmt
HDBC 00B115E8
HSTMT * 0012F3B4

mqsicreatebroke d84-85c EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
HSTMT * 0x0012F3B4 ( 0x00b12300)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 9 <SQL_DATE>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 9 <SQL_DATE>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLCloseCursor
SQLHSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 10 <SQL_TIME>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 10 <SQL_TIME>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLCloseCursor
SQLHSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 11 <SQL_TIMESTAMP>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 11 <SQL_TIMESTAMP>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLCloseCursor
SQLHSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 105 <SQL_INTERVAL_MINUTE>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 105 <SQL_INTERVAL_MINUTE>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLCloseCursor
SQLHSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 3 <SQL_DECIMAL>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 3 <SQL_DECIMAL>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLCloseCursor
SQLHSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLCloseCursor with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x0012F498
SQLLEN 1024
SQLLEN * 0x0012F42C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x0012F498
SQLLEN 1024
SQLLEN * 0x0012F42C (4128768)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 1 <SQL_CHAR>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 1 <SQL_CHAR>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 8 <SQL_DOUBLE>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 8 <SQL_DOUBLE>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F968
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F968
SQLLEN 0
SQLLEN * 0x0012F39C (13672896)

mqsicreatebroke d84-85c ENTER SQLSetStmtAttr
SQLHSTMT 00B12300
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000001
SQLINTEGER 0

mqsicreatebroke d84-85c EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000001 (BADMEM)
SQLINTEGER 0

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 12 <SQL_VARCHAR>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 12 <SQL_VARCHAR>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F984
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F984
SQLLEN 0
SQLLEN * 0x0012F39C (4)

mqsicreatebroke d84-85c ENTER SQLSetStmtAttr
SQLHSTMT 00B12300
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000001
SQLINTEGER 0

mqsicreatebroke d84-85c EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 00B12300
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000001 (BADMEM)
SQLINTEGER 0

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD -3 <SQL_VARBINARY>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD -3 <SQL_VARBINARY>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F970
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F970
SQLLEN 0
SQLLEN * 0x0012F39C (4)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD -1 <SQL_LONGVARCHAR>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD -1 <SQL_LONGVARCHAR>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F98C
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F98C
SQLLEN 0
SQLLEN * 0x0012F39C (4)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD -4 <SQL_LONGVARBINARY>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD -4 <SQL_LONGVARBINARY>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F978
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F978
SQLLEN 0
SQLLEN * 0x0012F39C (4)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD -99 <unknown>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code -1 (SQL_ERROR)
HSTMT 00B12300
SWORD -99 <unknown>

DIAG [HY004] [Oracle][ODBC]Invalid SQL data type <-99>. (0)

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F994
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F994
SQLLEN 0
SQLLEN * 0x0012F39C (4)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD -98 <unknown>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code -1 (SQL_ERROR)
HSTMT 00B12300
SWORD -98 <unknown>

DIAG [HY004] [Oracle][ODBC]Invalid SQL data type <-98>. (0)

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLBindCol
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F9A4
SQLLEN 0
SQLLEN * 0x0012F39C

mqsicreatebroke d84-85c EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 3
SWORD -16 <SQL_C_SLONG>
PTR 0x0012F9A4
SQLLEN 0
SQLLEN * 0x0012F39C (4)

mqsicreatebroke d84-85c ENTER SQLGetTypeInfo
HSTMT 00B12300
SWORD 11 <SQL_TIMESTAMP>

mqsicreatebroke d84-85c EXIT SQLGetTypeInfo with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
SWORD 11 <SQL_TIMESTAMP>

mqsicreatebroke d84-85c ENTER SQLFetch
HSTMT 00B12300

mqsicreatebroke d84-85c EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 00B12300

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 0 <SQL_CLOSE>

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 2 <SQL_UNBIND>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 2 <SQL_UNBIND>

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B12300
UWORD 1 <SQL_DROP>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B12300
UWORD 1 <SQL_DROP>

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 49 <SQL_NUMERIC_FUNCTIONS>
PTR 0012F9A8
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 49 <SQL_NUMERIC_FUNCTIONS>
PTR 0012F9A8
SWORD 4
SWORD * 0x0012F872 (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 50 <SQL_STRING_FUNCTIONS>
PTR 0012F9AC
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 50 <SQL_STRING_FUNCTIONS>
PTR 0012F9AC
SWORD 4
SWORD * 0x0012F872 (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 52 <SQL_TIMEDATE_FUNCTIONS>
PTR 0012F9B0
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 52 <SQL_TIMEDATE_FUNCTIONS>
PTR 0012F9B0
SWORD 4
SWORD * 0x0012F872 (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 165 <SQL_SQL92_VALUE_EXPRESSIONS>
PTR 0012F9B4
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 165 <SQL_SQL92_VALUE_EXPRESSIONS>
PTR 0012F9B4
SWORD 4
SWORD * 0x0012F872 (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 118 <SQL_SQL_CONFORMANCE>
PTR 0x0012F9B8
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 118 <SQL_SQL_CONFORMANCE>
PTR 0x0012F9B8 (1)
SWORD 4
SWORD * 0x0012F872 (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 48 <SQL_CONVERT_FUNCTIONS>
PTR 0012F9BC
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 00B115E8
UWORD 48 <SQL_CONVERT_FUNCTIONS>
PTR 0012F9BC
SWORD 4
SWORD * 0x0012F872 (4)

mqsicreatebroke d84-85c ENTER SQLGetInfoW
HDBC 00B115E8
UWORD 169 <unknown>
PTR [Unknown attribute 169]
SWORD 4
SWORD * 0x0012F872

mqsicreatebroke d84-85c EXIT SQLGetInfoW with return code -1 (SQL_ERROR)
HDBC 00B115E8
UWORD 169 <unknown>
PTR [Unknown attribute 169]
SWORD 4
SWORD * 0x0012F872

DIAG [HYC00] [Oracle][ODBC]Optional feature not implemented. (0)

mqsicreatebroke d84-85c ENTER SQLErrorW
HENV 00000000
HDBC 00B115E8
HSTMT 00000000
WCHAR * 0x0012F698 (NYI)
SDWORD * 0x0012F838
WCHAR * 0x0012F298
SWORD 512
SWORD * 0x0012F814

mqsicreatebroke d84-85c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00B115E8
HSTMT 00000000
WCHAR * 0x0012F698 (NYI)
SDWORD * 0x0012F838 (0)
WCHAR * 0x0012F298 [ 47] "[Oracle][ODBC]Optional feature not implemented."
SWORD 512
SWORD * 0x0012F814 (47)

mqsicreatebroke d84-85c ENTER SQLErrorW
HENV 00000000
HDBC 00B115E8
HSTMT 00000000
WCHAR * 0x0012F698 (NYI)
SDWORD * 0x0012F838
WCHAR * 0x0012F298
SWORD 512
SWORD * 0x0012F814

mqsicreatebroke d84-85c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 00000000
HDBC 00B115E8
HSTMT 00000000
WCHAR * 0x0012F698 (NYI)
SDWORD * 0x0012F838
WCHAR * 0x0012F298
SWORD 512
SWORD * 0x0012F814

mqsicreatebroke d84-85c ENTER SQLFreeStmt
HSTMT 00B11EC8
UWORD 1 <SQL_DROP>

mqsicreatebroke d84-85c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 00B11EC8
UWORD 1 <SQL_DROP>

mqsicreatebroke d84-85c ENTER SQLDisconnect
HDBC 00B115E8

mqsicreatebroke d84-85c EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 00B115E8

mqsicreatebroke d84-85c ENTER SQLFreeConnect
HDBC 00B115E8

mqsicreatebroke d84-85c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 00B115E8

mqsicreatebroke d84-85c ENTER SQLFreeEnv
HENV 00B11540

mqsicreatebroke d84-85c EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 00B11540
.
++++++++++++++++++++++++++++++++++++++
Back to top
View user's profile Send private message Visit poster's website
mgk
PostPosted: Wed Jul 05, 2006 2:34 am    Post subject: Reply with quote

Padawan

Joined: 31 Jul 2003
Posts: 1642
Hi,

You are using the wrong ODBC driver. Use the DataDirect ODBC driver supplied with message broker. The Oracle supplied one you are using will not work with message broker.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.
Back to top
View user's profile Send private message
sebastia
PostPosted: Wed Jul 05, 2006 3:51 am    Post subject: Reply with quote

Grand Master

Joined: 07 Oct 2004
Posts: 1003
Thanks, mr MGK !!! It is OK now !!!

Here's the result :

++++++++++++++++++++++++++++
WebSphere MQ queue manager running.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
BIP8071I: Successful command completion.


========================================
Back to top
View user's profile Send private message Visit poster's website
sebastia
PostPosted: Wed Jul 05, 2006 6:15 am    Post subject: Reply with quote

Grand Master

Joined: 07 Oct 2004
Posts: 1003
mr MGK - just one question more ....

)

I have found a document (after LOTS of time !!!)
describing the Oracle configuration process ..

It can be found here :

>>> http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.eb.doc/ah14442_.htm

Unfortunatelly, the actual MB manuals do NOT have a "reference number" and I would like to have it in PDF format ...

Can you tell me a page where I can download it ?

I normally use
>>> http://www-306.ibm.com/software/integration/wbimessagebroker/library/

but can't find "this" book without a reference ...

Thankx ! Sebastian.
Back to top
View user's profile Send private message Visit poster's website
sebastia
PostPosted: Thu Jul 06, 2006 12:03 pm    Post subject: Reply with quote

Grand Master

Joined: 07 Oct 2004
Posts: 1003
Well, I found it
and want to share it
just in case it can help someone in the future :

It is "WebSphere Message Broker version 6 release 0"
"Configuration, Administration and Security".

Oracle is on page 94, and the magic phrase to search is
"Configuring an ODBC data source on Windows"

Cheers !!!
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle 10g configuration for MB v 6.0
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.