Re: Strange behaviour @ postgres

Hi,

fieldValues actually contain the Jdbc3Array object with a string value representing an array. The Jdbc standard also say that the array object of a field have to be the java.sql.Array.

The main issue is however, that to perform a getArray() method a connection have to be open. Or the getArray() method was called when a connection was open and in that case the array was cached within the Array implementation. (see commented code)

There is a workaround, where you call the getArray() method after ses.query(query) not closing the connection. But imho its somewhat misleading.

Andre

--- In [email protected], Franck Routier <franck.routier@...> wrote:
>
> Hi,
> 
> this is really weird,  ses.query(query)  , should really retrieve the
> data, then when detached, the SDataSet has nothing to do with the
> driver...
> 
> When debugging, what does SRecordInstance.filedValues contain after you
> detachAndCommit ?
> 
> If it does contain a plain Integer[] object, then it should be ok. But
> maybe the driver is returning some specially crafted object that is not
> truly an Integer[] ?
> 
> Franck
> 




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/