(in case you're wondering, yes, i did get mysql working .... argh.)

info: WO5, Mac OS X 10.0.4, MySQL 3.23.32, mm.mysql JDBC adaptor 2.0.6.1

I get this error:
>java.lang.IllegalStateException: Adaptor 
>com.webobjects.jdbcadaptor.JDBCAdaptor@b7ad3 failed to provide new primary 
>keys for entity 'Style'

here's the code excerpt:
                editingContext.insertObject(styleItem);
                editingContext.insertObject(colourItem);
                editingContext.saveChanges();              <--- dies here

What's interesting is that EOModeler creates the table like this:
>+------------+-------------+------+-----+---------+-------+
>| Field      | Type        | Null | Key | Default | Extra |
>+------------+-------------+------+-----+---------+-------+
>| id         | int(11)     |      | PRI | 0       |       |
>| style_name | varchar(10) | YES  |     | NULL    |       |
>+------------+-------------+------+-----+---------+-------+

there's no auto_increment for the id.


Paul

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to