MB 如何配置 Oracle

[shijinbiao]

刚开始学webSphere ,想使用MB操作oracle数据库，依照教程配置了一下，还是不行，网上的教程好多都是抄的，恳请牛点指点一下

====  Exception caught in input node XML_CANCELRESERVATION_IN ==== 



Environment is:





Exception List is:

( ['MQROOT' : 0xbc8420]
  (0x01000000:Name):RecoverableException = (
    (0x03000000:NameValue):File                 = 'F:\build\S700_P\src\DataFlowEngine\ImbComputeNode.cpp' (CHARACTER)
    (0x03000000:NameValue):Line                 = 489 (INTEGER)
    (0x03000000:NameValue):Function             = 'ImbComputeNode::evaluate' (CHARACTER)
    (0x03000000:NameValue):Type                 = 'ComIbmComputeNode' (CHARACTER)
    (0x03000000:NameValue):Name                 = 'test_Msgflow#FCMComposite_1_5' (CHARACTER)
    (0x03000000:NameValue):Label                = 'test_Msgflow.Compute' (CHARACTER)
    (0x03000000:NameValue):Catalog              = 'BIPmsgs' (CHARACTER)
    (0x03000000:NameValue):Severity             = 3 (INTEGER)
    (0x03000000:NameValue):Number               = 2230 (INTEGER)
    (0x03000000:NameValue):Text                 = 'Caught exception and rethrowing' (CHARACTER)
    (0x01000000:Name     ):RecoverableException = (
      (0x03000000:NameValue):File              = 'F:\build\S700_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp' (CHARACTER)
      (0x03000000:NameValue):Line              = 625 (INTEGER)
      (0x03000000:NameValue):Function          = 'SqlStatementGroup::execute' (CHARACTER)
      (0x03000000:NameValue):Type              = 'ComIbmComputeNode' (CHARACTER)
      (0x03000000:NameValue):Name              = 'test_Msgflow#FCMComposite_1_5' (CHARACTER)
      (0x03000000:NameValue):Label             = 'test_Msgflow.Compute' (CHARACTER)
      (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
      (0x03000000:NameValue):Severity          = 3 (INTEGER)
      (0x03000000:NameValue):Number            = 2488 (INTEGER)
      (0x03000000:NameValue):Text              = 'Error detected, rethrowing' (CHARACTER)
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '.Insert_Auth.Main' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = '7.3' (CHARACTER)
      )
      (0x01000000:Name     ):Insert            = (
        (0x03000000:NameValue):Type = 5 (INTEGER)
        (0x03000000:NameValue):Text = 'INSERT INTO Database.ERM_CONSTRAINT ( UserName, PWD )  VALUES ('name', 'password' ) ' (CHARACTER)
      )
      (0x01000000:Name     ):DatabaseException = (
        (0x03000000:NameValue):File              = 'F:\build\S700_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
        (0x03000000:NameValue):Line              = 341 (INTEGER)
        (0x03000000:NameValue):Function          = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
        (0x03000000:NameValue):Type              = '' (CHARACTER)
        (0x03000000:NameValue):Name              = '' (CHARACTER)
        (0x03000000:NameValue):Label             = '' (CHARACTER)
        (0x03000000:NameValue):Catalog           = 'BIPmsgs' (CHARACTER)
        (0x03000000:NameValue):Severity          = 3 (INTEGER)
        (0x03000000:NameValue):Number            = 2321 (INTEGER)
        (0x03000000:NameValue):Text              = 'Root SQL exception' (CHARACTER)
        (0x01000000:Name     ):Insert            = (
          (0x03000000:NameValue):Type = 2 (INTEGER)
          (0x03000000:NameValue):Text = '-1' (CHARACTER)
        )
        (0x01000000:Name     ):Insert            = (
          (0x03000000:NameValue):Type = 14 (INTEGER)
          (0x03000000:NameValue):Text = 'odbc32.dll' (CHARACTER)
        )
        (0x01000000:Name     ):DatabaseException = (
          (0x03000000:NameValue):File     = 'F:\build\S700_P\src\DataFlowEngine\ImbOdbc.cpp' (CHARACTER)
          (0x03000000:NameValue):Line     = 480 (INTEGER)
          (0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
          (0x03000000:NameValue):Type     = '' (CHARACTER)
          (0x03000000:NameValue):Name     = '' (CHARACTER)
          (0x03000000:NameValue):Label    = '' (CHARACTER)
          (0x03000000:NameValue):Catalog  = 'BIPmsgs' (CHARACTER)
          (0x03000000:NameValue):Severity = 3 (INTEGER)
          (0x03000000:NameValue):Number   = 2322 (INTEGER)
          (0x03000000:NameValue):Text     = 'Child SQL exception' (CHARACTER)
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 5 (INTEGER)
            (0x03000000:NameValue):Text = 'IM001' (CHARACTER)
          )
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 2 (INTEGER)
            (0x03000000:NameValue):Text = '0' (CHARACTER)
          )
          (0x01000000:Name     ):Insert   = (
            (0x03000000:NameValue):Type = 5 (INTEGER)
            (0x03000000:NameValue):Text = '[Microsoft][ODBC 驱动程序管理器] 驱动程序不支持此功能' (CHARACTER)
          )
        )
      )
    )
  )
)

这是输出的错误信息。


请各位大虾如何才能正确配置

[yu-yang88]

这么复杂，我这里配置一下，然后直接就 SQL语句就可以了啊