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] -------------------------------------------------
