Simon,
Thanks for the response. The VA (US Veterans Administration) uses Caché for their medical record system and I would like to attach squeak to that system.
It really concerns me that you are having this problem with ODBC on Linux. Have you considered their XML interface, or do you think that would be way to slow?
I was hoping to add support by extending their projection classes to generate Smalltalk objects, and to connect up using ODBC. Im glad you mentioned this problem, since Im running on windows, and I wouldnt have discovered this problem until later while trying to run this on linux.
I would love to see squeak drivers, have you contacted them about the specs?
Thanks again for the response and for mentioning GLORP, I hadn't seen it yet.
Ron Teitelbaum Ron@USMedRec.com ________________________________________ From: squeak-dev-bounces@lists.squeakfoundation.org [mailto:squeak-dev-bounces@lists.squeakfoundation.org] On Behalf Of Simon Kirk Sent: Monday, November 28, 2005 5:34 AM To: The general-purpose Squeak developers list Subject: Re: Caché Database System Integration With Squeak
Hi Ron - yes! Funnily enough I've spent the last two months struggling with this very subject :)
How are you planning to integrate with Caché? My first priority was to try to integrate with their ODBC drivers - there's a thread about it on this list here. Eventually I did get success, but as you can see from the thread, it's certainly a non-ideal solution.
Upon communication with their (admittedly pretty helpful) support staff it turns out the timer is internally set up to control a timeout value within their own unix driver software. Of course, the whole issue I found doesn't apply if you're working with windows as their ODBC driver is completely different, the integration works just fine - within the boundaries of FFI, of course.
We're now at the point of trying to decide what to do. The whole point of all this is to add Caché as a supported database for GLORP (and have it work on other OSes than Windows - preferably Linux in our case), but I'd be interested to know how you intend to use it. We're considering whether to try to hit the metal directly and write pure Squeak drivers for Caché, but we're not sure whether they'd give up the specs to us of how we need to communicate with their server. The PostgreSQL drivers for Squeak seem to encapsulate a nice generic framework from which base other pure Squeak database drivers, but whoever developed it never did the required abstraction: I wonder if anybody ever did it, started it, or even considered doing it?
Anyway, it's nice to know we're not the only people trying to break this ground now :)
Cheers, Simon
Ron Teitelbaum wrote: Hello All, Has anyone worked with the Caché Database system: http://www.intersystems.com/ Im. interested in possible integration with squeak. Ron Teitelbaum President / Principal Software Engineer US Medical Record Specialists www.USMedRec.com Ron@USMedRec.com
Click here to report this email as spam.
________________________________________