All,
We have changed our database driver. Before it was JTDS and now we are using
MSSql and Oracle. (OJB RC3)
We now have this trouble. When I insert into a table with a nullable foreign
key the SQL order insert a '' value.
Table A
Apk
Bfk (nullable constrainte)
Table B
Bpk
I do :
A.setApk(100);
Lock(A, write);
And the INSERT order is : INSERT INTO A (Apk, Bfk) VALUES ('100','');
It should be :
INSERT INTO A (Apk) VALUES ('100');
I think I have done a mistake somewhere, but I don't manage to find it ?
Thanks a lot for your help !