SqueakDBX March 2010

squeakdbx@lists.squeakfoundation.org

5 participants
7 discussions

Re: Connection Pool for Glorp
by Mariano Martinez Peck 30 Mar '10

30 Mar '10

On Sat, Mar 27, 2010 at 1:04 PM, John Toohey <johnptoohey(a)gmail.com> wrote: > Is there a way to see if the DBXConnection is in the middle of a > transaction? If I am releasing a connection, I'd like to rollback if a > transaction is open. > > I answer you in SqueakDBX so that not to make noise in Glorp. No, there is no way right now, but it can be easily added (I think). You can add a boolean variable hasTransactionOpened to DBXConnection, initializated in false. Then, then calling DBXConnection >> startTransaction you set that to true. Then, in messages commit, rollback you put that to false. Then in messsages finalize, close, and maybe some other place, you ask for the value, if it is true, then you rallback and put variable to false Of course we would need to write tests for that. I can give it a try this weekend. What do you think ? Cheers Mariano > > On Sat, Mar 27, 2010 at 10:02, Mariano Martinez Peck < > marianopeck(a)gmail.com> wrote: > >> Wait....let's calm down....too much misunderstands here. >> >> Glorp is maintained and developed in VW. There is a port to squeak from 2 >> years old or more. Then, we took that version and did several refactors to >> Glorp so that it uses an abstract DatabaseDriver. This only affects >> SqueakDatabaseAccessor. We called that GlorpDBX. >> >> Diogenes: don't worry. John is aware of GlorpDBX, what it is, how to >> install, etc. Check SqueakDBX mailing list. He even posted in OpenDBX >> mailing list ;) >> >> Now....regarding the Connection Pool, you have different things: >> >> - The package Alan told you about Seaside package. He was talking about >> the one that is in VW public store. To look at it, you should take a VW, go >> to store and look at it. And if you like it, I don't know how, export it and >> load in pharo. >> - There is a Seaside package in squeaksource, which is not the same, I >> think it has some kind of connection pool but I am not sure. Maybe Keithy >> did it. >> - There is a connection pool that Ramón León did some time ago. Check >> http://onsmalltalk.com/making-a-connection-pool-for-glorp-in-seaside >> - There is a connetion pool Esteban Lorenzano did directly for GlorpDBX >> >> Finally, if you plan to do a connection pool for GlorpDBX you have to >> possibilities: >> - be hardcoded to the SqueakDBX driver and use directly DBXConnection >> objects >> - not be hardcoded to SqueakDBX driver but use DatabaseDriver or >> DatabaseDriver >> connection instead. I am not sure if this is possible. But >> having a connection pool for Glorp, not hardcoding with the connection class >> would be cool. >> >> Cheers >> >> Mariano >> >> >> >> >> On Fri, Mar 26, 2010 at 5:53 PM, John Toohey <johnptoohey(a)gmail.com>wrote: >> >>> Hang on, this is exactly what I load :- >>> >>> Gofer new >>> squeaksource: 'MetacelloRepository'; >>> package: 'ConfigurationOfGlorpDBX'; >>> load. >>> ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') load. >>> >>> I need to get used to calling it GlorpDBX :-) >>> >>> >>> >>> On Fri, Mar 26, 2010 at 16:37, Diogenes Moreira < >>> diogenes.moreira(a)gmail.com> wrote: >>> >>>> Oki, please get the Glorp Package from Squeak DBX Project.. this package >>>> have change to adapt DBAccessor to SqueakDBX classes, an remove hiddens "IF" >>>> in the Squeak Glorp Version.. >>>> >>>> >>>> >>>> Best Regards.. >>>> >>>> >>>> On Fri, Mar 26, 2010 at 5:34 PM, John Toohey <johnptoohey(a)gmail.com>wrote: >>>> >>>>> I'm using SqueakDBX on Pharo RC3. >>>>> >>>>> On Fri, Mar 26, 2010 at 16:32, Diogenes Moreira < >>>>> diogenes.moreira(a)gmail.com> wrote: >>>>> >>>>>> from glorp or squeakdbx project....?? >>>>>> >>>>>> take Care. >>>>>> The SqueakDBX version has a couple of refactorings and modifications >>>>>> to adapt to different platforms. >>>>>> >>>>>> the detail is on the web squeakdbx www.squeakdbx.org >>>>>> >>>>>> >>>>>> >>>>>> an other question..? do you using pharo or squeak ??? >>>>>> >>>>>> Best Regards.. >>>>>> >>>>>> >>>>>> >>>>>> On Fri, Mar 26, 2010 at 5:26 PM, John Toohey <johnptoohey(a)gmail.com>wrote: >>>>>> >>>>>>> I took the one from squeaksource, latest update was Feb 22 2010. >>>>>>> Where do I find the one you are looking at? >>>>>>> >>>>>>> >>>>>>> On Fri, Mar 26, 2010 at 16:20, Alan Knight <knight(a)acm.org> wrote: >>>>>>> >>>>>>>> I think you're looking at a different package than I am. Quite >>>>>>>> possibly it's the original work that Ramon did. I have no GSDescriptorSystem >>>>>>>> or GSPooledDatabaseAccessor. I suspect that might also be for an old version >>>>>>>> of Seaside. >>>>>>>> >>>>>>>> >>>>>>>> At 04:11 PM 2010-03-26, John Toohey wrote: >>>>>>>> >>>>>>>> I mean should my own Database class which is a sub-class of >>>>>>>> DescriptorSystem be changed to sub-class GSDescriptorSystem and then use >>>>>>>> GSPooledDatabaseAccessor instead of SqueakDatabaseAccessor? >>>>>>>> >>>>>>>> I don't see any specific VW code in here, so far anyhow. >>>>>>>> >>>>>>>> I'll write this up and post it here, when I get it working. >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Mar 26, 2010 at 16:03, Alan Knight <knight(a)acm.org> wrote: >>>>>>>> >>>>>>>> I'm not sure what you mean by inheriting from these. Right now, >>>>>>>> this provides a VW-specific pooling accessor. You could make a SqueakDBX >>>>>>>> one, and it probably would be nice to try and abstract some of that stuff to >>>>>>>> reduce any code duplication. And documentation is good too. This is based on >>>>>>>> work that Ramon Leon did, back in 2007, I'm not sure if it was in Squeak or >>>>>>>> not. >>>>>>>> >>>>>>>> >>>>>>>> At 03:29 PM 2010-03-26, John Toohey wrote: >>>>>>>> >>>>>>>> This looks great. Is the correct procedure to have all my class that >>>>>>>> inherit from Glorp, inherit from these instead? I'm using GlorpDBX. I had no >>>>>>>> idea this was available, so we should get it documented on the SqueakDBX >>>>>>>> site. >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Mar 26, 2010 at 14:42, Alan Knight <knight(a)acm.org> wrote: >>>>>>>> >>>>>>>> Take a look at the SeasideGlorp package. >>>>>>>> >>>>>>>> At 02:36 PM 2010-03-26, John Toohey wrote: >>>>>>>> >>>>>>>> I need to write a connection pool for Glorp and am thinking that the >>>>>>>> Database accessor is the place to do this. Is this correct, or has anyone >>>>>>>> any experience with this? >>>>>>>> -- -JT >>>>>>>> >>>>>>>> -- You received this message because you are subscribed to the >>>>>>>> Google Groups "glorp-group" group. To post to this group, send >>>>>>>> email to glorp-group(a)googlegroups.com. To unsubscribe from this >>>>>>>> group, send email to glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com>. >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>>> >>>>>>>> -- Alan Knight [|], Engineering Manager, Cincom Smalltalk >>>>>>>> knight(a)acm.org aknight(a)cincom.com http://www.cincom.com/smalltalk >>>>>>>> -- You received this message because you are subscribed to the >>>>>>>> Google Groups "glorp-group" group. To post to this group, send >>>>>>>> email to glorp-group(a)googlegroups.com. To unsubscribe from this >>>>>>>> group, send email to glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com>. >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> -JT >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "glorp-group" group. >>>>>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>>>>> . >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>>> >>>>>>>> -- >>>>>>>> Alan Knight [|], Engineering Manager, Cincom Smalltalk >>>>>>>> knight(a)acm.org >>>>>>>> aknight(a)cincom.com >>>>>>>> http://www.cincom.com/smalltalk >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "glorp-group" group. >>>>>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>>>>> . >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> -JT >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "glorp-group" group. >>>>>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>>>>> . >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>>> >>>>>>>> -- >>>>>>>> Alan Knight [|], Engineering Manager, Cincom Smalltalk >>>>>>>> knight(a)acm.org >>>>>>>> aknight(a)cincom.com >>>>>>>> http://www.cincom.com/smalltalk >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "glorp-group" group. >>>>>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>>>>> . >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> -JT >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "glorp-group" group. >>>>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>>>> To unsubscribe from this group, send email to >>>>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>>>> . >>>>>>> For more options, visit this group at >>>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>>> >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "glorp-group" group. >>>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>>> To unsubscribe from this group, send email to >>>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>>> . >>>>>> For more options, visit this group at >>>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> -JT >>>>> >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "glorp-group" group. >>>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>>> To unsubscribe from this group, send email to >>>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>>> . >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/glorp-group?hl=en. >>>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "glorp-group" group. >>>> To post to this group, send email to glorp-group(a)googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/glorp-group?hl=en. >>>> >>> >>> >>> >>> -- >>> -JT >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "glorp-group" group. >>> To post to this group, send email to glorp-group(a)googlegroups.com. >>> To unsubscribe from this group, send email to >>> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/glorp-group?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "glorp-group" group. >> To post to this group, send email to glorp-group(a)googlegroups.com. >> To unsubscribe from this group, send email to >> glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/glorp-group?hl=en. >> > > > > -- > -JT > > > -- > You received this message because you are subscribed to the Google Groups > "glorp-group" group. > To post to this group, send email to glorp-group(a)googlegroups.com. > To unsubscribe from this group, send email to > glorp-group+unsubscribe(a)googlegroups.com<glorp-group%2Bunsubscribe(a)googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/glorp-group?hl=en. >

