SYNCHRONOUS SOAP TO JDBCEND TO END WALKTHROUGHWord下载.docx
- 文档编号:19795674
- 上传时间:2023-01-10
- 格式:DOCX
- 页数:32
- 大小:766.34KB
SYNCHRONOUS SOAP TO JDBCEND TO END WALKTHROUGHWord下载.docx
《SYNCHRONOUS SOAP TO JDBCEND TO END WALKTHROUGHWord下载.docx》由会员分享,可在线阅读,更多相关《SYNCHRONOUS SOAP TO JDBCEND TO END WALKTHROUGHWord下载.docx(32页珍藏版)》请在冰豆网上搜索。
TheyneedtoconnecttoanoldSQLServerDatabasethroughaSOAPclient,andcheckifthesalaryinformationofagiven(orseveral)employee(s)hasbeenupdated.([RecordStatus]=“U”)
Ifso,theinterfacehavetoretrievetheupdatedrecordandupdateitsstatustoProcessed([RecordStatus]=“P”)
Assumptions,prerequisitesandknownissues:
∙SQLServer2000istheDBServerusedinthisscenario.
∙Forconveniencewewillcreateourobjectsinthedatabase[Northwind](youcancreateabrandnewDBifyoufeelso).
∙IfyourSQLServer200isinstalledonaWindowsusingXPwithSP2,IsuggesttodisabletheWindowsFirewalland,ifneeded,followtheTroubleshotingguideavailableattheendofthisweblog.
Namingconventions
Toeasilyidentifyalltheobjectsrelatedtothisinterface,wewillusea“y”oracapital“Y”atthebeginningofalltheobjectnames.
SYSTEMLANDSCAPEDIRECTORYSETUP:
1-Goto[SoftwareCatalog]
Createa[NewProduct]withtheFollowingDetails:
Vendor:
YABCvendor
Name:
YABC
Version:
1
Clickon[Create]
Definea[NewSoftwareComponent]withtheFollowingDetails:
UsethepreviouslydefinedProductandVendor
Name(uppercase):
YABC_SW_COMP
2-ReturntotheSLDHomeandgoto[TechnicalLandscape]
Createa[NewTechnicalsystem]withtheFollowingDetails:
TechnicalSystemType:
ThirdParty
->
NEXT
SystemName:
YTSABC
Hostname:
YABCSERVER
Addtheproduct:
YABC,1ofYABCVendor
FINISH
3-ReturntotheSLDHomeandgoto[BusinessLandscape]
Createa[NewBusinessSystem]
YBSABC
Tech.Syst.Type:
ThirdParty
System:
YTSABConyabcserver
LogicalSystemName:
YLSABC
SelectyourpreferredIntegrationServer
WehavefinishingsettinguptheSLDforourSOAPtoJDBCSynchronousInterface.
INTEGRATIONREPOSITORYSETUP:
1.ImporttheSWComponent:
FirstwewillimporttherecentlycreatedSoftwareComponent
Goto[Tools]intheMenuBar
TransferfromSystemLandscapeDirectory->
ImportSoftwareComponentVersions…
Select[YABC_SW_COMP,1ofyabcvendor]
[Import]
[Exit]
Fig.1ImportSCVersions
TheSoftwareComponentYABC_SW_COMPshallbeavailableintheObjectsTablist.
2.CreateTheNamespace
UnderSCYABC_SW_COMPcreatethefollowingnamespace:
3.CreateTheDataTypes
WeneedtocreatefourdifferentDataTypesforthisinterfaceasfollows:
SOAPRequest:
ySoapEmpReq_dt
SOAPResponse:
ySoapEmpRes_dt
JDBCRequest:
yJDBCEmpReq_dt
JDBCResponse:
yJDBCEmpReq_dt_response
PleaseensurethatthenameoftheJDBCResponseDatatypeandMessagetypehavethestring“_response”intheend,thisisobligatorytoproperlyhandletheresultofthestoredprocedureexecution.
e.g.Ifyourjdbcrequestmessageisnamed[xyz],theresponsehavetobenamed[xyz_response].
BeverycarefulwithallthenamesoftheelementswithintheJDBCRequestorResponseDataTypes,byexample,theelementgetEmpDetails,needstobetheexactnameofthestoredprocedurethatwewillexecuteintheDatabase,andtheelementEmpIDistheexactinputvariablenamethatwewillprovidetotheStoredProcedure.
NowyoucanproceedtocreatetheDataTypesasshownintheFigures2,3,4&
5.
Fig2.SOAPRequest:
Fig3.SOAPResponse:
Fig4.JDBCRequest:
Fig5.JDBCResponse:
4.CreateTheMessageTypes
TocontinueweneedtocreateaMessageTypeforeachDataType,thisstepisreallysimple,becausetherelationbetweentheDT’sandMT’sisonetoone.
TheFigure6willgiveaclearideaoftherelationshipbetweentheDTandMTinthisScenario.
Fig.6DatatypesandMessageTypes
Tip:
WhileCreatingtheMessageTypes,youcandraganddropthedesiredDatatypeandNamespacetotheRespectiveTextBoxes;
Startwiththenamespace,andfinishwiththeNameoftheDatatype,thensavetheMessageType.
Fig7.DragandDroptheDTandtheNamespace
5.CreateTheMessageInterfaces
WewillrequireTwoSynchronousMessageInterfaces,oneOutboundSynchronousandoneInboundSynchronous
ConfigureeachMessageInterfaceasisshowninthefires8&
9.
Fig8:
OutboundMessageInterface
Fig9:
InboundMessageInterface
6.CreateTheMessageMappings
Wewillrequiretwomessagemappings,onefortheRequestandanotherfortheResponse.Figure10,10a,10bandFigure11showsthemappingdetails.
Fig.10SOAPRequesttoJDBCRequest
Fig.10a:
Constant[EXECUTE]->
@action
Fig.10b:
Constant[CHAR]->
@type
ClickonthelinkbelowformoreinformationonthedocumentformatfortheReceiverJDBCAdapter
Fig.11JDBCResponsetoSOAPResponse
7.CreateTheInterfaceMapping
ThelaststepthatwewillconfigureintheIntegrationRepositoryistheInterfaceMapping.
WewillonlyrequireoneInterfaceMapping.
SelecttheSourceInterfaceandtheTargetInterfaceasshownintheFigure12
Fig12:
InterfaceMapping
NowClickonThebutton[ReadInterfaces]andselectthecorrespondingmessagemappingsintheRequestandResponseTab.
Thefigure12aand12bshowsthemessagemappingsalreadyselectedineachtab.
Fig.12a.
Fig.12b
WehavefinishingsettinguptheIRforourSOAPtoJDBCSynchronousInterface.
INTEGRATIONDIRECTORYSETUP
Firstofall,inthemenubar,selectEnviroment->
ClearSLDDataCache
ThiswillensurethatourBusinessSystemisavailableforselection.
1.CreateaNewConfigurationScenario
IntheMenuBarSelectObject->
New->
ConfigurationScenario
Nameitas:
YSOAP_TO_JDBC_SYNC
2.AssigntheBussinesSystem
-
OpentheRecentlyCreatedConfig.Scenario
RightClickonBusinessSystem
SelectAssignBussinesSystem
[Continue]
ScrollDownasneededandselecttheYBSABCBusinessSystem.
UnselecttheCreateCommunicationChannelsAutomaticallybox.
Clickon[Finish]
Figure13:
SelectingBusinessSystem
3.CreatethecommunicationChannels
CreatetheSenderSOAPComm.Channelasshowninthefigure14.
Youonlyneedtobecarefulwhentypingthenamespaceandthe[Outbound]InterfaceName.
Fig14:
YSOAP_SENDER
NowcreatetheReceiverJDBCComm.Channelwiththefollowingattributes:
NAME:
YJDBC_RECVR
JDBCDriver:
com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection:
jdbc:
microsoft:
sqlserver:
//127.0.0.1:
3333;
DatabaseName=Northwind;
(TheIP127.0.0.1isjustasample,replaceitwiththeIPofyourSQLSever;
Alsoensurethattheportthatyouareusingiscorrect)
User:
I'
musingthealmightysauser,youmightneedtouseadifferentuserforyourconnection.
Password:
Thecorrectpasswordfortheaboveuser.
Check[AdvancedMode]
NumberofRetries...:
2
TransactionIsolationLevel:
serializable
Activatethecheckbox[DatabaseAuto-Commit...]
Activatethecheckbox[DisconnectfromDatabase...]
TheFigure15istrimmedtoshowonlythemeaningfulconfiguration.
Fig.15:
4.CreatetheReceiverAgreement,SenderAgreement,InterfaceDeterminationandReceiverDetermination.
Thefollowingstepsshouldbeverystraightforward.
Refertothefigures16,17,18&
19ifyouhaveproblemssettinguptheIDcomponents.
Fig.16:
ReceiverAgreement
Fig.17:
SenderAgreement
Fig.18:
InterfaceDetermination
Fig.19ReceiverDetermination
Withthis,wehavefinishedourIntegrationDirectoryConfiguration.
UNITTESTING
1.CREATETHESQLSERVEROBJECTS
WeneedtocreatetheTableEMP_DETAILSandthestoredproceduregetEmpDetails
Tomakethissimple,copyandpastethesourcecode1,avaialbleattheendofthisweblog,andexecuteittocreatealltheobjectsandpopulatethetableinthedatabase.
Followtheproceduredescribedbelow:
OpentheSQLServerEnterpriseManager
Inthemenubarselect[Tools]
Select[QueryAnalyzer]
Copyandpastethesourcecode1,availableattheendofthisweblog.
Press[F5]keyorClickontheRunbutton.
Figure20showstheTablewiththerowsalreadyinserted
Fig.20:
EMP_DETAILSTable
2.CREATETHESOAPCLIENT
ThesimplestwaytotestthisinterfaceiscreatingaclientwithinanHTMLfileandexecuteitwiththeInternetExplorer.
Youdon'
tevenneed
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SYNCHRONOUS SOAP TO JDBC END WALKTHROUGH
链接地址:https://www.bdocx.com/doc/19795674.html