Up to Discussions in Contour Support

This Question is Answered

1 "correct" answer available (4 pts)
4 Replies Last post: Apr 28, 2008 1:45 PM by Louai  
Click to view Louai's profile  
Louai
5 posts since
Jan 2, 2008

Apr 25, 2008 7:56 PM

Db update and contour cache


Hi,

Did anyone have issues with manipulating data in the db from outside Contour? I am writing a sync tools for MS project and whenever I update the db, changes are not reflected in contour until I completly restart the service. Is there a cache mechanism specific to Contour (or to MySQL).

PS: I am running it in local mode if that makes a difference (since I don't want to test against our production db).

Click to view Sean's profile  
Sean
11 posts since
Jun 12, 2007
1. Apr 25, 2008 8:15 PM in response to: Louai
Re: Db update and contour cache

Louai,

You are right about the cache. We are using a Java database mapping component called HIbernate in Contour, which caches domain objects to improve performance. If you manipulate the database directly, you usually need to restart the server to synchronize. The cache mechanism applies to all databases.

Thanks,

Sean Tong
Click to view Louai's profile  
Louai
5 posts since
Jan 2, 2008
2. Apr 25, 2008 8:19 PM in response to: Sean
Re: Db update and contour cache

Thanks for your answer,

Would I need to restart apache or is there any other command to clear the cache?

Click to view Derwyn's profile  
Derwyn
89 posts since
Jun 12, 2007
3. Apr 25, 2008 8:49 PM in response to: Louai
Re: Db update and contour cache
Not at this point. We could evaluate putting a button on the admin that clears the cache (Sean is looking into this). We are also working on building an integration between Contour and MS Project that would utilize our upcoming Web Services. This would get around the cache issue. But before you get too excited about this integration keep in mind that it is being handled via a partnership with the local university to give CS students some real world experience.
Click to view Louai's profile  
Louai
5 posts since
Jan 2, 2008
4. Apr 28, 2008 1:45 PM in response to: Derwyn
Re: Db update and contour cache

OK I see.

I would suggest however to have something that can be triggered externally to update the cache, this should be useful for anyone manipulating the database externally (not sure how much do that though).

Thanks also for the thumbs up about the timeframe of the integration with MS project. I actually now have everything we need for now (it's a simple C# based add-in that I tailored to the structure of our db), it was just that cache issue that got me confused for a while.

Actions

More Like This