Re: DB2
I think I have an app that connects to a DB2 server. What’s up? On Wed, Oct 12, 2016 at 6:57 AM, Michael Kondratov < mich...@aspireauctions.com> wrote: > Hello, > Any one using WO with DB2? > > Michael > > Sent from my iPhone > ___ > 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: > https://lists.apple.com/mailman/options/webobjects- > dev/lon.varscsak%40gmail.com > > This email sent to lon.varsc...@gmail.com ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
DB2
Hello, Any one using WO with DB2? Michael Sent from my iPhone ___ 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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
DB2 Plugin Done
So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. So how should I give this to Wonder? Here is a list of what I have done. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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 Done
Ok I got a github account and made a fork. What is confusing me is which branch in the fork do I check out and add my code to. Is master the right one? Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 10:02 AM, Pascal Robert wrote: Le 2011-04-27 à 09:47, Jeffrey Simpson a écrit : So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. Cool! So how should I give this to Wonder? Here is a list of what I have done. Open a GitHub account, do your own fork of Wonder and add your projects into your Wonder fork. You can ask people who run DB2 to try out your plugin and if everything works fine, you can do a pull request so that a Wonder committer can add it into the master Wonder repository. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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 Done
Le 2011-04-27 à 11:41, Jeffrey Simpson a écrit : Ok I got a github account and made a fork. What is confusing me is which branch in the fork do I check out and add my code to. Is master the right one? If you use WebObjects 5.4.x, master is the right one. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 10:02 AM, Pascal Robert wrote: Le 2011-04-27 à 09:47, Jeffrey Simpson a écrit : So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. Cool! So how should I give this to Wonder? Here is a list of what I have done. Open a GitHub account, do your own fork of Wonder and add your projects into your Wonder fork. You can ask people who run DB2 to try out your plugin and if everything works fine, you can do a pull request so that a Wonder committer can add it into the master Wonder repository. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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 Done
I have checked in my plugin to g...@github.com:jeffreyindc/wonder.git. Please have a look. I know I am probably the only person using DB2 but the PluginTest may be of interest. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 11:45 AM, Pascal Robert wrote: Le 2011-04-27 à 11:41, Jeffrey Simpson a écrit : Ok I got a github account and made a fork. What is confusing me is which branch in the fork do I check out and add my code to. Is master the right one? If you use WebObjects 5.4.x, master is the right one. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 10:02 AM, Pascal Robert wrote: Le 2011-04-27 à 09:47, Jeffrey Simpson a écrit : So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. Cool! So how should I give this to Wonder? Here is a list of what I have done. Open a GitHub account, do your own fork of Wonder and add your projects into your Wonder fork. You can ask people who run DB2 to try out your plugin and if everything works fine, you can do a pull request so that a Wonder committer can add it into the master Wonder repository. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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 Done
This is a better link to the github https://jeffreyi...@github.com/jeffreyindc/wonder.git Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 12:36 PM, Jeffrey Simpson wrote: I have checked in my plugin to g...@github.com:jeffreyindc/wonder.git. Please have a look. I know I am probably the only person using DB2 but the PluginTest may be of interest. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 11:45 AM, Pascal Robert wrote: Le 2011-04-27 à 11:41, Jeffrey Simpson a écrit : Ok I got a github account and made a fork. What is confusing me is which branch in the fork do I check out and add my code to. Is master the right one? If you use WebObjects 5.4.x, master is the right one. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 10:02 AM, Pascal Robert wrote: Le 2011-04-27 à 09:47, Jeffrey Simpson a écrit : So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. Cool! So how should I give this to Wonder? Here is a list of what I have done. Open a GitHub account, do your own fork of Wonder and add your projects into your Wonder fork. You can ask people who run DB2 to try out your plugin and if everything works fine, you can do a pull request so that a Wonder committer can add it into the master Wonder repository. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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 Done
Hi Jeffrey, I had a quick look and so far the project structure seems ok. The only thing missing is the targets in build.xml: https://github.com/jeffreyindc/wonder/blob/master/Build/build/build.xml You should add a target for the plugin (see the H2Plugin.all target for an example) and another target for the PluginTest project. This is a better link to the github https://jeffreyi...@github.com/jeffreyindc/wonder.git Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 12:36 PM, Jeffrey Simpson wrote: I have checked in my plugin to g...@github.com:jeffreyindc/wonder.git. Please have a look. I know I am probably the only person using DB2 but the PluginTest may be of interest. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 11:45 AM, Pascal Robert wrote: Le 2011-04-27 à 11:41, Jeffrey Simpson a écrit : Ok I got a github account and made a fork. What is confusing me is which branch in the fork do I check out and add my code to. Is master the right one? If you use WebObjects 5.4.x, master is the right one. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 10:02 AM, Pascal Robert wrote: Le 2011-04-27 à 09:47, Jeffrey Simpson a écrit : So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. Cool! So how should I give this to Wonder? Here is a list of what I have done. Open a GitHub account, do your own fork of Wonder and add your projects into your Wonder fork. You can ask people who run DB2 to try out your plugin and if everything works fine, you can do a pull request so that a Wonder committer can add it into the master Wonder repository. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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 Done
Thanks for the help. The targets are in there now. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 2:25 PM, Pascal Robert wrote: Hi Jeffrey, I had a quick look and so far the project structure seems ok. The only thing missing is the targets in build.xml: https://github.com/jeffreyindc/wonder/blob/master/Build/build/build.xml You should add a target for the plugin (see the H2Plugin.all target for an example) and another target for the PluginTest project. This is a better link to the github https://jeffreyi...@github.com/jeffreyindc/wonder.git Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 12:36 PM, Jeffrey Simpson wrote: I have checked in my plugin to g...@github.com:jeffreyindc/wonder.git. Please have a look. I know I am probably the only person using DB2 but the PluginTest may be of interest. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 11:45 AM, Pascal Robert wrote: Le 2011-04-27 à 11:41, Jeffrey Simpson a écrit : Ok I got a github account and made a fork. What is confusing me is which branch in the fork do I check out and add my code to. Is master the right one? If you use WebObjects 5.4.x, master is the right one. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simpson@yfu.orgOn Apr 27, 2011, at 10:02 AM, Pascal Robert wrote: Le 2011-04-27 à 09:47, Jeffrey Simpson a écrit : So I have written the DB2 Plugin. It is really 2 plugins. DB2Plugin and DB2ForISeriesPlugIn. There are some slight difference between DB2 running on Linux, Unix and Windows and DB2 running on the iSeries. I think the DB2ForISeriesPlugIn would work for DB2 for OS/390 but I do not promise it. Cool! So how should I give this to Wonder? Here is a list of what I have done. Open a GitHub account, do your own fork of Wonder and add your projects into your Wonder fork. You can ask people who run DB2 to try out your plugin and if everything works fine, you can do a pull request so that a Wonder committer can add it into the master Wonder repository. New DB2Plugin Framework. New PluginTest application. This is a first stab at a application that can be user to test plugins. Different plugins can be tested using the properties in ERXModelGroup. Changed ERExtentions ERXSQLHelper to add support for DB2 Changed ERPrototypes EOJDBCDB2Prototypes to have values that make sense to DB2. The ERExtentions and ERPrototypes changes I can create a patch but what about the other the plugin and the Test App? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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
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
DB2 Plugin Testing
So I am taking my ancient DB2 plugin and updating into a more modern plugin. My hope is to contribute this to Wonder. Is there a standard test suite I should run the plugin against? I am planing to test against both DB2 for Linux and DB2 for iSeries. 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 Testing
I don't know of a suite, but it is a good idea. Chuck On Apr 18, 2011, at 1:27 PM, Jeffrey Simpson wrote: So I am taking my ancient DB2 plugin and updating into a more modern plugin. My hope is to contribute this to Wonder. Is there a standard test suite I should run the plugin against? I am planing to test against both DB2 for Linux and DB2 for iSeries. 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/chill%40global-village.net This email sent to ch...@global-village.net -- 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
Re: DB2 Plugin Testing
It would be great to have unit tests for EOF, so that we can try all plugins and check if they are all working. I don't know of a suite, but it is a good idea. Chuck On Apr 18, 2011, at 1:27 PM, Jeffrey Simpson wrote: So I am taking my ancient DB2 plugin and updating into a more modern plugin. My hope is to contribute this to Wonder. Is there a standard test suite I should run the plugin against? I am planing to test against both DB2 for Linux and DB2 for iSeries. 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/chill%40global-village.net This email sent to ch...@global-village.net -- 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 ___ 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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 Testing
For the plugin, you really need to test SQL generation, DDL generation, model reverse engineering, PK generation, that kind of stuff. You don't need to test all of EOF, so it is a bit constrained. But the results you are testing for are definitely plugin specific. Chuck On Apr 18, 2011, at 3:39 PM, Pascal Robert wrote: It would be great to have unit tests for EOF, so that we can try all plugins and check if they are all working. I don't know of a suite, but it is a good idea. Chuck On Apr 18, 2011, at 1:27 PM, Jeffrey Simpson wrote: So I am taking my ancient DB2 plugin and updating into a more modern plugin. My hope is to contribute this to Wonder. Is there a standard test suite I should run the plugin against? I am planing to test against both DB2 for Linux and DB2 for iSeries. 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/chill%40global-village.net This email sent to ch...@global-village.net -- 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 ___ 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/probert%40macti.ca This email sent to prob...@macti.ca -- 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
Re: DB2
Thanks for your help guys. The attributes of the problem entity were not prototyped. When I added prototypes everything worked fine. Why this is true I do not know. I talked to my boss and he has committed to us writing a DB2 plugin for Wonder. I do not get to work on this until after I complete this upgrade. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simp...@yfu.orgon Apr 21, 2010, at 2:00 PM, Chuck Hill wrote: On Apr 21, 2010, at 7:45 AM, Jeffrey Simpson wrote: Does anyone else use DB2 with WebObjects? I have was thinking of cleaning up my DB2 plugin and submitting it to Wonder. I did not write most of it. All the comments are in German and the dates are all pre 2004. I would love to know who the author was. If someone has a more up to date Db2 plugin I would love to know. We have not used it for a while now, but I think having support in Wonder would be good. I have been upgrading my app to 5.4 and started to get the following error on inserts: EvaluateExpression failed: com.webobjects.jdbcadaptor.As400PlugIn $As400Expression: INSERT INTO YFUALFADEV.USERNAME_PASSWORD_SESSION(USERNAME_PASSWORD_ID, APP_INSTANCE, BROWSER_SESSION_ID, CLIENT_IP, PLATFORM, BROWSER_VERSION, SESSION_ID, ADVISELOGOUT, BROWSER_NAME, LOGIN_TIME, LOGOUT_TIME, APP_HOST, ID, CLIENT_HOST) VALUES (?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, NULL, ?, ?, NULL) withBindings: 1:3220(usernamePasswordID), 2:-1(applicationInstance), 3:A0C108B79214BFB73C25DBDA6EE2D860(browserSessionID), 4:MacOS(platform), 5:5.0(browserVersion), 6:jXggdoBSYar5rpo6iMhT7g(sessionID), 7:1(adviseLogout), 8:Mozilla(browserName), 9:2010-04-21 10:42:32(loginTime), 10:chekov.yfuusa.local(applicationHost), 11:-12508119(id): Next exception:SQL State:22501 -- error code: -311 -- msg: [SQL0311] Length in a varying-length or LOB host variable not valid. Cause . . . . . : Host variable was specified. The value in the length portion of the variable length or LOB host variable is either negative or greater than the declared length. If the host variable is graphic the length should be the number of DBCS characters. The host variable number is . The specified length is . The variable is declared to have length . Recovery . . . : Change the length portion of the varying-length or LOB host variable to a valid positive number or zero. Try the request again. Next exception:SQL Warning: 01H10 -- error code: -9 -- msg: Extra URL elements are ignored. I am not sure what that means. Are you using Wonder? If not, is there out dated jdbc2info in your EOModel? It kind of seems like it is interpreting what you are using for varchar as CLOB. Anyone have any idea? I checked the model and none of the values are larger then the columns. Do you think rewriting the plugin to match the Wonder examples may help? It might, but it seems more like a mismatch in data type. Are the wrong prototypes getting loaded? Do you need an updated DB2 JDBC driver? 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 ___ 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
Sounds good! On Apr 22, 2010, at 1:50 PM, Jeffrey Simpson wrote: Thanks for your help guys. The attributes of the problem entity were not prototyped. When I added prototypes everything worked fine. Why this is true I do not know. I talked to my boss and he has committed to us writing a DB2 plugin for Wonder. I do not get to work on this until after I complete this upgrade. Jeffrey Simpson Senior Software Engineer Telephone: 240.235.2144 Fax: 240.235.2174 Youth For Understanding (YFU) prepares young people for their responsibilities and opportunities in a changing, interdependent world. simp...@yfu.orgon Apr 21, 2010, at 2:00 PM, Chuck Hill wrote: On Apr 21, 2010, at 7:45 AM, Jeffrey Simpson wrote: Does anyone else use DB2 with WebObjects? I have was thinking of cleaning up my DB2 plugin and submitting it to Wonder. I did not write most of it. All the comments are in German and the dates are all pre 2004. I would love to know who the author was. If someone has a more up to date Db2 plugin I would love to know. We have not used it for a while now, but I think having support in Wonder would be good. I have been upgrading my app to 5.4 and started to get the following error on inserts: EvaluateExpression failed: com.webobjects.jdbcadaptor.As400PlugIn $As400Expression: INSERT INTO YFUALFADEV.USERNAME_PASSWORD_SESSION(USERNAME_PASSWORD_ID, APP_INSTANCE, BROWSER_SESSION_ID, CLIENT_IP, PLATFORM, BROWSER_VERSION, SESSION_ID, ADVISELOGOUT, BROWSER_NAME, LOGIN_TIME, LOGOUT_TIME, APP_HOST, ID, CLIENT_HOST) VALUES (?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, NULL, ?, ?, NULL) withBindings: 1:3220(usernamePasswordID), 2:-1(applicationInstance), 3:A0C108B79214BFB73C25DBDA6EE2D860(browserSessionID), 4:MacOS(platform), 5:5.0(browserVersion), 6:jXggdoBSYar5rpo6iMhT7g(sessionID), 7:1(adviseLogout), 8:Mozilla(browserName), 9:2010-04-21 10:42:32(loginTime), 10:chekov.yfuusa.local(applicationHost), 11:-12508119(id): Next exception:SQL State:22501 -- error code: -311 -- msg: [SQL0311] Length in a varying-length or LOB host variable not valid. Cause . . . . . : Host variable was specified. The value in the length portion of the variable length or LOB host variable is either negative or greater than the declared length. If the host variable is graphic the length should be the number of DBCS characters. The host variable number is . The specified length is . The variable is declared to have length . Recovery . . . : Change the length portion of the varying-length or LOB host variable to a valid positive number or zero. Try the request again. Next exception:SQL Warning: 01H10 -- error code: -9 -- msg: Extra URL elements are ignored. I am not sure what that means. Are you using Wonder? If not, is there out dated jdbc2info in your EOModel? It kind of seems like it is interpreting what you are using for varchar as CLOB. Anyone have any idea? I checked the model and none of the values are larger then the columns. Do you think rewriting the plugin to match the Wonder examples may help? It might, but it seems more like a mismatch in data type. Are the wrong prototypes getting loaded? Do you need an updated DB2 JDBC driver? 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 -- 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 ___ 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
DB2
Does anyone else use DB2 with WebObjects? I have was thinking of cleaning up my DB2 plugin and submitting it to Wonder. I did not write most of it. All the comments are in German and the dates are all pre 2004. I would love to know who the author was. If someone has a more up to date Db2 plugin I would love to know. I have been upgrading my app to 5.4 and started to get the following error on inserts: EvaluateExpression failed: com.webobjects.jdbcadaptor.As400PlugIn$As400Expression: INSERT INTO YFUALFADEV.USERNAME_PASSWORD_SESSION(USERNAME_PASSWORD_ID, APP_INSTANCE, BROWSER_SESSION_ID, CLIENT_IP, PLATFORM, BROWSER_VERSION, SESSION_ID, ADVISELOGOUT, BROWSER_NAME, LOGIN_TIME, LOGOUT_TIME, APP_HOST, ID, CLIENT_HOST) VALUES (?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, NULL, ?, ?, NULL) withBindings: 1:3220(usernamePasswordID), 2:-1(applicationInstance), 3:A0C108B79214BFB73C25DBDA6EE2D860(browserSessionID), 4:MacOS(platform), 5:5.0(browserVersion), 6:jXggdoBSYar5rpo6iMhT7g(sessionID), 7:1(adviseLogout), 8:Mozilla(browserName), 9:2010-04-21 10:42:32(loginTime), 10:chekov.yfuusa.local(applicationHost), 11:-12508119(id): Next exception:SQL State:22501 -- error code: -311 -- msg: [SQL0311] Length in a varying-length or LOB host variable not valid. Cause . . . . . : Host variable was specified. The value in the length portion of the variable length or LOB host variable is either negative or greater than the declared length. If the host variable is graphic the length should be the number of DBCS characters. The host variable number is . The specified length is . The variable is declared to have length . Recovery . . . : Change the length portion of the varying-length or LOB host variable to a valid positive number or zero. Try the request again. Next exception:SQL Warning:01H10 -- error code: -9 -- msg: Extra URL elements are ignored. Anyone have any idea? I checked the model and none of the values are larger then the columns. Do you think rewriting the plugin to match the Wonder examples may help? 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
Le 10-04-21 à 10:45, Jeffrey Simpson a écrit : Does anyone else use DB2 with WebObjects? Looking at the results of the 2009 surveys, only two organizations are using EOF with DB2, yours being one of the two. I have was thinking of cleaning up my DB2 plugin and submitting it to Wonder. I did not write most of it. All the comments are in German and the dates are all pre 2004. I would love to know who the author was. If someone has a more up to date Db2 plugin I would love to know. I have been upgrading my app to 5.4 and started to get the following error on inserts: EvaluateExpression failed: com.webobjects.jdbcadaptor.As400PlugIn $As400Expression: INSERT INTO YFUALFADEV.USERNAME_PASSWORD_SESSION(USERNAME_PASSWORD_ID, APP_INSTANCE, BROWSER_SESSION_ID, CLIENT_IP, PLATFORM, BROWSER_VERSION, SESSION_ID, ADVISELOGOUT, BROWSER_NAME, LOGIN_TIME, LOGOUT_TIME, APP_HOST, ID, CLIENT_HOST) VALUES (?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, NULL, ?, ?, NULL) withBindings: 1:3220(usernamePasswordID), 2:-1(applicationInstance), 3:A0C108B79214BFB73C25DBDA6EE2D860(browserSessionID), 4:MacOS(platform), 5:5.0(browserVersion), 6:jXggdoBSYar5rpo6iMhT7g(sessionID), 7:1(adviseLogout), 8:Mozilla(browserName), 9:2010-04-21 10:42:32(loginTime), 10:chekov.yfuusa.local(applicationHost), 11:-12508119(id): Next exception:SQL State:22501 -- error code: -311 -- msg: [SQL0311] Length in a varying-length or LOB host variable not valid. Cause . . . . . : Host variable was specified. The value in the length portion of the variable length or LOB host variable is either negative or greater than the declared length. If the host variable is graphic the length should be the number of DBCS characters. The host variable number is . The specified length is . The variable is declared to have length . Recovery . . . : Change the length portion of the varying-length or LOB host variable to a valid positive number or zero. Try the request again. Next exception:SQL Warning: 01H10 -- error code: -9 -- msg: Extra URL elements are ignored. Anyone have any idea? I checked the model and none of the values are larger then the columns. Do you think rewriting the plugin to match the Wonder examples may help? 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/probert%40macti.ca This email sent to prob...@macti.ca ___ 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
On Apr 21, 2010, at 7:45 AM, Jeffrey Simpson wrote: Does anyone else use DB2 with WebObjects? I have was thinking of cleaning up my DB2 plugin and submitting it to Wonder. I did not write most of it. All the comments are in German and the dates are all pre 2004. I would love to know who the author was. If someone has a more up to date Db2 plugin I would love to know. We have not used it for a while now, but I think having support in Wonder would be good. I have been upgrading my app to 5.4 and started to get the following error on inserts: EvaluateExpression failed: com.webobjects.jdbcadaptor.As400PlugIn $As400Expression: INSERT INTO YFUALFADEV.USERNAME_PASSWORD_SESSION(USERNAME_PASSWORD_ID, APP_INSTANCE, BROWSER_SESSION_ID, CLIENT_IP, PLATFORM, BROWSER_VERSION, SESSION_ID, ADVISELOGOUT, BROWSER_NAME, LOGIN_TIME, LOGOUT_TIME, APP_HOST, ID, CLIENT_HOST) VALUES (?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, NULL, ?, ?, NULL) withBindings: 1:3220(usernamePasswordID), 2:-1(applicationInstance), 3:A0C108B79214BFB73C25DBDA6EE2D860(browserSessionID), 4:MacOS(platform), 5:5.0(browserVersion), 6:jXggdoBSYar5rpo6iMhT7g(sessionID), 7:1(adviseLogout), 8:Mozilla(browserName), 9:2010-04-21 10:42:32(loginTime), 10:chekov.yfuusa.local(applicationHost), 11:-12508119(id): Next exception:SQL State:22501 -- error code: -311 -- msg: [SQL0311] Length in a varying-length or LOB host variable not valid. Cause . . . . . : Host variable was specified. The value in the length portion of the variable length or LOB host variable is either negative or greater than the declared length. If the host variable is graphic the length should be the number of DBCS characters. The host variable number is . The specified length is . The variable is declared to have length . Recovery . . . : Change the length portion of the varying-length or LOB host variable to a valid positive number or zero. Try the request again. Next exception:SQL Warning: 01H10 -- error code: -9 -- msg: Extra URL elements are ignored. I am not sure what that means. Are you using Wonder? If not, is there out dated jdbc2info in your EOModel? It kind of seems like it is interpreting what you are using for varchar as CLOB. Anyone have any idea? I checked the model and none of the values are larger then the columns. Do you think rewriting the plugin to match the Wonder examples may help? It might, but it seems more like a mismatch in data type. Are the wrong prototypes getting loaded? Do you need an updated DB2 JDBC driver? 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 ___ 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
db2 express C and jdbc
hello. for several days, i was trying to connect my EOMODEL to my newly installed db2 express c database on my windows box. but i always get the error: [jcc][t4][10251][10308][3.50.152] java.sql.Connection.close() requested while a transaction is in progress on the connection. The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null i've already copied the necessary db2 jdbc jar files to my mac book (i got these jar files from my db2 install folder on my windows box): db2java.zip db2jcc.jar db2jcc4.jar db2jcc_license_cu.jar based on the error above, it seems that the driver is not the problem. but rather on the connection. do i need to change some settings on my db2 server side on windows? by the way, the parms that i supplied my eomodel are: url = jdbc:db2://server:5/testdata driver = com.ibm.db2.jcc.DB2Driver hope you guys can help! thanks. ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
I'm not sure I'd call it a bug as Chuck's original code does the Right Thing® in 99.9% of the situations you'd use it. But, being the PITA that I am, I've come up with a situation where even though the his code can't verify that what I'm doing is safe from a referential- integrity perspective, I know it will be safe due to my specific business-logic rules. So, if by saying he gave me a patch for the bug, he means he told me which safety to disable, I guess that would be about right. :-) Dave On Apr 6, 2008, at 8:26 PM, Chuck Hill wrote: David Avendasora pointed out a bug in it if you are using self- referential relationships (entity with a relationship to itself). I gave him a patch, but I really need to rethink some parts of that code. It works for most things, but I think there are some more buggy cases. It also does not (yet) order operations on the same table which self-referential relationships really need. ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
On Apr 7, 2008, at 2:19 AM, David Avendasora wrote: I'm not sure I'd call it a bug as Chuck's original code does the Right Thing® in 99.9% of the situations you'd use it. If my code does not work in 0.1% of situations, then I'd consider it buggy. But that is just me. :-) But, being the PITA that I am, I've come up with a situation where even though the his code can't verify that what I'm doing is safe from a referential-integrity perspective, I know it will be safe due to my specific business-logic rules. So, if by saying he gave me a patch for the bug, he means he told me which safety to disable, I guess that would be about right. :-) IIRC, there was also a change from entity().name() to entity.externalName(). Chuck On Apr 6, 2008, at 8:26 PM, Chuck Hill wrote: David Avendasora pointed out a bug in it if you are using self- referential relationships (entity with a relationship to itself). I gave him a patch, but I really need to rethink some parts of that code. It works for most things, but I think there are some more buggy cases. It also does not (yet) order operations on the same table which self-referential relationships really need. -- 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 ___ 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 [EMAIL PROTECTED]
DB2 and WebObjects
Hello; A couple of years ago I was investigating DB2 and WO. A couple of people were kind enough to point me in the right direction. I've got another question. I could be wrong, but suspect that DB2 doesn't support deferred RI checks -- if this is the case, how are people managing to work around this problem with EOF? Chuck; does your operations ordering system work for more than just MSSQL? cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
Hi Andrew, On Apr 6, 2008, at 5:09 PM, Andrew Lindesay wrote: Hello; A couple of years ago I was investigating DB2 and WO. A couple of people were kind enough to point me in the right direction. I've got another question. I could be wrong, but suspect that DB2 doesn't support deferred RI checks -- if this is the case, how are people managing to work around this problem with EOF? Chuck; does your operations ordering system work for more than just MSSQL? It works for anything. It is high enough up in EOF to be DB agnostic. It is just _needed_ for MSSQL. I leave it on when using FrontBase (which is most of the time). David Avendasora pointed out a bug in it if you are using self- referential relationships (entity with a relationship to itself). I gave him a patch, but I really need to rethink some parts of that code. It works for most things, but I think there are some more buggy cases. It also does not (yet) order operations on the same table which self-referential relationships really need. No deferred constraints. Sigh. DB2 just dropped a notch in the respect that I had for it. Chuck -- 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 ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
Hello Chuck; Thanks for the overview on that one. No deferred constraints. Sigh. DB2 just dropped a notch in the respect that I had for it. I'm actually not 100% sure on the deferred RI checks for DB2 so leave the respect in place for now! I was wondering if somebody here knows? I see DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
On Apr 6, 2008, at 5:38 PM, Andrew Lindesay wrote: Hello Chuck; Thanks for the overview on that one. No deferred constraints. Sigh. DB2 just dropped a notch in the respect that I had for it. I'm actually not 100% sure on the deferred RI checks for DB2 so leave the respect in place for now! I was wondering if somebody here knows? I Googled it when you said that as it surprised me. The answer I found was that it did not. I see DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. Yes, that would be possible. But does that mean you can commit data that violates the constaints? Chuck -- 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 ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
Hello Chuck; I Googled it when you said that as it surprised me. The answer I found was that it did not. Hmmm darn. I was hoping that I had spelt deferred wrong or something. :) I see DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. ... Yes, that would be possible. But does that mean you can commit data that violates the constaints? I _think_ I am reading that it can play catch-up from when you turn it back on again. cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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 [EMAIL PROTECTED]
Re: DB2 and WebObjects
On Apr 6, 2008, at 5:48 PM, Andrew Lindesay wrote: Hello Chuck; I Googled it when you said that as it surprised me. The answer I found was that it did not. Hmmm darn. I was hoping that I had spelt deferred wrong or something. :) I see DB2 has a feature to turn constraints off/on inside a transaction so I am guessing it would be possible to create a JDBCAdaptor subclass that automatically did that sort of thing when it goes to perform adaptor operations on a channel. ... Yes, that would be possible. But does that mean you can commit data that violates the constaints? I _think_ I am reading that it can play catch-up from when you turn it back on again. That could OK then. You would have (want) to create an exception with enough info to identify the constraint downstream. Chuck -- 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 ___ 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 [EMAIL PROTECTED]
Re: DB2 and WO
On 9/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello -- does anybody use DB2 with WO5? I can't see any adaptors out there? Has anybody had a crack at writing a JDBC adaptor for it? We use DB2 for one of our WebObjects projects. We were just using the normal JDBC stuff until we encountered a problem with LEFT OUTER JOIN syntax and needed some additional non-JDBC DB2-only functionality, so we ended up writing a small plugin to work around those. I don't think I can publish the class, but I can give snippets. It was my first attempt and probably not very good, but it worked for our needs. We've not had luck with the pure-Java drivers, but that could easily be a function of the strict nature of the DB2 database we access. The native type-2 drivers work just fine, though they were a pain to install and get working. Logan ___ 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 archive@mail-archive.com
DB2 and WO
Hello -- does anybody use DB2 with WO5? I can't see any adaptors out there? Has anybody had a crack at writing a JDBC adaptor for it? cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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 archive@mail-archive.com
Re: DB2 and WO
Yes, we are using it with one client. All we wrote was the plugin , then we use the drivers from IBM. If you are interested I will look into publishing the classes. On 6-Sep-06, at 5:51 PM, [EMAIL PROTECTED] wrote: Hello -- does anybody use DB2 with WO5? I can't see any adaptors out there? Has anybody had a crack at writing a JDBC adaptor for it? cheers. ___ Andrew Lindesay www.lindesay.co.nz ___ 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/daspinall% 40ticoon.com This email sent to [EMAIL PROTECTED] ___ 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 archive@mail-archive.com
DB2 Plugin?
Title: DB2 Plugin? Does anyone have a DB2 plugin available for WO? I need to support CLOB datatypes. Thanks in advance -- Dov Rosenberg Inquira Inc 370 Centerpointe Circle, ste 1178 Altamonte Springs, FL 32701 (407) 339-1177 x 102 (407) 339-6704 (fax) [EMAIL PROTECTED] AOL IM: dovrosenberg ___ 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 archive@mail-archive.com
