- Pharo-users - lists.pharo.org

Re: [Pharo-users] DBXTypeNotSupoorted with Glorp

by Alain Rastoul

hi Guillermo, you are right, I didn't use rawValues , and that was the problem. The problem is not with Glorp but with opendbx and in fact it is the same as the issue pointed to by Mariano (issue 10) and another (issue 16) I have a simpler test to reproduce than yours (in fact you don't need to use UNION in your test): | settings dbc stmt resultSet coll | settings := DBXConnectionSettings host: SmalltalkImage current imagePath, '/' port: '' database: 'testdb.dat' userName: '' userPassword: ''. dbc := DBXConnection platform: DBXSqlitePlatform new settings: settings. [ dbc connect. dbc open. dbc execute: 'drop table if exists foo'. dbc execute: 'create table foo (id int not null, name varchar(64) null )'. dbc execute: 'insert into foo values(1, null )'. dbc execute: 'insert into foo values(2, ''riptobe'' )'. resultSet := dbc execute: 'SELECT * FROM foo'. coll := OrderedCollection new. "error here for null value in second row" resultSet rows do: [ :r | coll add: r values ]. coll inspect. ] ensure: [ dbc close ]. The problem is that opendbx doesn't return the correct datatype for columns when they have null values, apparently it keeps the description for the column that was readen for the first row (?) And the same problem exists with MSSQL, it is not related to the special sqlite UNKNOW datatype but a problem in opendbx (my test also breaks with mssql) I am writing a test case for that, and I will also have a look at opendbx source code. Cheers Alain "Guillermo Polito" <guillermopolito(a)gmail.com> a Ã©crit dans le message de news: CAOBmb52JNRM+xQBx9kqNm9aMero3avyriXWsytbMqK=JBH8KAg(a)mail.gmail.com... Hi Alain! where did you get GlorpDBX? :) Was it from the DBXTalk repo? On Thu, Aug 11, 2011 at 5:28 PM, Alain Rastoul <alr.dev(a)free.fr> wrote: Hi Mariano I may be wrong, but I don't think that this issue is not related, I have first checked that reading my data with squeakdbx is ok. How did you read the data? Using values or raw values? Can you send us/me the query sent by glorp? Is it a polymorphic or inheritance query? Thanks! Guille After searching a bit I think that the problem is in Glorp in DBXPlatform>>createDataTypesMap "Creates and returns a map that maps Smalltalk classes to SQL datatypes. The 16r means it is hexadecimal." ^Dictionary new ... at: 16rFF put: (DBXTypeNotSupported type: #UNKNOWN); Perhaps a solution would be I think it should be something like at: 16rFF put: (DBXTypeNotSupported type: UndefinedObject); with a fromDbxString method defined in UndefinedObject. fromDbxString: aString ^ convert the string to the true column datatype The problem here is that there should be a conversion from the string to the column datatype and the column datatype is unknown here... I don't know either if it is possible to get it from squeakdbx at this point (while fetching data) ? "Mariano Martinez Peck" <marianopeck(a)gmail.com> a Ã©crit dans le message de news:CAA+-=mWQ8y4zLdQbhDx3-hBPXUF_-S9wtvVOD8ia+=6tC8-ufg-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org... On Thu, Aug 11, 2011 at 10:02 PM, Alain Rastoul <alr.dev(a)free.fr> wrote: Hi I 'm writing a small app with pharo +seaside + glorp + squeakdbx + sqlite and I have a problem reading null values from my database. Hi Alain. Do you know exactly which query is being sent? Do you think it can be related to this: http://code.google.com/p/dbxtalk/issues/detail?id=10 ? It seems that glorp stores a DbxTypeNotSupported in the column description for null values when the first row has a null value (the column datatype is varchar). Any workaround or advice is welcome before I dig into Glorp code TIA Alain -- Mariano http://marianopeck.wordpress.com

Aug. 12, 2011

Best way to stop a process listening to a socket

by SÃ©bastien Bigaret

Hi all, Suppose I have a process started w/ fork executing socket>>waitForAcceptFor: with a long deadline. Now suppose that I want it to to stop waiting, before the deadline expires. To stop it immediately, I've found out that signaling it with Process>>signalException and handling it in the Process' code by a Process>>BlockClosure>>on:do: works as expected. Is this the correct way of doing it? Should I make a specific 'Error' subclass for this? Thanks for any advice. __ SÃ©bastien.

Aug. 12, 2011

Re: [Pharo-users] Recommended logging API?

by SÃ©bastien Bigaret

On Fri, 12 Aug 2011 13:27:36 +0200 StÃ©phane Ducasse <stephane.ducasse(a)inria.fr> wrote: > Hi sebastien > > it depends which level of logging you want to do. For simple internal > logs use Object log else I would use toothpick > > > Stef Thanks --I definitely want to be able to use different logging levels, so I'll have a close look at Toothpick. __ SÃ©bastien.

Aug. 12, 2011

Re: [Pharo-users] Recommended logging API?

by StÃ©phane Ducasse

Hi sebastien it depends which level of logging you want to do. For simple internal logs use Object log else I would use toothpick Stef On Aug 12, 2011, at 12:42 PM, SÃ©bastien Bigaret wrote: > > Hi all, > > Is there a recommended package to use for logging? > I've found out that Object>>log exists and shoult be used instead of > Transcript>>show, and > http://www.mail-archive.com/setools@lists.squeakfoundation.org/msg00108.html > speaks about different packages or "adapters". > Is there a recommended one or a recommended way of doing it in Pharo? > (and/or a document I should read) > Thanks for any advice. > > __ SÃ©bastien.

Aug. 12, 2011

Re: [Pharo-users] Recommended logging API?

by SÃ©bastien Bigaret

On Fri, 12 Aug 2011 12:42:06 +0200 SÃ©bastien Bigaret <sebastien.bigaret(a)telecom-bretagne.eu> wrote: > > Hi all, > > Is there a recommended package to use for logging? > I've found out that Object>>log exists and shoult be used instead of > Transcript>>show, and > http://www.mail-archive.com/setools@lists.squeakfoundation.org/msg00108.html > speaks about different packages or "adapters". > Is there a recommended one or a recommended way of doing it in Pharo? > (and/or a document I should read) > Thanks for any advice. > > __ SÃ©bastien. Oops, sorry, I had missed the dedicated page in the collaborActiv book: http://book.pharo-project.org/book/LanguageAndLibraries/LoggingTools/?_s=DP… I guess it gathers the recommended approaches I was searching for. __ SÃ©bastien.

Aug. 12, 2011

Recommended logging API?

by SÃ©bastien Bigaret

Hi all, Is there a recommended package to use for logging? I've found out that Object>>log exists and shoult be used instead of Transcript>>show, and http://www.mail-archive.com/setools@lists.squeakfoundation.org/msg00108.html speaks about different packages or "adapters". Is there a recommended one or a recommended way of doing it in Pharo? (and/or a document I should read) Thanks for any advice. __ SÃ©bastien.

Aug. 12, 2011

MAConditionError opens a debugger

by Romain Verduci

Hi, I have a problem with my seaside application using MAConditionError. It's suppose to display a message error and in my case it opens a debugger. Code with MAConditionError : MAConditionError description: self description signal: 'Invalid name or password.'. I don't understand why it does this. To simplify the explanations and reproduce the bug, you can: - download my image on: http://demo.ovh.com/fr/466c8bec0e28467ab3d473647833e0e8/ - copy the service/ dir on your root dir (/) - run the image - go to localhost:8080/sh - try to login with a fake name And then the MAConditionError opens a debugger when there is an error in login. Thanks Romain

Aug. 12, 2011

Re: [Pharo-users] display form in window; move it around; close it

by C. Hever

Thanks I'll try that and see how well it works. On Thu, Aug 11, 2011 at 2:41 PM, Alain Rastoul <alr.dev(a)free.fr> wrote: > or: > | w i | > w := SystemWindow new. > i := ImageMorph new image: ThemeIcons confirmIcon. > w addMorph: i Â frame: (0@0 corner: 1@1). "frame is full window content" > w openInWorld. > > to create an ImageMorph with a form: > i := ImageMorph withForm: aForm. Â Â Â "aForm is my form created somwhere > else" > > HTH > > "C. Hever" <py.ohlin(a)gmail.com> a Ã©crit dans le message de > news:CAGfYAYo4NxWetMnbGxbgVLjnRGVBv6Ej_iuXaw9j9sekCB3BwQ@mail.gmail.com... > Monsieur Ducasse! I really appreciate your book collection. One > question remains though: how do I change the picture in the > ImageMorph? Can I give it a Form object? > > Also SystemWindow addMorph: i. raises #doesNotUnderstand > > TIA > > On Thu, Aug 11, 2011 at 3:32 AM, StÃ©phane Ducasse > <stephane.ducasse(a)inria.fr> wrote: >> >> On Aug 11, 2011, at 7:43 AM, C. Hever wrote: >> >>> Hello, all. I plan on visualizing fractals in Pharo sometime soon. >>> However, there is a bit of a snag. I've figured out enough to write >>> pixels to a form and save it as an image. However, that lacks the >>> immediacy of being able to see it right in Pharo. Morphic is very >>> confusing so what I'd like to know is how I can draw an image in a >>> window, have all the normal window stuff like move and resize, maybe >>> update it, then delete it when I'm done. >>> >>> TIA >>> >> >> i := ImageMorph new >> image: ThemeIcons confirmIcon ; >> openInWorld >> >> then SystemWindow >> ... addMorph: i. >> >> >> >> > > > > >

Aug. 12, 2011

Re: [Pharo-users] DBXTypeNotSupoorted with Glorp

by Guillermo Polito

Hi Alain! where did you get GlorpDBX? :) Was it from the DBXTalk repo? On Thu, Aug 11, 2011 at 5:28 PM, Alain Rastoul <alr.dev(a)free.fr> wrote: > ** > Hi Mariano > > I may be wrong, but I don't think that this issue is not related, I have > first checked that reading my data with squeakdbx is ok. > How did you read the data? Using values or raw values? Can you send us/me the query sent by glorp? Is it a polymorphic or inheritance query? Thanks! Guille > > After searching a bit I think that the problem is in Glorp in > > DBXPlatform>>createDataTypesMap > "Creates and returns a map that maps Smalltalk classes to SQL datatypes. > The 16r means it is hexadecimal." > ^Dictionary new > ... > at: 16rFF put: (DBXTypeNotSupported type: #UNKNOWN); > Perhaps a solution would be I think it should be something like > at: 16rFF put: (DBXTypeNotSupported type: UndefinedObject); > with a fromDbxString method defined in UndefinedObject. > fromDbxString: aString > ^ convert the string to the true column datatype > > The problem here is that there should be a conversion from the string to > the column datatype and the column datatype is unknown here... > I don't know either if it is possible to get it from squeakdbx at this > point (while fetching data) ? > > > > "Mariano Martinez Peck" <marianopeck(a)gmail.com> a Ã©crit dans le message de > news:CAA+-=mWQ8y4zLdQbhDx3-hBPXUF_-S9wtvVOD8ia+=6tC8-ufg@mail.gmail.com... > > > On Thu, Aug 11, 2011 at 10:02 PM, Alain Rastoul <alr.dev(a)free.fr> wrote: > >> Hi >> >> I 'm writing a small app with pharo +seaside + glorp + squeakdbx + sqlite >> and I have a problem reading null values from my database. >> > > Hi Alain. Do you know exactly which query is being sent? Do you think it > can be related to this: > http://code.google.com/p/dbxtalk/issues/detail?id=10 ? > > > >> It seems that glorp stores a DbxTypeNotSupported in the column description >> for null values when the first row has a null value (the column datatype is >> varchar). >> Any workaround or advice is welcome before I dig into Glorp code >> TIA >> >> Alain >> >> >> > > > -- > Mariano > http://marianopeck.wordpress.com > >

