This one time, at band camp, tek1 said:

t>the below exception occurred when i tried to perform the query:
t>
t>SELECT p from prj.persistence.entity.person.castor.Person_Castor p WHERE
t>p.dept = $1 AND p.code = $2
t>
t>exception:
t>
t>[junit] org.exolab.castor.jdo.TransactionAbortedException: Nested error:
t>org.exolab.castor.jdo.PersistenceException: Nested error:
t>java.sql.SQLException: ERROR:  ExecReplace: Fail to add null value in not
t>null attribute dept_id
t>
t>notes:
t>
t>      -Person.dept is mapped to "dept_id" in the Person table.
t>      -the values stored in dept_id are not null, but there are other columns in
t>the Person table that are null
t>        and are allowed to be null (i.e. column was *not* defined as NOT NULL).

Based on your description above, it sounds like dept_id is a foreign
key. Is this true?

I know that this doesn't help much, but these types of errors are
usually a result of something being crossed in the mapping descriptor.

Bruce
--

perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'

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

Reply via email to