cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC receiver adapter - issue- only first record inserted

Former Member

All,

I am working on a proxy - jdbc scenario.

Tyring to insert into an oracle db.

Only the first record is inserted into the DB. Every thing looks fine.

can any one please help me on this.

reg

Edited by: naveen chitluri on Sep 22, 2008 1:58 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

ravi_raman2
Active Contributor
0 Kudos

Can you give us some more info..

Regards

Ravi Raman

Former Member
0 Kudos

Raman,

Thanks for your response.

Every screen it shows success.

In moni, audit log and in comm channel monitoring ...etc

There is only the first record in the DB.

In moni, I can see 2 record after the mapping.....

Please do let me know if you are looking any more info.

reg

VijayKonam
Active Contributor
0 Kudos

Check if you are generating 2 insert statements in the mapping. If they are two records you must specify them in a repeating structure with varying values..

VJ

Former Member
0 Kudos

Hi Vijay,

After mapping, the target looks like


<MsgType>
	<Statement>
	    <row>
		<access>
		</access>
	    </row>
	    <row>
	    	<access>
	    	</access>
	    </row>
	<Statement>	
</MsgType>

VijayKonam
Active Contributor
0 Kudos

I believe you must be repeating the stmt node rather than the row node..!!

VJ

kkram
Contributor
0 Kudos

Naveen

Can you change your target XML to look something like this


<Statement>
     <TableName action=u201DINSERTu201D>
         <table>theactualtablename</table>
         
         <access>
                <col1>val1</col1>
                <col2>val2</col2>
         </access>

         <access>
                  <col1>val11</col1>
         </access>

     </TableName> 
 </Statement>

Former Member
0 Kudos

Vijay,

I have given a wrong info in my last message, about the target structure....the statement node is actually repeated.

Basis team says there are some other problems with the network yesterday...

thanks for your help.