[castor-dev] IDENTITY problem on sqlserver

[BOUEY St�phane]

Title: Message

Hello,

 

I have an error when i try to create an object with :

 

    JdoTest jdotest = new JdoTest();
 

   db.begin();
    jdotest.setName("test");
    db.create(jdotest);
    db.commit();

 

 

my mapping.xml file is :

 

<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
                           "http://castor.exolab.org/mapping.dtd">
<mapping>

 

  <!--  Mapping for JdoTest  -->
  <class name="com.freever.db.JdoTest"
         identity="id"  key-generator="IDENTITY">

 

    <map-to table="jdotest"  />

 

    <field name="id" type="integer" >
      <sql name="id" type="integer"/>
      <xml node="attribute"/>
    </field>

 

    <field name="name" type="string">
      <sql name="name" type="char" dirty="check" />
      <xml node="text" />
    </field>

 

  </class>

 

</mapping>

 

my schema file :

 

<?xml version="1.0"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">

 

 

  <xsd:element name="jdoTest">
      <xsd:complexType>
          <xsd:sequence>
            <xsd:element name="id" type="xsd:integer" />
            <xsd:element name="name" type="xsd:string"/>
          </xsd:sequence>
      </xsd:complexType>
  </xsd:element>
</xsd:schema>

 

 

 where is the problem ?

 

Thank you,

st�phane BOUEY