[OJB-developers] MS Access and autoincrements

[Havemeister, T. <Tho...@gf...>]

Howdy *.*! 

There must be a bug with autoincrements on MS Access databases through
jdbc:odbc driver. Everything seems to run fine but now I played with m:n
associations and run in trouble with this error: 

The list of available products: 

[DEFAULT] WARN: problems with platform
ojb.broker.platforms.PlatformMsAccessImpl:
ojb.broker.platforms.PlatformMsAccessImpl 
[DEFAULT] WARN: OJB will use PlatformDefaultImpl instead 
[DEFAULT] ERROR: OJB ERROR: Dont know how to autoincrement field class
test.ojb.tutorial1.PC._id 

What can I do? Is Access not supported by OJB? I'm currently using
ojb-0.8.361-src archive ..

my XML Repository:

<!-- Mapping of User defined classes starts here -->
<!-- Please keep user defined mappings in this file only,
     to avoid mixing user defined and system mappings. -->   

<!-- Definitions BObject for test.ojb.tutorial1.PC -->

   <ClassDescriptor id="1001">
      <class.name>test.ojb.tutorial1.PC</class.name>
      <table.name>PC</table.name>
      
      <FieldDescriptor id="1">
         <field.name>_id</field.name>
         <column.name>ID_PC</column.name>
         <jdbc_type>INTEGER</jdbc_type>
         <PrimaryKey>true</PrimaryKey>
         <autoincrement>true</autoincrement>
      </FieldDescriptor>
      
      <FieldDescriptor id="2">
         <field.name>name</field.name>
         <column.name>NAME</column.name>
         <jdbc_type>VARCHAR</jdbc_type>
      </FieldDescriptor>
      
      <FieldDescriptor id="3">
         <field.name>status</field.name>
         <column.name>STATUS</column.name>
         <jdbc_type>INTEGER</jdbc_type>
      </FieldDescriptor>
      
      <FieldDescriptor id="4">
         <field.name>lastUpdate</field.name>
         <column.name>LAST_UPDATE</column.name>
         <jdbc_type>DATE</jdbc_type>
      </FieldDescriptor>
      
      <FieldDescriptor id="5">
         <field.name>deleted</field.name>
         <column.name>DELETED</column.name>
         <jdbc_type>INTEGER</jdbc_type>
      </FieldDescriptor>

      <FieldDescriptor id="6">
         <field.name>empl</field.name>
         <column.name>ID_EMPLOYEE</column.name>
         <jdbc_type>INTEGER</jdbc_type>
      </FieldDescriptor>

	<CollectionDescriptor id="1">
		<cdfield.name>allSoftware</cdfield.name>
		<items.class>test.ojb.tutorial1.PCxSoftware</items.class>
		<inverse_fk_descriptor_ids>1</inverse_fk_descriptor_ids>
	</CollectionDescriptor>

   </ClassDescriptor>

<!-- Definitions for Role test.ojb.tutorial1.PCxSoftware -->

      <ClassDescriptor id="1002">
      <class.name>test.ojb.tutorial1.PCxSoftware</class.name>
      <table.name>PC_SOFTWARE</table.name>
      
      <FieldDescriptor id="1">
         <field.name>_id_pc</field.name>
         <column.name>ID_PC</column.name>
         <jdbc_type>INTEGER</jdbc_type>
         <PrimaryKey>true</PrimaryKey>
      </FieldDescriptor>

      <FieldDescriptor id="2">
         <field.name>_id_software</field.name>
         <column.name>ID_SOFTWARE</column.name>
         <jdbc_type>INTEGER</jdbc_type>
	 <PrimaryKey>true</PrimaryKey>
      </FieldDescriptor>
      
      <ReferenceDescriptor id="1">
	 <rdfield.name>pc</rdfield.name>
	 <referenced.class>test.ojb.tutorial1.PC</referenced.class>
	 <fk_descriptor_ids>1</fk_descriptor_ids>
      </ReferenceDescriptor>

      <ReferenceDescriptor id="2">
	<rdfield.name>software</rdfield.name>
	<referenced.class>test.ojb.tutorial1.Software</referenced.class>
	<fk_descriptor_ids>2</fk_descriptor_ids>
      </ReferenceDescriptor>

   </ClassDescriptor>

<!-- Definitions for BObject test.ojb.tutorial1.Software -->

      <ClassDescriptor id="1003">
      <class.name>test.ojb.tutorial1.Software</class.name>
      <table.name>SOFTWARE</table.name>
      
      <FieldDescriptor id="1">
         <field.name>_id</field.name>
         <column.name>ID_SOFTWARE</column.name>
         <jdbc_type>INTEGER</jdbc_type>
         <PrimaryKey>true</PrimaryKey>
         <autoincrement>true</autoincrement>
      </FieldDescriptor>
      
      <FieldDescriptor id="2">
         <field.name>name</field.name>
         <column.name>NAME</column.name>
         <jdbc_type>VARCHAR</jdbc_type>
      </FieldDescriptor>
      
      <FieldDescriptor id="3">
         <field.name>maxLicences</field.name>
         <column.name>MAXLICENSES</column.name>
         <jdbc_type>INTEGER</jdbc_type>
      </FieldDescriptor>
      
      <FieldDescriptor id="4">
         <field.name>lastUpdate</field.name>
         <column.name>LAST_UPDATE</column.name>
         <jdbc_type>DATE</jdbc_type>
      </FieldDescriptor>
      
	<FieldDescriptor id="5">
		<field.name>deleted</field.name>
		<column.name>DELETED</column.name>
		<jdbc_type>INTEGER</jdbc_type>
	</FieldDescriptor>

	<CollectionDescriptor id="1">
		<cdfield.name>toPC</cdfield.name>
		<items.class>test.ojb.tutorial1.PCxSoftware</items.class>
		<inverse_fk_descriptor_ids>2</inverse_fk_descriptor_ids>
	</CollectionDescriptor>

</ClassDescriptor>

<!-- Mapping of User defined classes ends here -->

-- 
Thomas Havemeister
Software Developer


GFT Systems GmbH

Ehrenbergstrasse 11
D-98693 Ilmenau
T +49-36 77-64 29-0
D +49-36 77-66 33-77
tho...@gf...
www.gft.com