2 9

Connection Pooling
by John Toohey 26 Mar '10

26 Mar '10

Hi, I was wondering if anyone has done something with DB connection pooling for GlorpDBX? I know about, http://onsmalltalk.com/making-a-connection-pool-for-glorp-in-seaside, but would like to know if someone has implemented it in the GlorpDBX layer. -- -JT

3 7

Problem deploying image from OSX to Linux
by John Toohey 26 Mar '10

26 Mar '10

Hi, I just deployed my test image, after testing on OSX, to a Linux production server, but the DBX drivers still think they are on OSX. In #createConnection, OpenDBX current returns the OSX driver. What is the best way to reset this, and can I do it in a running image. -- -JT

3 14

Re: Glorp on SqueakDBX
by Mariano Martinez Peck 26 Mar '10

26 Mar '10

Hi Stephan. The state of SqueakDBX + Glorp -> GlorpDBX is uncertain in the site. That's true because we didn't have time to release a stable version. The truth is that we are quite busy this year :( Nevertheless, GlorpDBX is working correctly with PostgreSQL, Oracle and MySQL. Some tests fails (I think only MySQL has failing tests) but they are just because the database doesn't support a particular feature. So, if you use PostgreSQL, MySQL or Oracle, GlorpDBX should work ok. We even have a production enviroment with GlorpDBX + MySQL :) If you want to give it a try to GlorpDBX, there is a Metacello configuration for it: Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfGlorpDBX'; load. ((Smalltalk at: #ConfigurationOfGlorpDBX) project version: '1.0') load. Remember you need to have OpenDBX and the PostgreSQL libraries installed. It would be great if you can use GlorpDBX for Suixo project because it gives it portability.... I mean, at least you can change the database ;) Cheers Mariano On Wed, Mar 24, 2010 at 11:31 PM, Stephan Eggermont <stephan(a)stack.nl>wrote: > Hello Mariano, > > We have been looking at using SqueakDBX in Suixo. Suixo currently uses the > Glorp/Postgres combi on linux. From the SqueakDBX site the state of glorp > for SqueakDBX is not clear to me. What is the timeframe you're looking at? > Especially with you managing the GSoC application. > > Stephan Eggermont >

2 2

The ESUG SqueakDBX presentation video
by Mariano Martinez Peck 16 Mar '10

16 Mar '10

Hi. James Robertson not only record but also edited and published the video here: http://www.cincomsmalltalk.com/blog/blogView?showComments=true&printTitle=S… I added it also here: http://www.squeakdbx.org/media Cheers Mariano

1 0

Trying to connect to Firebird
by Eduardo Pereira 15 Mar '10

15 Mar '10

Hi Trying to connect to Firebird, I get the "Loading backend library failed" error. I'm using Windows Vista, and I put the following paths in $PATH: C:\Program Files\Firebird\Firebird_2_1\lib C:\Users\Eduardo\Documents\Downloads\Squeak3.10.2-7179 The second folder is where Squeak is, and also all the dlls. These are the contents of the folder: 14/03/2010 20:47 <DIR> . 14/03/2010 20:47 <DIR> .. 14/03/2010 20:20 11.210 crash.dmp 12/03/2010 18:18 <DIR> downloads 14/03/2010 20:16 85.261 libfirebirdbackend-1.dll 14/03/2010 20:16 433.979 libmysqlbackend-1.dll 14/03/2010 20:16 109.471 libodbcbackend-1.dll 14/03/2010 19:56 446.168 libopendbx-1.dll 14/03/2010 19:56 860.590 libopendbxplus-1.dll 14/03/2010 20:16 486.247 liboraclebackend-1.dll 14/03/2010 20:16 451.584 libpgsqlbackend-1.dll 14/03/2010 20:16 69.281 libsqlite3backend-1.dll 14/03/2010 20:16 85.098 libsybasebackend-1.dll 14/03/2010 20:47 0 lista.txt 14/03/2010 19:57 <DIR> opendbx 14/03/2010 20:16 354.002 opendbx-1.4.4_win32.zip 14/03/2010 19:50 <DIR> package-cache 12/03/2010 17:47 <DIR> sm 11/03/2010 21:34 7.529 smalltalk1.st 11/03/2010 21:09 360.056 splash.bmp 11/03/2010 21:09 985.600 Squeak.exe 14/03/2010 20:40 211 Squeak.ini 14/03/2010 20:36 5.478.662 Squeak3.10.2-7179-basic.changes 14/03/2010 20:36 19.745.600 Squeak3.10.2-7179-basic.image 14/03/2010 20:44 3.638 SqueakDebug.log 11/03/2010 21:09 30.720 SqueakFFIPrims.dll 11/03/2010 21:50 <DIR> Squeaklets 11/03/2010 21:09 17.584.742 SqueakV39.sources 14/03/2010 20:11 504 Teste conexao Firebird.text I'm certainly missing something, I just don't know what it is... Thanks Eduardo

2 3

Regarding Metacello configuration
by Eduardo Pereira 15 Mar '10

15 Mar '10

Hi all I tried to install SqueakDBX through Metacello, but before finishing the install, the Squeak VM froze on one of the "Initializing..." windows. I used the last Metacello configuration for SqueakDB, but previous ones had the same problem... Has anyone else experienced this? Any help is greatly appreciated, Thanks in advance Eduardo

2 3

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX March 2010