on 07-26-2006 3:27 AM
Hi
I am having trouble in connecting to external database. I am trying to send message as follows to update table in database.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:StyleMaster_ShowcaseJdbc_MT xmlns:ns0="http://kswl/MasterData/Showcase/Material">
- <STATEMENT>
- <TABLENAME>
<ACTION>INSERT</ACTION>
<TABLE>StyleMaster</TABLE>
- <access>
<Season>1</Season>
<StyleNo>XI_TEST_6</StyleNo>
<Descr>Test duration 4</Descr>
</access>
</TABLENAME>
</STATEMENT>
</ns0:StyleMaster_ShowcaseJdbc_MT>
For this I am getting an error in message
>Exception caught by adapter framework: null
>Delivery of the message to the application using connection AFW failed, due to: RecoverableException
Can some one help me on this?? hanging on this for long time.......
Thanks
Reddi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
U have to user actual Table name along with the action.
In this case, the table name is SAP_POCREATE and Action is INSERT.
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_POCREATE xmlns:ns0="http://sap.com/XI/POcreation">
<Statement>
<SAP_POCREATE action="INSERT">
<access>
<PO>01011</PO>
<ITEM>00001</ITEM>
<PLANT>1000</PLANT>
<SLOC>1000</SLOC>
</access>
</SAP_POCREATE>
</Statement>
</ns0:MT_POCREATE>
From,
Yallabandi...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reddi,
<b>ACTION shoud be an Attribute of the TABLENAME</b> and not a separate element.
<?xml version="1.0" encoding="UTF-8" ?>
<ns0:StyleMaster_ShowcaseJdbc_MT xmlns:ns0="http://kswl/MasterData/Showcase/Material">
<STATEMENT>
<b><TABLENAME ACTION = INSERT></b>
<TABLE>StyleMaster</TABLE>
<access>
<Season>1</Season>
<StyleNo>XI_TEST_6</StyleNo>
<Descr>Test duration 4</Descr>
</access>
</TABLENAME>
</STATEMENT>
</ns0:StyleMaster_ShowcaseJdbc_MT>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhuvanesh,
I changed data type and message getting delivered as follows.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:StyleMaster_ShowcaseJdbc_MT xmlns:ns0="http://kswl/MasterData/Showcase/Material">
- <STATEMENT>
- <TABLENAME ACTION="INSERT">
<TABLE>StyleMaster</TABLE>
- <access>
<Season>1</Season>
<StyleNo>XI_TEST_6</StyleNo>
<Descr>Test duration 4</Descr>
</access>
</TABLENAME>
</STATEMENT>
</ns0:StyleMaster_ShowcaseJdbc_MT>
Still having same problem.. This is the first time I am trying to insert into this external sybase database. Drivers already deployed and parameters also set in communication channel as follows
com.sybase.jdbc3.jdbc.SybDriver
jdbc:Sybase:Tds:kstest1:2638?SERVICENAME=kswiss
I developed small java program and ran in to connect driver jar files , that works well but not using integration engine.
Any suggestions appreciated.
Thanks
Reddi
Hi Reddi,
1.What does the error in the JDBC adapter in the RWB say?
2.Also, can you try by making the whole data type in CAPITALS.
<i><?xml version="1.0" encoding="UTF-8" ?>
- <ns0:StyleMaster_ShowcaseJdbc_MT xmlns:ns0="http://kswl/MasterData/Showcase/Material">
- <STATEMENT>
- <TABLENAME ACTION="INSERT">
<TABLE>STYLEMASTER</b></TABLE>
- <ACCESS>
<SEASON>1</SEASON>
<STYLENO>XI_TEST_6</STYLENO>
<DESCR>Test duration 4</DESCR>
</ACCESS>
</TABLENAME>
</STATEMENT>
</ns0:StyleMaster_ShowcaseJdbc_MT></i>
Regards,
Bhavesh
PS : Its Bhavesh and not Bhuvanesh
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.