Aug. 11, 2011

Re: [Pharo-users] DBXTypeNotSupoorted with Glorp

by Alain Rastoul

Hi Mariano I may be wrong, but I don't think that this issue is not related, I have first checked that reading my data with squeakdbx is ok. After searching a bit I think that the problem is in Glorp in DBXPlatform>>createDataTypesMap "Creates and returns a map that maps Smalltalk classes to SQL datatypes. The 16r means it is hexadecimal." ^Dictionary new ... at: 16rFF put: (DBXTypeNotSupported type: #UNKNOWN); Perhaps a solution would be I think it should be something like at: 16rFF put: (DBXTypeNotSupported type: UndefinedObject); with a fromDbxString method defined in UndefinedObject. fromDbxString: aString ^ convert the string to the true column datatype The problem here is that there should be a conversion from the string to the column datatype and the column datatype is unknown here... I don't know either if it is possible to get it from squeakdbx at this point (while fetching data) ? "Mariano Martinez Peck" <marianopeck(a)gmail.com> a Ã©crit dans le message de news:CAA+-=mWQ8y4zLdQbhDx3-hBPXUF_-S9wtvVOD8ia+=6tC8-ufg@mail.gmail.com... On Thu, Aug 11, 2011 at 10:02 PM, Alain Rastoul <alr.dev(a)free.fr> wrote: Hi I 'm writing a small app with pharo +seaside + glorp + squeakdbx + sqlite and I have a problem reading null values from my database. Hi Alain. Do you know exactly which query is being sent? Do you think it can be related to this: http://code.google.com/p/dbxtalk/issues/detail?id=10 ? It seems that glorp stores a DbxTypeNotSupported in the column description for null values when the first row has a null value (the column datatype is varchar). Any workaround or advice is welcome before I dig into Glorp code TIA Alain -- Mariano http://marianopeck.wordpress.com

Aug. 11, 2011