Receiving Parsing error when using the Generate Relational Models From WSDL
dnkopp May 17, 2013 10:39 AMI am receiving the following error when using the Generate Relational Models From WSDL.
ERROR: TEIID31100 Parsing error: Encountered "DirectDepositServiceView.getDirectDeposit_response.xml_in COLUMNS effectiveDate [*]dateTime[*] PATH '/soapBody/nsgetDirectDepositResponse/return/effectiveDate'" at line 6, column 31.
Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
The following virtual procedure was auto generated
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://directdeposit.webservice.people.hrii.adp.com/' AS ns, 'http://schemas.xmlsoap.org/soap/envelope/' AS soap) , '/soap:Envelope' PASSING DirectDepositServiceView.getDirectDeposit_response.xml_in
COLUMNS
effectiveDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/effectiveDate',
newEffectiveDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/newEffectiveDate',
AccTypeValue string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountType/value',
AcctTypeShortName string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountType/shortName',
AcctTypeDescr string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountType/description',
NewAcctTypeValue string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/newAccountType/value',
NewAcctTypeShortName1 string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/newAccountType/shortName',
NewAcctTypeDescr string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/newAccountType/description',
BankValue string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/bank/value',
BankShortName string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/bank/shortName',
BankDescr string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/bank/description',
accountNumber string PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/accountNumber',
fullDeposit boolean PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/fullDeposit',
depositAmount double PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/depositAmount',
prenoteRequired boolean PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/prenoteRequired',
prenoteDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/prenoteDate',
deleted boolean PATH '/soapBody/nsgetDirectDepositResponse/return/directDepositAccounts/deleted',
deleteEffDateRecord boolean PATH '/soapBody/nsgetDirectDepositResponse/return/deleteEffDateRecord',
endEffectiveDate dateTime PATH '/soapBody/nsgetDirectDepositResponse/return/endEffectiveDate') AS t;
END
I am using Teid Designer 8.1 final with JBOSS 7.1.1 and Teiid 8.3 final server (Windows 7)