DB2 Plugin SQL Generation
Thanks for the responses from my previous email DB2 Plugin testing. I am working on the SQL Generation and so I looked at the sql generated from the MySql Plugin and the Postgress plugin. I have a question related to PK generation support. Here is a sample of the generated sql: CREATE SEQUENCE Employee_seq; CREATE TEMP TABLE EOF_TMP_TABLE AS SELECT SETVAL('Employee_seq', (SELECT MAX(id) FROM Employee)); DROP TABLE EOF_TMP_TABLE; ALTER TABLE Employee ALTER COLUMN id SET DEFAULT nextval( 'Employee_seq' ); In the Create table and alter table scripts there is are 2 function calls setval and nextval. Are these user defined functions? If they are are there any examples? Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 simp...@yfu.org Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: DB2 Plugin SQL Generation
Hi Jeffrey, On Apr 20, 2011, at 11:13 AM, Jeffrey Simpson wrote: > Thanks for the responses from my previous email DB2 Plugin testing. > > I am working on the SQL Generation and so I looked at the sql generated from > the MySql Plugin and the Postgress plugin. I have a question related to PK > generation support. Here is a sample of the generated sql: > > CREATE SEQUENCE Employee_seq; > > CREATE TEMP TABLE EOF_TMP_TABLE AS SELECT SETVAL('Employee_seq', (SELECT > MAX(id) FROM Employee)); > > DROP TABLE EOF_TMP_TABLE; > > ALTER TABLE Employee ALTER COLUMN id SET DEFAULT nextval( 'Employee_seq' ); > > In the Create table and alter table scripts there is are 2 function calls > setval and nextval. Are these user defined functions? If they are are there > any examples? I think those are db specific. You need to figure out what you want it to emit for DB2, then look at com.webobjects.eoaccess.synchronization.EOSchemaSynchronizationFactory You will want a sub-class of this in your plugin, see public EOSchemaSynchronizationFactory createSchemaSynchronizationFactory() in JDCBPlugin. You can override the methods to produce appropriate SQL for DB2. Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects smime.p7s Description: S/MIME cryptographic signature ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Session EC Exception
So, I have over 4000 user objects related to about 20 country objects. I had a few duplicate countries in the country table because of record imports. So, I wrote a quick direct action that allows me to merge the countries. Basically, there are two drop-down lists, each with the full country list (including duplicates). I can select two different country objects and the page moves all users of the first selected country to the second selected country. Here's the problem. I've been successful merging almost every country to the appropriate country. The successful merges have had between 1-500 user objects to move. When I was trying to move USA related users to United States, 900 records successfully move, but I get the following error for over 200 records. "er.transaction.adaptor.Exceptions - Database Exception occured: com.webobjects.eoaccess.EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier -- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database updateValuesInRowDescribedByQualifier -- com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database" Where should I start looking to resolve? I've compared the data from objects that successfully transferred against those that didn't transfer and I'm not seeing a clear pattern. Thanks, Ken ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com