Re: EO_PK_TABLE and auto_increment
Re: EO_PK_TABLE and auto_increment
- Subject: Re: EO_PK_TABLE and auto_increment
- From: Anjo Krank <email@hidden>
- Date: Wed, 16 Nov 2005 07:41:02 +0100
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 thread storage and then use another
delegate method to munge the adaptor operations to switch from insert
to update for this row.
Having said that, I wouldn't want to be the one to implement that...
Am 16.11.2005 um 06:11 schrieb 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?
The com.webobjects.jdbcadaptor.MySQLPlugIn class does exist,
however, it doesn't support auto_increment and uses the default pk
generation.
I think customising MySQLPlugIn is the answer to my problems. (The
other solutions are explained here: http://developer.apple.com/
documentation/LegacyTechnologies/WebObjects/WebObjects_4.0/System/
Documentation/Developer/EnterpriseObjects/Guide/FAQ2.html). Does
anyone know of any existing implementations?
Thanks,
Corin
On 16/11/2005, at 2:17 PM, Arturo Pérez wrote:
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 to.
-arturo
On Nov 15, 2005, at 9:10 PM, Corin Lawson wrote:
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:
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
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 relies on auto_increment to create keys.
The only workaround that I can think of is to set the values
in EO_PK_TABLE to some ridiculously large number (but not to
large, perhaps somewhere in between the current value and the
upper limit). Does anyone have another idea? Can WO default
behaviour be changed to accept the use of auto_increment?
Thanks,
Corin.
But that won't work either coz auto_increment uses that last
added pk.
Pls help...
Corin.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40anderhome.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40ethicist.net
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40logicunited.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden