Re: EO_PK_TABLE and auto_increment

2005-11-16 Thread Corin Lawson
Furthermore, if I'm wrong in my assumption it should be possible for the plugin (or the channel?) to maintain a space of new PKs. I would need to know more about the life of the objects involved to make those decisions. Corin. On 17/11/2005, at 9:23 AM, Corin Lawson wrote: Then the row mus

Re: EO_PK_TABLE and auto_increment

2005-11-16 Thread Corin Lawson
Then the row must be inserted and then deleted immediately, it's a fudge but it won't need to happen everytime. Although I would like to know more about how oef uses the newPrimaryKeys method. Does it request batches of PKs to be used at a later time? If so, can that number be increased?

Re: EO_PK_TABLE and auto_increment

2005-11-15 Thread Anjo Krank
The short answer is that you can't do this. No way, period. The longer answer is that you *might* be able to do this by creating an empty column when WO wants its PK (by using the EOAccess delegates, take care of non-null and the like), return its PK from the JDBC channel, stuff it in threa

Re: EO_PK_TABLE and auto_increment

2005-11-15 Thread Corin Lawson
Thank you for the hint... But I can't find anything from the com.webobjects.jdbcadaptor package in the Project Wonder javadoc tree. I did find a Postgesql plugin in the wonder-2.0 download, but no mysql. The JavaERJDBCAdaptor cvs directory appears to empty, does anyone know a download? T

Re: EO_PK_TABLE and auto_increment

2005-11-15 Thread Arturo Pérez
I think project wonder may have a plugin for MySQL. I know it does for Postgresql and Oracle. You may want to take those and modify them to work with the way that your legacy system works. I think there was is a delegate in EOF that lets you generate primary keys how ever you would want t

Re: EO_PK_TABLE and auto_increment

2005-11-15 Thread Corin Lawson
Hi, More questions here to build upon the one below... Would Project Wonder offer a solution? If yes, how would one go about it or begin? Can I import WOnder into Eclipse? If yes, do any guides/instructions exist and where? Cheers, Corin. On 08/11/2005, at 5:00 PM, Corin Lawson wrote:

Re: EO_PK_TABLE and auto_increment

2005-11-07 Thread Corin Lawson
Mysql... (sorry I forgot to mention.) On 01/11/2005, at 11:11 PM, Ken Anderson wrote: What database are you using? On Nov 1, 2005, at 3:53 AM, Corin Lawson wrote: On 01/11/2005, at 7:39 PM, Corin Lawson wrote: Hi all, I have a WO app that accesses an existing database which is curre

Re: EO_PK_TABLE and auto_increment

2005-11-01 Thread Ken Anderson
What database are you using? On Nov 1, 2005, at 3:53 AM, Corin Lawson wrote: On 01/11/2005, at 7:39 PM, Corin Lawson wrote: Hi all, I have a WO app that accesses an existing database which is currently used by a larger system. My requirement is to integrate these systems that share th

Re: EO_PK_TABLE and auto_increment

2005-11-01 Thread Corin Lawson
On 01/11/2005, at 7:39 PM, Corin Lawson wrote: Hi all, I have a WO app that accesses an existing database which is currently used by a larger system. My requirement is to integrate these systems that share the one database. This means that WO does not have exclusive control of generat

EO_PK_TABLE and auto_increment

2005-11-01 Thread Corin Lawson
Hi all, I have a WO app that accesses an existing database which is currently used by a larger system. My requirement is to integrate these systems that share the one database. This means that WO does not have exclusive control of generating primary keys. Furthermore the older system reli