[SqueakDBX] Installing on Windows with MSSql backend was Re: [Esug-list] [ANN] ESUG supports

Mon Apr 11 09:40:12 UTC 2011

On Mon, Apr 11, 2011 at 11:31 AM, <Mikey.Sanchez at gmail.com> wrote:

> 1. If my application gains traction it will need a fairly serious object
> store. It also needs to integrate with 3rd party drelational databases. I
> need to make sure that if I opt for GemStone that I can "take" my relational
> DB connectivity with me.
>

Something maybe stupid...Esteban or Diogenes may help you more than me.
But..
1) Be aware of the difference between Gemstone and the Pharo image that
comes with the tools to connect to Gemtsone. For example, if you want to
migrate a relational database to Gemtsone, you CAN do it with SqueakDBX,
because such work can be done by that Pharo image: it uses SqueakDBX to read
databse, and write it in Gemstone. Several people used SqueakDBX for that
purpose.

2) Ask in the Gemstone mailing list about this. I think they may have ODBC
or something like that.

3) Ask in Gemstne mailing list, how it is their FFI. Because SqueakDBX is
quite decoupled from the FFI implementation. You can just subclass OpenDBX
class and use another FFI calls. I guess the "Smalltalk" part of SqueakDBX
is quite portable.

4) What about integrating with 3rd party relational databases trought
something that not a query directly ? what about webservices or things like
that? you can have another Pharo image that uses SqueakDBX and publish
webservices (or similar) and you consume them from Gemstone

>
> 2. I'll check the GLORP integration docs and the new loader.
>
>
Something like this may help you to get started:

Gofer new
squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfGlorpDBX';
load.

ConfigurationOfGlorpDBX project lastVersion load.

Cheers

Mariano

