1:n relationship bug with SQL Server 2000

[andresangelani]

I'm using JBoss 3.0.4. I created a 1:n relationship Client-has-Branches (Sucursales in Spanish).

When I try to create a client's branch (sucursal), I get the following error:

-- Calling javax.ejb.CreateException: Could not create entity:java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]Column name 'id_cliente' appears more than once in the result column list.

I traced Jboss statements to SQL Server 2000 and yes, Jboss is duplicating the column, please see this!

exec sp_executesql N'INSERT INTO SucursalCliente (id_sucursal_cliente, descripcion, id_cliente, pje_recargo, pje_bonificacion, id_condicion_iva, cuit, calle, nro, id_provincia_estado, id_pais, cod_postal, localidad, telefonos, contacto, piso, depto, id_cliente) VALUES (@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14, @P15, @P16, @P17, @P18)', N'@P1 int ,@P2 varchar(8000) ,@P3 int ,@P4 varchar(8000) ,@P5 varchar(8000) ,@P6 int ,@P7 varchar(8000) ,@P8 varchar(8000) ,@P9 int ,@P10 int ,@P11 int ,@P12 varchar(8000) ,@P13 varchar(8000) ,@P14 varchar(8000) ,@P15 varchar(8000) ,@P16 varchar(8000) ,@P17 varchar(8000) ,@P18 int ', 3, 'testCrearSucursal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL

The section in jbosscmp-jdbc.xml is:

<ejb-relation>
<ejb-relation-name>cliente-has-Sucursales</ejb-relation-name>
<foreign-key-mapping />
<ejb-relationship-role>
<ejb-relationship-role-name>ClienteRelationshipRole</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>idCliente</field-name>
<column-name>id_cliente</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>SucursalClienteRelationshipRole</ejb-relationship-role-name>
<key-fields />
</ejb-relationship-role>
</ejb-relation>

The section in ejb-jar.xml is:

<ejb-relation>
<ejb-relation-name>cliente-has-Sucursales</ejb-relation-name>
<ejb-relationship-role>
cliente
<ejb-relationship-role-name>ClienteRelationshipRole</ejb-relationship-role-name>
One
<relationship-role-source>
cliente
<ejb-name>Cliente</ejb-name>
</relationship-role-source>
<cmr-field>
sucursalCliente
<cmr-field-name>sucursalesCliente</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role>
sucursalCliente
<ejb-relationship-role-name>SucursalClienteRelationshipRole</ejb-relationship-role-name>
Many
<relationship-role-source>
sucursalCliente
<ejb-name>SucursalCliente</ejb-name>
</relationship-role-source>
</ejb-relationship-role>
</ejb-relation>

Is this a bug??? I'm wasting valuable time here... trying to solve this strange thing.

Any ideas?

[triathlon98]

Have you defined id_cliente both as CMP field and as CMR ?
You should onlny define it as either.
You have not included enough of your jbosscmp-jdbc.xml file, but there should not be a cmp-field with fieldname idcliente for the entity bean.

Joachim

[svankirk]

I am getting the same results with my 1:n relationship with SQL Server 2000. Have you had any luck in fixing this?

-Scott