Re: EO_PK_TABLE and auto_increment
Re: EO_PK_TABLE and auto_increment
- Subject: Re: EO_PK_TABLE and auto_increment
- From: Corin Lawson <email@hidden>
- Date: Wed, 16 Nov 2005 16:11:08 +1100
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:
This email sent to email@hidden