Thanx Werner, I  actually discovered it just afterwards by browsing
castor's javadoc

Thanx again & regards
        marco

-----Original Message-----
From: Werner Guttmann [mailto:[EMAIL PROTECTED] 
Sent: 26 July 2005 14:44
To: [email protected]
Subject: RE: [castor-user] [openEJB & castor}

Marco,

mySQL to my knowledge does not offer support for sequences. Imho, you'll
have to use a different key generator, e.g. identity or max.

Werner

> --- Ursprüngliche Nachricht ---
> Von: "Marco Mistroni" <[EMAIL PROTECTED]>
> An: <[email protected]>
> Betreff: RE: [castor-user] [openEJB & castor}
> Datum: Tue, 26 Jul 2005 14:17:33 +0100
> 
> Hello all,
>       Sorry for the partially off-topic question, but I guess the
> problem has happened also to normal castor user.
> I am using openejb1.0 to test entity bean.
> Openejb uses internally castor, so I have defined following
mapping.xml
> 
> 
> <!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version
> 1.0//EN"
>                            "http://castor.exolab.org/mapping.dtd";>
> <mapping>
> 
>   <!--  Mapping for ProductGroup  -->
>   <class name="com.myapp.ejb.EntryCMP" identity="id" 
>     key-generator="SEQUENCE">
>     <map-to table="entries"/>
> 
>         <field name="id"
>                    type="integer" direct="true">
>        <sql name="id" type="integer"/>
>         </field>
> 
>       <field name="description" type="java.lang.String">
>         <sql name="description" type="varchar"/>
>       </field>
> 
>       <field name="type"
>                    type="integer">
>        <sql name="type" type="integer"/>
>         </field>
> 
>       <field name="amount"
>                    type="double">
>        <sql name="amount" type="double"/>
>         </field>
> 
>       <field name="date"
>                    type="java.util.Date">
>        <sql name="date" type="date"/>
>         </field>
> 
> 
>   </class> 
> 
> 
> 
> </mapping>
> 
> 
> and when I run my test code (which creates an Entity Bean) I have
> following exception
>               86  ) A fatal exception occurred:
> org.exolab.castor.mapping.MappingException: The key generator
> org.exolab.castor.jdo.drivers.SequenceKeyGenerator is not compatible
> with the persistence factory mysql.
> 
> 
> Any help on how to solve the problem?
> 
> Regards
>       marco
> 
> 
> -------------------------------------------------
> If you wish to unsubscribe from this list, please 
> send an empty message to the following address:
> 
> [EMAIL PROTECTED]
> -------------------------------------------------
> 

-- 
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail
+++ GMX - die erste Adresse f�r Mail, Message, More +++

-------------------------------------------------
If you wish to unsubscribe from this list, please 
send an empty message to the following address:

[EMAIL PROTECTED]
-------------------------------------------------


-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:

[EMAIL PROTECTED]
-------------------------------------------------

Reply via email to