Cache update issue??

[Former Member]

Hi Everyone,

I am implementing simple File to JDBC scenario. The sender file adpater is working fine, but the receiver JDBC adapter seems to be causing a bit of problems.

I am using MS Access as the data base. Database XI.mdb is in D:/JDBC/XI.mdb

The parameters in JDBC adapter that i have filled are:

Connection String: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//132.186.85.184/D:/JDBC/XI.mdb;

JDBC Adapter: sun.jdbc.odbc.JdbcOdbcDriver

Persistence: local

Conflict Resolution: redo

Interprtation of empty string values: "

These are the only fields filled up in the receiver JDBC adapter.

Now the issue is although I am working in Namespace: http://Ashish_File_To_JDBC

The output in the JDBC receiver communication channel contains the namespace which i was earlier using and not the one it should be:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:JDBC_Vendor xmlns:ns0="<b>http://Ashish_File_to_idoc</b>">

- <Data_DB>

- <XI action="INSERT">

<TABLE>XI</TABLE>

</XI>

- <Access>

<Vendor_Number>320123</Vendor_Number>

<Last_Name>Rodrize</Last_Name>

<Search_term>enjoy</Search_term>

<Currency>USD</Currency>

<Street>Anothony St</Street>

</Access>

</Data_DB>

</ns0:JDBC_Vendor>

Is this some kind of cache refersh issue. I have tried refreshing everything.

Regards,

Ashish

[Former Member · Accepted solution]

Hi,

Check the namespaces given in all the objects that u have used for the scenario.

Like message type, message interface etc.

Some where you might have given wrong namespace. Especially check it in the message tab of the message mapping.

Regards,

P.Venkat

[Former Member · Accepted solution]

Ya i have checked eacha nd every object in IR and ID properly, there is no mistake there for sure.

ALso cause i am expecting a output:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:JDBC_Vendor xmlns:ns0="<b>http://Ashish_File_to_JDBC</b>">

- <Data_DB>

- <XI action="INSERT">

<TABLE><b>HELLO</b></TABLE>

- <Access>

<Vendor_Number>320123</Vendor_Number>

<Last_Name>Rodrize</Last_Name>

<Search_term>enjoy</Search_term>

<Currency>USD</Currency>

<Street>Anothony St</Street>

</Access>

<b></XI></b>

</Data_DB>

</ns0:JDBC_Vendor>

I am getting:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:JDBC_Vendor xmlns:ns0="http://Ashish_File_to_idoc">

- <Data_DB>

- <XI action="INSERT">

<TABLE>XI</TABLE>

</XI>

- <Access>

<Vendor_Number>320123</Vendor_Number>

<Last_Name>Rodrize</Last_Name>

<Search_term>enjoy</Search_term>

<Currency>USD</Currency>

<Street>Anothony St</Street>

</Access>

</Data_DB>

</ns0:JDBC_Vendor>

This was my previous output, but since i have made changes to it, the changes are not being reflected in the communication channel output.

Regards,

Ashish

[Shabarish_Nair · Accepted solution]

SAI_CACHE_REFRESH - try running the report in XI. This sud forcefully do a cache refresh.

<i>Ya i have checked eacha nd every object in IR and ID properly, there is no mistake there for sure.</i>

>>>

crosschecck the Message interfaces used in this case. Do they refer to the MT of the new namespace ???

[Former Member · Accepted solution]

Goto > SXI-Cache and then refersh cache there. Done that

Checked all the interfaces also.

Ashish