John,

Thanks for the pointers. BTW, I have looked at GLORP. It is
very sophisticated in many ways and is definitely an impressive
piece of work. In particular, it goes to great lengths to
obviate the impedance mismatch between the relational
world and the world of pure objects. It most definitely
does excellent job at that. But again, I find the approach
taken by ROE of making relations and their algebra into
first class objects to be intriguing. I just haven't
had much time to play around with ROE as much as I would
like because I don't have any Postgress databases laying
around that I can easily experiment on.

Ron
----------=-=-=-=-=-=-=-=-========oOo========-=-=-=-=-=-=-=-=----------
mailto:Ronald.P.Welch at baesystems.com                Phone:(607)770-3701
BAE SYSTEMS Controls            600 Main St Johnson City, NY 13790-1888
----------=-=-=-=-=-=-=-=-===================-=-=-=-=-=-=-=-=----------


-----Original Message-----
From: John M McIntosh [mailto:johnmci at smalltalkconsulting.com] 
Sent: Monday, November 29, 2004 4:26 PM
To: The general-purpose Squeak developers list; avi at beta4.com
Subject: Re: Connecting to Oracle (was: ODBC connection)


If you dig around you'll find the Oracle Call Interface is documented  
by Oracle
in one of their publications. This is what VW uses at the lowest level.

It's straight C code
binding to atomic values or arrays. This could easily be done in FFI.

mmm let's see
http://www.csee.umbc.edu/help/oracle8/server.815/a67846/toc.htm

The interfacing to Oracle is the easy part.

have you looked at Glorp for the OO to relational mapping?

On Nov 29, 2004, at 1:08 PM, Avi Bryant wrote:

> On Mon, 29 Nov 2004 15:40:33 -0500, Welch, Ronald P (US SSA)
>
>
> <ronald.p.welch at baesystems.com> wrote:
>>
>> Avi,
>>
>> I assume pulling the Oracle support over to Squeak from
>> the VW port would still leave us with the synchronous
>> connection problem right? That is unless the "proper
>> Oracle support" was also ported over from as well VW
>> correct (or written from scratch, of course)? I am assuming
>> VW does not have the synchronous connection problem.
>> Is that a valid assumption?
>
> Correct on all counts.  I don't think porting the Oracle driver from
> VW is an option, though, for licensing reasons and because I imagine
> their FFI/plugin API is quite different.  So it would have to be from
> scratch.
>
> The OCI protocol isn't published anywhere, is it?  It would be great
> to have a pure-Squeak client like the JDBC "thin" Oracle driver, but
> it would probably involve some heavy reverse engineering...
>
> Avi
>
>
>
--
========================================================================

===
John M. McIntosh <johnmci at smalltalkconsulting.com> 1-800-477-2659
Corporate Smalltalk Consulting Ltd.  http://www.smalltalkconsulting.com
========================================================================

===