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" <[email protected]> a écrit dans le message de 
news:CAA+-=mWQ8y4zLdQbhDx3-hBPXUF_-S9wtvVOD8ia+=6tc8-...@mail.gmail.com...



  On Thu, Aug 11, 2011 at 10:02 PM, Alain Rastoul <[email protected]> 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

Reply via email to