Pushing data from axapta customer table to external database using odbc connection both database on oracle

(0) Share

Report

Posted on by Community Member

Hi,

I have an requirnment for pushing real time data from Axapta Customer table to external system which have same database as oracle.

for example: In axapta if i insert an record in customer table same time it should also insert data in external system database using odbc . It is a real time pushing data using db link.

Pls help

current code: wrritten on customer table insert method : getting error cursor state

LoginProperty                      LP;
    OdbcConnection                     myConnection;
    Statement                          myStatement;
    ResultSet                          myResult1;
    ResultSet                          LocalResult;
    Statement                          LocalStatement;
    int RecCount=0;
    str                                 a;
    ;
     super();
      ttsbegin;

     LP = new LoginProperty();
     LP.setDSN("teststaging");
     LP.setUsername("teststaging");
     LP.setPassword("teststaging");


    try
      {
       myConnection = new OdbcConnection(LP);
      }
    catch
    {
    PRINT("Check username/password.");
    return;
     }

    LocalStatement = myConnection.createStatement();

    LocalResult = LocalStatement.executeQuery(strfmt("insert into teststaging.ARtable(AR_CODE) values ('%1')",this.Custcode));
                     ttsbegin;
                     while(LocalResult.next())
                    {

                     a = LocalResult.getString(1);
                     BOX::info(a);
                       RecCount++;

                    }
                    ttscommit;

   info(int2str(RecCount)+" Records are inserted.");

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Martin Dráb 236,394 Most Valuable Professional on at

Like (0)

Report

RE: Pushing data from axapta customer table to external database using odbc connection both database on oracle

It seems that you've copied code for selecting data and you're trying to use for inserts.

Use executeUpdate() instead of executeQuery() and remove your code for processing records returned by a query, because you don't have any query at all.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Pushing data from axapta customer table to external database using odbc connection both database on oracle

thanks resolved

Was this reply helpful? Yes No
Martin Dráb 236,394 Most Valuable Professional on at

Like (0)

Report

RE: Pushing data from axapta customer table to external database using odbc connection both database on oracle

If my reply is the solution, please mark it accordingly (notice Did this answer your question? beside the reply).

Otherwise please explain the solution, so other people can benefit from this thread.

Was this reply helpful? Yes No
bprashant644 20 on at

Like (0)

Report

RE: Pushing data from axapta customer table to external database using odbc connection both database on oracle

Hey Martin,

In such a scenario, where both tables are updated. Do the the users of external DB require CAL??

Since, its an indirect use of AX data, it seems to me that they do require.

I have posted a similar query in my post. Just thought that this thread is more relevant therefore, asking here as well..

Thanks

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Pushing data from axapta customer table to external database using odbc connection both database on oracle

This licensing question has nothing to do with the original question which was about technical solution for syncing data to external database. Please post a new question.

Was this reply helpful? Yes No
bprashant644 20 on at

Like (0)

Report

RE: Pushing data from axapta customer table to external database using odbc connection both database on oracle

Sure Nikolaos.

Thank you.

I have posted the question here - community.dynamics.com/.../1085349

if possible please respond..

Was this reply helpful? Yes No