cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Reddi,

Please look at these threads..

cheers,

Prashanth

Former Member
0 Kudos

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...

bhavesh_kantilal
Active Contributor
0 Kudos

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>

Former Member
0 Kudos

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

bhavesh_kantilal
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Bhuvesh,

Here is message in Adapter RWB.

Receiver Adapter v2112 for Party '', Service 'Showcase_BS':

Configured at 2006-07-25 19:18:40 PDT

History:

- 2006-07-25 22:06:41 PDT: Processing started