Thanks for the answer, Oskar Fail on persist: it doesn't specify the value, or even the property name that fails - I've discovered that the uints are the problematic ones by systematically commenting parts of the mappings. Fail on load - the boxing explanation is worth looking into, but what can be done there? Also, the database value isn't null, I've double checked..
On Nov 30, 8:19 pm, Oskar Berggren <[email protected]> wrote: > fail on persists: what is the value that it claims is outside the > expected range? > > fail on load: one possible explanation for the invalid cast is that > oracle's dbprovider may return a boxed uint, i.e. a UInt32 instance. > With the mapping with Int32 probably something is trying to cast that > boxed uint directly to an int, which is not valid (you would have to > unbox it first). Another explanation may be that you have NULL in the > database, causing the oracle provider to return DbNull.Value. > > /Oskar > > 2009/11/30 Victor Rosenberg <[email protected]>: > > > Thanks for the answer. > > > I think it fails of translating from whatever type oracle's ODP > > returns to the uint property. > > There is a value returned, and its even a small integer one. > > > On Nov 30, 7:58 pm, Fabio Maulo <[email protected]> wrote: > >> for example you have a null and a not nullable property. > > >> 2009/11/30 Fabio Maulo <[email protected]> > > >> > If the query is valid what is invalid is a value. > > >> > 2009/11/30 Victor Rosenberg <[email protected]> > > >> > When using the uint mappings: > >> >> "Value doesn't fall within the expected range" - fails somewhere in > >> >> the oracleParameter.st_dbtype while trying to persist > >> >> When using the int mappings: > >> >> "Couldn't execute query (<valid sql select query here>) > >> >> Inner exception - Specified cast not valid" - fails when loading the > >> >> object from the db > > >> >> On Nov 30, 11:07 am, Oskar Berggren <[email protected]> wrote: > >> >> > Specifying the exceptions might be a good idea. > > >> >> > /Oskar > > >> >> > 2009/11/30 Victor Rosenberg <[email protected]>: > > >> >> > > Hey guys > >> >> > > I am having some problems with mapping uint properties. > >> >> > > I am using oracle, the relevant table column is of INTEGER datatype. > >> >> > > The mapped class has uint property. > >> >> > > When the mapping is like that: > >> >> > > <property name="xxx" column="yyy" type="UInt32"/> - there are > >> >> > > exceptions trying to persist the class. > >> >> > > For <property name="xxx" column="yyy" type="Int32"/> - there are > >> >> > > exceptions trying to load it. > >> >> > > Skipping the type declaration doesnt help either. > >> >> > > Any ideas? > > >> >> > > Thanks in advance > > >> >> > > -- > > >> >> > > You received this message because you are subscribed to the Google > >> >> Groups "nhusers" group. > >> >> > > To post to this group, send email to [email protected]. > >> >> > > To unsubscribe from this group, send email to > >> >> [email protected]<nhusers%[email protected]> > >> >> . > >> >> > > For more options, visit this group athttp:// > >> >> groups.google.com/group/nhusers?hl=en. > > >> >> -- > > >> >> You received this message because you are subscribed to the Google > >> >> Groups > >> >> "nhusers" group. > >> >> To post to this group, send email to [email protected]. > >> >> To unsubscribe from this group, send email to > >> >> [email protected]<nhusers%[email protected]> > >> >> . > >> >> For more options, visit this group at > >> >>http://groups.google.com/group/nhusers?hl=en. > > >> > -- > >> > Fabio Maulo > > >> -- > >> Fabio Maulo > > > -- > > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
