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