> Thanks,
>
>
> Miguel
>
>
>
>
> On Apr 10, 2011 11:23pm, Mariano Martinez Peck <marianopeck at gmail.com>
> wrote:
> >
> >
> > On Fri, Apr 8, 2011 at 4:01 PM, Miguel Sanchez mikey.sanchez at gmail.com>
> wrote:
> >
> > Hi,
> >
> >
> >
> > OK after a few weeks hiatus I've managed to get all the SqueakDBX
> >
> > tests to pass (ok two are still failing but they don't look like a big
> >
> > deal. ) Yayyyyyyy! It helped using the right backend. I've all but
> >
> > given up compiling openDBX. If I have time I'll go back to it for
> >
> > completeness. I'll suggest some changes to the windows specific
> >
> > documentation, or make them myself. How do you want to proceed?
> >
> >
> >
> > Let me check with the rest of the team.
> >
> >
> > Soooooo now I have two questions that have occured to me.
> >
> > 1. Is SqueakDBX ported to GemStone? (I'm guessing not)..
> >
> > The problem is FFI. What do you want to do exacly ?  I mean, why (for
> what) you need SqueakDBX in Gemstone ?
> >
> >
> >
> >
> > 2. Is there a MsSQLPlatform on GLORP or does the SQLServerPlatform
> >
> > integration work. (GLORP documentation makes reference to *rumours* of
> >
> > SQLServer integration working.) Basically what is the state of the
> >
> > GLORP/SqueakDBX rearchitecture work looking in order to use SueakDBX
> >
> > backend?
> >
> >
> >
> > Maybe you can take a look to:
> >
> > http://www.squeakdbx.org/GLORP%20integration
> >
> > However, the installation scripts are out-dated. We now use
> ConfigurationOfGlorpDBX, not those loaders.
> >
> >
> >
> >
> > Best Regards,
> >
> >
> >
> >
> >
> > Miguel
> >
> >
> >
> >
> > On 23 March 2011 23:41, Mariano Martinez Peck marianopeck at gmail.com>
> wrote:
> >
> > >
> >
> > >
> >
> > > On Wed, Mar 23, 2011 at 11:39 PM, Miguel Sanchez
> mikey.sanchez at gmail.com>
> >
> > > wrote:
> >
> > >>
> >
> > >> So it's a feature and not a bug.... ;-)
> >
> > >>
> >
> > >
> >
> > > heheheheh
> >
> > >
> >
> > >>
> >
> > >> I've got some stuff on compiling freeTDS and if I ever manage to
> >
> > >> compile openDBX I'll put together a howto.
> >
> > >>
> >
> > >
> >
> > > Ok. We can then integrate them where they should go:
> >
> > > http://www.squeakdbx.org/Compiling%20for%20different%20backends
> >
> > >
> >
> > >>
> >
> > >> On 23 March 2011 23:34, Mariano Martinez Peck marianopeck at gmail.com>
> >
> > >> wrote:
> >
> > >> > ehehehhehe  Pharo > 1.1  is broken with this...this is a known bug
> >
> > >> > (check
> >
> > >> > Pharo issue tracker)
> >
> > >> > But don't worry, just evaluate: DBXPlatform
> >
> > >> > disableAutomaticConnectionReleaseOnGC  and that's all. It is safe,
> don't
> >
> > >> > worry.
> >
> > >> >
> >
> > >> > BTW...if you have something to improve our documentation in the
> website,
> >
> > >> > please let us know.
> >
> > >> >
> >
> > >> > Cheers
> >
> > >> >
> >
> > >> > Mariano
> >
> > >> >
> >
> > >> > On Wed, Mar 23, 2011 at 11:29 PM, Miguel Sanchez
> >
> > >> > mikey.sanchez at gmail.com>
> >
> > >> > wrote:
> >
> > >> >>
> >
> > >> >> OK so after struggling to build openDBX (that one is ongoing), on
> your
> >
> > >> >> instruction I switched to using DBXOdbcPlatform and .........
> SUCCESS!
> >
> > >> >>
> >
> > >> >> Well ok partial success. I managed to open the connection and while
> >
> > >> >> investigating the resultset of a select I started getting an error.
> In
> >
> > >> >> DBXConnection>>connect
> >
> > >> >> On the line
> >
> > >> >>        self platform class isAutomaticConnectionReleaseOnGC ifTrue:
> [
> >
> > >> >>                SqueakDBXSmalltalkDialect current
> >
> > >> >> addObjectToGarbageCollect: self].
> >
> > >> >> /*during addObjectToGarbageCollect:*/
> >
> > >> >> I get the error: "Error: There is no free space in this set."
> >
> > >> >>
> >
> > >> >> Do I need to force a garbage collect?
> >
> > >> >>
> >
> > >> >> Best Regards,
> >
> > >> >>
> >
> > >> >>
> >
> > >> >> Miguel
> >
> > >> >>
> >
> > >> >>
> >
> > >> >> On 15 March 2011 18:22, Miguel Sanchez mikey.sanchez at gmail.com>
> wrote:
> >
> > >> >> > OK so I've had no luck getting to the bottom of the problem so
> far. I
> >
> > >> >> > still get thrown into  "DBXRecovereableError: RECOVERABLE
> OpenDBX:
> >
> > >> >> > Connecting to server failed" when calling DBXConnection>>open.
> >
> > >> >> >
> >
> > >> >> > I can connect with the Windows command-line tsql equivalent
> >
> > >> >> > (sqlcmd.exe) so the DB  user and permissions are correct.
> >
> > >> >> >
> >
> > >> >> >
> >
> > >> >> > I said I was going to try and build from sources instead of the
> >
> > >> >> > precompiled binaries.
> >
> > >> >>        self platform class isAutomaticConnectionReleaseOnGC ifTrue:
> [
> >
> > >> >>                SqueakDBXSmalltalkDialect current
> >
> > >> >> addObjectToGarbageCollect: self].>
> >
> > >> >> I've downloaded and installed (finally) MinGW. I've (finally!)
> >
> > >> >> > downloaded sources of opendbx 1.4.5 and freetds-0.8.2.
> >
> > >> >> >
> >
> > >> >> > freetds built fine and put the headers in an accessible place.
> but
> >
> > >> >> > now
> >
> > >> >> > when I try to configure opendbx I get the following:
> >
> > >> >> >
> >
> > >> >> > checking for style of include used by make... GNU
> >
> > >> >> > checking for gcc... gcc
> >
> > >> >> > checking whether the C compiler works... no
> >
> > >> >> > configure: error: in `/opendbx-1.4.5':
> >
> > >> >> > configure: error: C compiler cannot create executables
> >
> > >> >> > See `config.log' for more details.
> >
> > >> >> >
> >
> > >> >> > config.log says the following:
> >
> > >> >> >
> >
> > >> >> > ===============================================
> >
> > >> >> >
> >
> > >> >> > configure:3972: gcc -qversion >&5
> >
> > >> >> > gcc.exe: unrecognized option '-qversion'
> >
> > >> >> > gcc.exe: no input files
> >
> > >> >> > configure:3983: $? = 1
> >
> > >> >> > configure:4003: checking whether the C compiler works
> >
> > >> >> > configure:4025: gcc  /local/include  conftest.c  >&5
> >
> > >> >> >
> c:/mingw/bin/../lib/gcc/mingw32/4.5.2/../../../../mingw32/bin/ld.exe:
> >
> > >> >> > cannot fin
> >
> > >> >> > d C:/MinGW/msys/1.0/local/include: Permission denied^M
> >
> > >> >> > collect2: ld returned 1 exit status^M
> >
> > >> >> > configure:4029: $? = 1
> >
> > >> >> > configure:4067: result: no
> >
> > >> >> > configure: failed program was:
> >
> > >> >> > | /* confdefs.h */
> >
> > >> >> >
> >
> > >> >> > ======================================
> >
> > >> >> >
> >
> > >> >> > The directory C:/MinGW/msys/1.0/local/include exists and is
> writable
> >
> > >> >> > by
> >
> > >> >> > me.
> >
> > >> >> >
> >
> > >> >> > Right now it feels like I'm trying to solve the problem of
> building
> >
> > >> >> > opendbx without knowing if it's getting me any closer to getting
> >
> > >> >> > squeakDBX working.
> >
> > >> >> >
> >
> > >> >> > Any help would be appreciated.
> >
> > >> >> >
> >
> > >> >> > Miguel
> >
> > >> >> >
> >
> > >> >
> >
> > >> >
> >
> > >
> >
> > >
> >
> >
> >
> >
> >
> >
> > --
> > Mariano
> > http://marianopeck.wordpress.com
> >
> >
> >

-- 
Mariano
http://marianopeck.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110411/377fcc82/attachment.htm