[castor-dev] how to bind NULL to oql query

[lars.gersmann]

hi,

suppose the following:

i want to query the first tree node (->which has no parent) object with
property parent set to null:

        ...
        oql = db.getOQLQuery( "SELECT t FROM Tree t WHERE parent=$1");
        oql.bind( null);
        ...

the code above results in an error with message:
        java.lang.NullPointerException
                at 
org.exolab.castor.jdo.engine.OQLQueryImpl.bind(OQLQueryImpl.java:159)
                at ex.test(ex.java:48)
                at ex.<init>(ex.java:26)
                at ex.main(ex.java:190)

which may be the right behaviour. the expected data record is:
        insert into rxs_castor_tree ( id, parent) values( '0', null)

so the final question is:
        "how do i test a property against null" or what other possibilities do i
have to solve my problem ?

can somebody help me ?

thanks,

lars

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev