Re: Design problem About application related with cached rows

2005-08-14 Thread Pooly
Always reply to the lists, others may have better ideas, others insights... I may have not understand everything in your previous description. Why would you need an extra software on the remote DB ?? All the steps I've describe should work from the client. All you want is a kind of cache for the c

Re: Design problem About application related with cached rows

2005-08-14 Thread Kostas Karadamoglou
I thought this solution but it needs an extra software at the remote database. I would prefer to contact from the cache database directly to the remote database using SQL. But even using those 3 steps there is a problem. The only interface that I have is JDBC/SQL. That means that the only solu

Re: Design problem About application related with cached rows

2005-08-14 Thread Pooly
Hi, Try in in two fold. 1. Get all the ID you have in your remote DB 2. check those localy with the ones you have in cache 3. Get all the info you need after you remove the ID you already have. 2005/8/14, Kostas Karadamoglou <[EMAIL PROTECTED]>: > Hello, > > I try to create an application for my

Design problem About application related with cached rows

2005-08-14 Thread Kostas Karadamoglou
Hello, I try to create an application for my dissertation that caches rows from an romote database. The application handles a cache database which is identical with the original. The only difference is that it does not have autogenerated fields and referential integrity is omitted. I have de