• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Container - java-apache camel

 
Greenhorn
Posts: 3
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey guys, how are you?
This is my first time of this site. I have problem:
I have 2 different systems that are connected using a MIDDLEWARE: I am  connecting MAGENTO with a ERP so i have to map different information ,that's why i am using mapping tables

In my case i have to map information about agents;, that table is inside a MYSQL database and it is called AGENT_MAPPING_TABLE. The problem is that everytime that i delete/insert any of the different rows inside that table i have to stop the container and reset it, otherwise the process will not recognize the new row.

I need to solve this but i do not understand whats going on.

Take a look:


**Apache Camel Route:**



How can i solve this problem? Have you got any idea?
 
Saloon Keeper
Posts: 9742
80
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Showing us the code for insert and delete might prove more fruitful.
 
Elloy Herty
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Carey Brown wrote:Showing us the code for insert and delete might prove more fruitful.



Thank you for replying!
What do you mean? I do something like this:

insert into AGENT_MAPPING_TABLE values ('exampe', 'example')

or

delete AGENT_MAPPING_TABLE
where agent_code = 43 (example)

 
Carey Brown
Saloon Keeper
Posts: 9742
80
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
...and with that, what are you doing with
agentCodeMailMapping
?
 
Carey Brown
Saloon Keeper
Posts: 9742
80
Eclipse IDE Firefox Browser MySQL Database VI Editor Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm not familiar with Apache Camel.
 
Elloy Herty
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Carey Brown wrote:I'm not familiar with Apache Camel.



The problem is that i do not understand why the process does not recognize the new information till the container is shut down and restarted :/
 
Too many men are afraid of being fools - Henry Ford. Foolish tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic