You ought to believe the Exception; you are obviously passing null to a NOT NULL column.
Joined: May 27, 2008
the problem is that i have tried inserting data into both the tables seperately. The insertion works fine when inserting into each table seperately!!
It doesnt work when inserting into both tables one after the other.
What do i do now???
Please help !!
Joined: Oct 13, 2005
Are you passing the data in the correct format? If there is any checking for formats (with CHECK CONSTRAINTs or similar) that might convert the data to null. You appear to have a severely denormalised table, with columns like e-mail which don't depend directly on the primary key. Don't know whether that affects it.
Have you tried passing that String from the command line?