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 !

 

 

Reply via email to