Hello again,
I got this working - although I went a completely different way. Since
we had the DB access completely encapsulated anyway, we are handling
those issues outside of CAR now.
But one thing is still unclear: I figured that CAR (or NHibernate)
obviously does not allow to pass NULL strings into queries (built with
a SimpleQuery and passing Parameters via SetParameter or SetString).
No matter if I pass in a empty string or a NULL string, it always gets
converted to an empty string ('') in the resulting SQL query. The
problem is that Oracle requires to have NULLs in the query, otherwise
records with a NULL string won't be selected. And on the other hand I
can't save empty strings in Oracle because they automatically get
converted to NULL.
So how do you query Oracle for an empty string column?
To be more precise: How do I get a SQL query like "SELECT ... where
Name=null" from an HQL query?
Thanks in advance!
G.
--
You received this message because you are subscribed to the Google Groups
"Castle Project Users" 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/castle-project-users?hl=en.
