On Thu, Aug 11, 2011 at 5:28 PM, Alain Rastoul <alr.dev@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@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@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