Re: WO 5.3.3 / SQL-Server and primary key generation
Hey thanks, this helps - another idea anyway. I was wondering about deadlocks too the way the it runs now. We are on SQL-Server 2005, not sure if that matters. I will look at XLOCK tomorrow. I'm not sure where the plugin we have came from, but luckily all the source code for it is in with the project itself so tweaking that might be an option. - Mike On Jan 11, 2012, at 5:48 PM, Peter Vandoros wrote: > Hi Mike, > > I had a similar problem a long time ago in a configuration like yours. The > difference was that I was getting dead locking transactions being detected by > SQL server. > > I resolved it by changing the SQL to use an XLOCK instead - via my custom ms > SQL JDBC hint plugin. > > Hope that helps! > > Regards, > > Peter > > On 12/01/2012, at 7:04 AM, Michael DeMan wrote: > >> Hi All, >> >> I have a legacy 5.3.3 application that we need to scale up to multiple >> instances. It is a pretty big, old and fragile code base - wonderizing it >> does not seem to be an option. I reviewed the code and the use cases are >> separate enough that there is no need for full inter-app EO change >> notifications - except for primary key generation. On the primary key >> generation, I noticed that the SQL being generated is like the below and was >> thinking that with that UPDLOCK and ROWLOCK on the EO_PK_TABLE, that it >> might 'just work'. However, in testing, I was able to get cases where >> different application instances were colliding on trying to use the same >> primary key value. >> >> >> [2012-01-07 12:29:35 EST] evaluateExpression: >> > FROM EO_PK_TABLE WITH (UPDLOCK,ROWLOCK) WHERE NAME = 'PROVIDER_USER'"> >> [2012-01-07 12:29:35 EST] evaluateExpression: >> > EO_PK_TABLE SET PK = 2532643 WHERE NAME = 'PROVIDER_USER' AND PK = 2532642"> >> >> >> >> I am unsure how to proceed and was hoping somebody might be able to give me >> some pointers. >> >> #1. Should that SQL above be okay and doing the right thing? Maybe we just >> have something set wrong on SQL-Server and it is ignoring the locks? >> >> #2. Otherwise - I am thinking my best bet is to override the hook in EOF >> for primary key generation. >> >> >> Thanks, >> >> - Mike DeMan >> >> ___ >> 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/peter.vandoros%40gmail.com >> >> This email sent to peter.vando...@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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WO 5.3.3 / SQL-Server and primary key generation
Hi Mike, I had a similar problem a long time ago in a configuration like yours. The difference was that I was getting dead locking transactions being detected by SQL server. I resolved it by changing the SQL to use an XLOCK instead - via my custom ms SQL JDBC hint plugin. Hope that helps! Regards, Peter On 12/01/2012, at 7:04 AM, Michael DeMan wrote: > Hi All, > > I have a legacy 5.3.3 application that we need to scale up to multiple > instances. It is a pretty big, old and fragile code base - wonderizing it > does not seem to be an option. I reviewed the code and the use cases are > separate enough that there is no need for full inter-app EO change > notifications - except for primary key generation. On the primary key > generation, I noticed that the SQL being generated is like the below and was > thinking that with that UPDLOCK and ROWLOCK on the EO_PK_TABLE, that it might > 'just work'. However, in testing, I was able to get cases where different > application instances were colliding on trying to use the same primary key > value. > > > [2012-01-07 12:29:35 EST] evaluateExpression: > FROM EO_PK_TABLE WITH (UPDLOCK,ROWLOCK) WHERE NAME = 'PROVIDER_USER'"> > [2012-01-07 12:29:35 EST] evaluateExpression: > EO_PK_TABLE SET PK = 2532643 WHERE NAME = 'PROVIDER_USER' AND PK = 2532642"> > > > > I am unsure how to proceed and was hoping somebody might be able to give me > some pointers. > > #1. Should that SQL above be okay and doing the right thing? Maybe we just > have something set wrong on SQL-Server and it is ignoring the locks? > > #2. Otherwise - I am thinking my best bet is to override the hook in EOF for > primary key generation. > > > Thanks, > > - Mike DeMan > > ___ > 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/peter.vandoros%40gmail.com > > This email sent to peter.vando...@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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
Hi John, I think I go to try this : // Saves all contents tinyMCE.triggerSave(); It may save all WOText Tab bind to tinyMCEs. Le 11 janv. 2012 à 23:35, Raymond NANEON a écrit : > Hi John, > > My titration must be like this ? > > function tinyMCESubmit() { > for (element_Id in tinyMCE.editors) > tinyMCE.editors[element_Id ].save(); > document.form.submit(); > } > > Thanks > > Le 11 janv. 2012 à 23:09, John & Kim Larson a écrit : > >> I'm pretty sure it only saves the "active" editor, but I remember the API >> being pretty good. There is probably tinyMCE.editors or something that >> represents the collection of editors. You could iterate and save. >> >> John >> >> Sent from my iPhone >> >> On Jan 11, 2012, at 4:01 PM, Raymond NANEON wrote: >> >>> Thanks for your reply. >>> >>> >>> I use AjaxTabPanel including 3 WOText bing and each WOText bind to tinyMCE. >>> So the function tinyMCE.activeEditor.save() can save all WOText value at >>> one time or selected WOText tab? If it save selected WOText tab, I have >>> problem. >>> >>> Envoyé depuis iCloud >>> >>> >>> Le 11 janv. 2012 à 22:48, John & Kim Larson a écrit : >>> That's exactly right. Call tinyMCE.activeEditor.save() before making your Ajax request. John Sent from my iPhone On Jan 11, 2012, at 2:12 PM, Johann Werner wrote: > Hi Raymond, > > isn't tinyMCE putting the editable text into an own html element and > catching the form's submit to put back the edited text into the original > input field? Then your problem would be that the AjaxSubmitButton doesn't > trigger the onSubmit event on the form as it will do an ajax request like > its name suggests. So you would have to manually call the necessary > "cleanup" function of tinyMCE from the onClickBefore binding prior > sending of the form contents takes place. But that's just a wild guess. > > jw > > > Am 10.01.2012 um 14:47 schrieb Raymond NANEON: > >> Hi All, >> >> I have a real problem using tinyMCE and CustomAjaxSubmitButton >> (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on >> submitting action, data are always set to null and when I use request >> form field values, there are also null. But When I use the classic >> WOSubmitButton, the request form field value are set. >> >> So, What the problem of AjaxSubmitButton ? What is the difference in >> submitting action between WOSubmitButton and AjaxSubmitButton? >> >> Thanks for your help. >> Envoyé depuis iCloud >> ___ >> 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/jw%40oyosys.de >> >> This email sent to j...@oyosys.de > > ___ > 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/the_larsons%40mac.com > > This email sent to the_lars...@mac.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: > http://lists.apple.com/mailman/options/webobjects-dev/rnaneon%40me.com > > This email sent to rnan...@me.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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
Hi John, My titration must be like this ? function tinyMCESubmit() { for (element_Id in tinyMCE.editors) tinyMCE.editors[element_Id ].save(); document.form.submit(); } Thanks Le 11 janv. 2012 à 23:09, John & Kim Larson a écrit : > I'm pretty sure it only saves the "active" editor, but I remember the API > being pretty good. There is probably tinyMCE.editors or something that > represents the collection of editors. You could iterate and save. > > John > > Sent from my iPhone > > On Jan 11, 2012, at 4:01 PM, Raymond NANEON wrote: > >> Thanks for your reply. >> >> >> I use AjaxTabPanel including 3 WOText bing and each WOText bind to tinyMCE. >> So the function tinyMCE.activeEditor.save() can save all WOText value at one >> time or selected WOText tab? If it save selected WOText tab, I have problem. >> >> Envoyé depuis iCloud >> >> >> Le 11 janv. 2012 à 22:48, John & Kim Larson a écrit : >> >>> That's exactly right. Call tinyMCE.activeEditor.save() before making your >>> Ajax request. >>> >>> John >>> >>> Sent from my iPhone >>> >>> On Jan 11, 2012, at 2:12 PM, Johann Werner wrote: >>> Hi Raymond, isn't tinyMCE putting the editable text into an own html element and catching the form's submit to put back the edited text into the original input field? Then your problem would be that the AjaxSubmitButton doesn't trigger the onSubmit event on the form as it will do an ajax request like its name suggests. So you would have to manually call the necessary "cleanup" function of tinyMCE from the onClickBefore binding prior sending of the form contents takes place. But that's just a wild guess. jw Am 10.01.2012 um 14:47 schrieb Raymond NANEON: > Hi All, > > I have a real problem using tinyMCE and CustomAjaxSubmitButton > (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on > submitting action, data are always set to null and when I use request > form field values, there are also null. But When I use the classic > WOSubmitButton, the request form field value are set. > > So, What the problem of AjaxSubmitButton ? What is the difference in > submitting action between WOSubmitButton and AjaxSubmitButton? > > Thanks for your help. > Envoyé depuis iCloud > ___ > 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/jw%40oyosys.de > > This email sent to j...@oyosys.de ___ 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/the_larsons%40mac.com This email sent to the_lars...@mac.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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
I'm pretty sure it only saves the "active" editor, but I remember the API being pretty good. There is probably tinyMCE.editors or something that represents the collection of editors. You could iterate and save. John Sent from my iPhone On Jan 11, 2012, at 4:01 PM, Raymond NANEON wrote: > Thanks for your reply. > > > I use AjaxTabPanel including 3 WOText bing and each WOText bind to tinyMCE. > So the function tinyMCE.activeEditor.save() can save all WOText value at one > time or selected WOText tab? If it save selected WOText tab, I have problem. > > Envoyé depuis iCloud > > > Le 11 janv. 2012 à 22:48, John & Kim Larson a écrit : > >> That's exactly right. Call tinyMCE.activeEditor.save() before making your >> Ajax request. >> >> John >> >> Sent from my iPhone >> >> On Jan 11, 2012, at 2:12 PM, Johann Werner wrote: >> >>> Hi Raymond, >>> >>> isn't tinyMCE putting the editable text into an own html element and >>> catching the form's submit to put back the edited text into the original >>> input field? Then your problem would be that the AjaxSubmitButton doesn't >>> trigger the onSubmit event on the form as it will do an ajax request like >>> its name suggests. So you would have to manually call the necessary >>> "cleanup" function of tinyMCE from the onClickBefore binding prior sending >>> of the form contents takes place. But that's just a wild guess. >>> >>> jw >>> >>> >>> Am 10.01.2012 um 14:47 schrieb Raymond NANEON: >>> Hi All, I have a real problem using tinyMCE and CustomAjaxSubmitButton (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on submitting action, data are always set to null and when I use request form field values, there are also null. But When I use the classic WOSubmitButton, the request form field value are set. So, What the problem of AjaxSubmitButton ? What is the difference in submitting action between WOSubmitButton and AjaxSubmitButton? Thanks for your help. Envoyé depuis iCloud ___ 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/jw%40oyosys.de This email sent to j...@oyosys.de >>> >>> ___ >>> 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/the_larsons%40mac.com >>> >>> This email sent to the_lars...@mac.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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
Thanks for your reply. I use AjaxTabPanel including 3 WOText bing and each WOText bind to tinyMCE. So the function tinyMCE.activeEditor.save() can save all WOText value at one time or selected WOText tab? If it save selected WOText tab, I have problem. Envoyé depuis iCloud Le 11 janv. 2012 à 22:48, John & Kim Larson a écrit : > That's exactly right. Call tinyMCE.activeEditor.save() before making your > Ajax request. > > John > > Sent from my iPhone > > On Jan 11, 2012, at 2:12 PM, Johann Werner wrote: > >> Hi Raymond, >> >> isn't tinyMCE putting the editable text into an own html element and >> catching the form's submit to put back the edited text into the original >> input field? Then your problem would be that the AjaxSubmitButton doesn't >> trigger the onSubmit event on the form as it will do an ajax request like >> its name suggests. So you would have to manually call the necessary >> "cleanup" function of tinyMCE from the onClickBefore binding prior sending >> of the form contents takes place. But that's just a wild guess. >> >> jw >> >> >> Am 10.01.2012 um 14:47 schrieb Raymond NANEON: >> >>> Hi All, >>> >>> I have a real problem using tinyMCE and CustomAjaxSubmitButton >>> (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on >>> submitting action, data are always set to null and when I use request form >>> field values, there are also null. But When I use the classic >>> WOSubmitButton, the request form field value are set. >>> >>> So, What the problem of AjaxSubmitButton ? What is the difference in >>> submitting action between WOSubmitButton and AjaxSubmitButton? >>> >>> Thanks for your help. >>> Envoyé depuis iCloud >>> ___ >>> 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/jw%40oyosys.de >>> >>> This email sent to j...@oyosys.de >> >> ___ >> 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/the_larsons%40mac.com >> >> This email sent to the_lars...@mac.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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
Also, note that tinyMCE didn't work with iOS before version 5 and it may still not work with Android. (?) That can be really frustrating for your users. I detect the browser and don't load it if it is ios. John Sent from my iPhone On Jan 11, 2012, at 3:48 PM, John & Kim Larson wrote: > That's exactly right. Call tinyMCE.activeEditor.save() before making your > Ajax request. > > John > > Sent from my iPhone > > On Jan 11, 2012, at 2:12 PM, Johann Werner wrote: > >> Hi Raymond, >> >> isn't tinyMCE putting the editable text into an own html element and >> catching the form's submit to put back the edited text into the original >> input field? Then your problem would be that the AjaxSubmitButton doesn't >> trigger the onSubmit event on the form as it will do an ajax request like >> its name suggests. So you would have to manually call the necessary >> "cleanup" function of tinyMCE from the onClickBefore binding prior sending >> of the form contents takes place. But that's just a wild guess. >> >> jw >> >> >> Am 10.01.2012 um 14:47 schrieb Raymond NANEON: >> >>> Hi All, >>> >>> I have a real problem using tinyMCE and CustomAjaxSubmitButton >>> (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on >>> submitting action, data are always set to null and when I use request form >>> field values, there are also null. But When I use the classic >>> WOSubmitButton, the request form field value are set. >>> >>> So, What the problem of AjaxSubmitButton ? What is the difference in >>> submitting action between WOSubmitButton and AjaxSubmitButton? >>> >>> Thanks for your help. >>> Envoyé depuis iCloud >>> ___ >>> 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/jw%40oyosys.de >>> >>> This email sent to j...@oyosys.de >> >> ___ >> 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/the_larsons%40mac.com >> >> This email sent to the_lars...@mac.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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
That's exactly right. Call tinyMCE.activeEditor.save() before making your Ajax request. John Sent from my iPhone On Jan 11, 2012, at 2:12 PM, Johann Werner wrote: > Hi Raymond, > > isn't tinyMCE putting the editable text into an own html element and catching > the form's submit to put back the edited text into the original input field? > Then your problem would be that the AjaxSubmitButton doesn't trigger the > onSubmit event on the form as it will do an ajax request like its name > suggests. So you would have to manually call the necessary "cleanup" function > of tinyMCE from the onClickBefore binding prior sending of the form contents > takes place. But that's just a wild guess. > > jw > > > Am 10.01.2012 um 14:47 schrieb Raymond NANEON: > >> Hi All, >> >> I have a real problem using tinyMCE and CustomAjaxSubmitButton >> (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on >> submitting action, data are always set to null and when I use request form >> field values, there are also null. But When I use the classic >> WOSubmitButton, the request form field value are set. >> >> So, What the problem of AjaxSubmitButton ? What is the difference in >> submitting action between WOSubmitButton and AjaxSubmitButton? >> >> Thanks for your help. >> Envoyé depuis iCloud >> ___ >> 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/jw%40oyosys.de >> >> This email sent to j...@oyosys.de > > ___ > 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/the_larsons%40mac.com > > This email sent to the_lars...@mac.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: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
Hi Johann, Thanks to clarify to me this point. So the ajaxSubmit Button form don't trigger the submit event. Must i create an submit javaScript function and bind it to onClcikBefore attribute? Thanks Raymond NANEON rnan...@me.com Le 11 janv. 2012 à 21:12, Johann Werner a écrit : > Hi Raymond, > > isn't tinyMCE putting the editable text into an own html element and catching > the form's submit to put back the edited text into the original input field? > Then your problem would be that the AjaxSubmitButton doesn't trigger the > onSubmit event on the form as it will do an ajax request like its name > suggests. So you would have to manually call the necessary "cleanup" function > of tinyMCE from the onClickBefore binding prior sending of the form contents > takes place. But that's just a wild guess. > > jw > > > Am 10.01.2012 um 14:47 schrieb Raymond NANEON: > >> Hi All, >> >> I have a real problem using tinyMCE and CustomAjaxSubmitButton >> (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on >> submitting action, data are always set to null and when I use request form >> field values, there are also null. But When I use the classic >> WOSubmitButton, the request form field value are set. >> >> So, What the problem of AjaxSubmitButton ? What is the difference in >> submitting action between WOSubmitButton and AjaxSubmitButton? >> >> Thanks for your help. >> Envoyé depuis iCloud >> ___ >> 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/jw%40oyosys.de >> >> This email sent to j...@oyosys.de > > ___ > 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/naneon.raymond%40neuf.fr > > This email sent to naneon.raym...@neuf.fr ___ 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: Properties, Frameworks and App
James: I don't know if this will be of any use to you but this is how we do it. The following absolutely works if you don't have conflicting connection properties. 1. Put the basics of the connection dictionary in the model framework's resources folder. It might look sth like below. I do not put username/password info in them. I do not want that information in a code repository, etc. ModelName.URL = jdbc:openbase://host/DatabaseName ModelName.DBDriver = com.openbase.jdbc.ObDriver ModelName.DBPlugin = OpenBasePlugIn 2. For dev purposes, put any overrides of those in Properties.username in the app resources so that you can point your dev instance at a different database sth like: GSEISDB.URL= jdbc:openbase://127.0.0.1/LocalDatabaseName The others properties stay the same if you're using the same database, driver, plugin. 3. handling username/password in dev: Keep dev username/pass values out of your project by putting those in this properties file: ~/WebObjects.properties in deployment: Put the username/pass connection properties in /etc/WebObjects/AppName/Properties on the server that the app is running on. Tim Worman UCLA GSE&IS On Jan 10, 2012, at 5:58 PM, James Cicenia wrote: > If I have a model in a Framework, what controls it's connection configuration? > > I thought the properties file in the App would, but it looks like it doesn't. > It barks > about ERAttachment's configuration vs. the apps. If I put the connection info > in the Model Frameworks's properties file, it runs... sort of. But now I get > this > kind of exception on startup: > > setting traceOpenLocks to false > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.eof.ERXEC$DefaultFactory - Setting default delegate on editing > context: er.extensions.eof.ERXEC@4a4854f6 allows validation: true > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - setting > delegate to er.extensions.eof.ERXDefaultEditingContextDelegate@d054f93 > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > at er.extensions.eof.ERXEC.setDelegate(ERXEC.java:1469) > at > er.extensions.eof.ERXEC$DefaultFactory.setDefaultDelegateOnEditingContext(ERXEC.java:1563) > at > er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1618) > at > er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1589) > at er.extensions.eof.ERXEC.newEditingContext(ERXEC.java:1681) > at > er.extensions.jdbc.ERXJDBCUtilities.databaseProductName(ERXJDBCUtilities.java:826) > at > er.extensions.migration.ERXMigrator._buildDependenciesForModel(ERXMigrator.java:352) > at > er.extensions.migration.ERXMigrator._buildDependenciesForModelsNamed(ERXMigrator.java:275) > at > er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:184) > at > er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1128) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122) > at > com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod(NSNotificationCenter.java:588) > at > com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:532) > at > com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:546) > at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229) > at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1241) > at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) > at er.extensions.appserver.ERXApplication.main(ERXApplication.java:726) > at com.jimijon.blessings.app.Application.main(Application.java:16) > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.eof.ERXEC$DefaultFactory - setting useSharedEditingContext to > false > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - setting > useUnlocker to true > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - After > pushing: [er.extensions.eof.ERXEC@4a4854f6] > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.ERXEC.LockLogger - > locked er.extensions.eof.ERXEC@4a4854f6 > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.localization.ERXLocalizer - FrameworkSearchPath: ("app", > "ERJars", "ERPrototypes", "ERModernLook", "ERModernDefaultSkin", > "ERModernDirectToWeb", "JavaWOExtensions", "Ajax", "ModelBlessings", > "ERAttachment", "MySQLPlugIn", "ERDirectToRest", "ExcelGenerator", > "ERExcelLook", "ERRest", "WOLips", "JavaDTWGeneration", "JavaDirectToWeb", > "JavaFoundation", "
Re: TinyMCE and AjaxSubmitButton (field values allways set to null)
Hi Raymond, isn't tinyMCE putting the editable text into an own html element and catching the form's submit to put back the edited text into the original input field? Then your problem would be that the AjaxSubmitButton doesn't trigger the onSubmit event on the form as it will do an ajax request like its name suggests. So you would have to manually call the necessary "cleanup" function of tinyMCE from the onClickBefore binding prior sending of the form contents takes place. But that's just a wild guess. jw Am 10.01.2012 um 14:47 schrieb Raymond NANEON: > Hi All, > > I have a real problem using tinyMCE and CustomAjaxSubmitButton > (ajaxSubmitButton with icon (add, cancel, delete)). The problem is on > submitting action, data are always set to null and when I use request form > field values, there are also null. But When I use the classic WOSubmitButton, > the request form field value are set. > > So, What the problem of AjaxSubmitButton ? What is the difference in > submitting action between WOSubmitButton and AjaxSubmitButton? > > Thanks for your help. > Envoyé depuis iCloud > ___ > 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/jw%40oyosys.de > > This email sent to j...@oyosys.de ___ 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
WO 5.3.3 / SQL-Server and primary key generation
Hi All, I have a legacy 5.3.3 application that we need to scale up to multiple instances. It is a pretty big, old and fragile code base - wonderizing it does not seem to be an option. I reviewed the code and the use cases are separate enough that there is no need for full inter-app EO change notifications - except for primary key generation. On the primary key generation, I noticed that the SQL being generated is like the below and was thinking that with that UPDLOCK and ROWLOCK on the EO_PK_TABLE, that it might 'just work'. However, in testing, I was able to get cases where different application instances were colliding on trying to use the same primary key value. [2012-01-07 12:29:35 EST] evaluateExpression: [2012-01-07 12:29:35 EST] evaluateExpression: I am unsure how to proceed and was hoping somebody might be able to give me some pointers. #1. Should that SQL above be okay and doing the right thing? Maybe we just have something set wrong on SQL-Server and it is ignoring the locks? #2. Otherwise - I am thinking my best bet is to override the hook in EOF for primary key generation. Thanks, - Mike DeMan ___ 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: updateValuesInRowDescribedByQualifier fail. ??
What is the exact error now? ___ 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: updateValuesInRowDescribedByQualifier fail. ??
OK - I combed through my model. Made everything in the one properties file, learned about framework model precedences and still have this problem on one my entities? Any ideas out there Wonder/WO gurus? Thanks James On Jan 10, 2012, at 11:00 AM, Ruenagel, Frank wrote: > Hi there, > > EOGeneralAdaptorExceptions in my apps typically are optimistic locking > exceptions. > Please check whether the record in the db was changed > by another app or manually via SQL (after the EO was fetched by your WO-App). > > If this is not the case and you can reproduce the error, you may try to get > the userInfo dictionary of the error similar to: > > catch (EOGeneralAdaptorException e) > { > String eType = > (String)e.userInfo().objectForKey(EOAdaptorChannel.AdaptorFailureKey); > if > (EOAdaptorChannel.AdaptorOptimisticLockingFailure.equals(eType)) > > > Regards > Frank > > > Von: webobjects-dev-bounces+webobjects=symposion...@lists.apple.com > [mailto:webobjects-dev-bounces+webobjects=symposion...@lists.apple.com] Im > Auftrag von James Cicenia > Bereitgestellt: Dienstag, 10. Januar 2012 14:24 > Bereitgestellt in: WebObjects > Unterhaltung: updateValuesInRowDescribedByQualifier fail. > Betreff: updateValuesInRowDescribedByQualifier fail. > > This is on my new D2WModernLook app. > > The app has been working great. I just added a many-to-many. Now when I go to > edit, create and then save I get an error like follow: > > I have neve seen this type of error... Though these are all my new wonder > apps... > > > > "EOFailedDatabaseOperationKey" = "{_dbSnapshot = {addDate = 2012-01-09 > 06:00:00 Etc/GMT; authorID = 4; category_id = 4; description = > ; fullQuote = \"Love is > swift, sincere, pious, joyful, generous, strong, patient, faithful, prudent, > long-suffering, courageous, and never seeking its own; for wheresoever a > person seeketh his own, there he falleth from love.\"; id = 3; isNew = false; > mainImageId = ; modDate = > 2012-01-09 06:00:00 Etc/GMT; publish = false; thumbnailImageId = > ; title = \"Love\"; }; > _entity = \"Quotation\"; _newRow = {addDate = 2012-01-09 06:00:00 Etc/GMT; > authorID = 4; category_id = 4; description = > ; fullQuote = \"Love is > swift, sincere, pious, joyful, generous, strong, patient, faithful, prudent, > long-suffering, courageous, and never seeking its own; for wheresoever a > person seeketh his own, there he falleth from love.\"; id = 3; isNew = > false; mainImageId = ; > modDate = 2012-01-10 03:47:57 Etc/GMT; publish = false; thumbnailImageId = > ; title = \"Love\"; }; > _object = \"\"; _adaptorOps = > ({_qualifier = \"((id = 3) and (authorID = 4) and (category_id = 4) and > (description = null) and (fullQuote = 'Love is swift, sincere, pious, joyful, > generous, strong, patient, faithful, prudent, long-suffering, courageous, and > never seeking its own; for wheresoever a person seeketh his own, there he > falleth from love.') and (isNew = (java.lang.Boolean)'false') and > (mainImageId = null) and (publish = (java.lang.Boolean)'false') and > (thumbnailImageId = null) and (title = 'Love'))\"; _adaptorOperator = > \"EOAdaptorUpdateOperator\"; _entity = \"Quotation\"; _exception = > com.webobjects.eoaccess.EOGeneralAdaptorException: > updateValuesInRowDescribedByQualifier -- > com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in > database; _changedValues = {modDate = 2012-01-10 03:47:57 Etc/GMT; fullQuote > = \"Love is swift, sincere, pious, joyful, generous, strong, patient, > faithful, prudent, long-suffering, courageous, and never seeking its own; for > wheresoever a person seeketh his own, there he falleth from love.\"; }; > }); _globalID = _EOIntegralKeyGlobalID[Quotation (java.lang.Integer)3]; > _databaseOperator = \"EODatabaseUpdateOperator\"; }"; > } > > EOGeneralAdaptorException: updateValuesInRowDescribedByQualifier -- > com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in database > at > com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504) > ... skipped 1 stack elements > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) > at > com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192) > at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1085) > at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1007) > at > er.directtoweb.pages.ERD2WInspectPage.tryToSaveChanges(ERD2WInspectPage.java:217) > at > er.directtoweb.pages.ERD2WInspectPage.submitAction(ERD2WInspectPage.java:263) > at > er.modern.look.pages.ERMODInspectPage.submitAction(ERMODInspectPage.java:95) > ... skipped 112 stack elements > Jan 09 21:47:58 BlessingsApp[6789] DEBUG > er.extensions.components._private.ERXWOR
Re: Properties, Frameworks and App
Ok - I got rid of the other properties file. Just put the two, Properties and Properties.james files in my app. Deleted the connection dictionary out of the ERAttachments model. And now it seems to work. Thanks James On Jan 11, 2012, at 9:19 AM, Pau Yu wrote: > James > > You may want to remove or comment out the connection dictionaries from > everywhere other than the place you want it, i.e. in your application > Properties or your Properties.james file. > > Paul > > > -- > Pau Yu > Sent with Sparrow > > On Wednesday, January 11, 2012 at 10:12 AM, John Huss wrote: > >> Try printing out both dictionaries and look to see how they are different. >> >> On Wed, Jan 11, 2012 at 8:31 AM, James Cicenia wrote: >>> Now I am all confused ( I know, I know). >>> >>> If I just put the Global DB info in my App properties file, Wonder >>> complains: >>> >>> IllegalArgumentException: The connection dictionaries for ERAttachment and >>> BlessingsAndToasts have the same URL and username, but the connection >>> dictionaries are not equal. Check your connection dictionaries carefully! >>> This problem is often caused by jdbc2Info not matching between the two. >>> One fix for this is to set ERAttachment.removeJdbc2Info=true and >>> BlessingsAndToasts.removeJdbc2Info=true in your Properties file. >>> >>> So, I do as it says. Same exception. >>> >>> This is my first application with the Model in a separate framework. All my >>> other apps had the model included so I have never seen this issue. >>> >>> Thanks >>> James >>> >>> >>> >>> >>> On Jan 11, 2012, at 4:02 AM, Amedeo Mantica wrote: >>> why not in your app properties ? On 11/gen/2012, at 02:58, James Cicenia wrote: > If I have a model in a Framework, what controls it's connection > configuration? > > I thought the properties file in the App would, but it looks like it > doesn't. It barks > about ERAttachment's configuration vs. the apps. If I put the connection > info > in the Model Frameworks's properties file, it runs... sort of. But now I > get this > kind of exception on startup: > > setting traceOpenLocks to false > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.eof.ERXEC$DefaultFactory - Setting default delegate on > editing context: er.extensions.eof.ERXEC@4a4854f6 allows validation: true > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > setting delegate to > er.extensions.eof.ERXDefaultEditingContextDelegate@d054f93 > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > at er.extensions.eof.ERXEC.setDelegate(ERXEC.java:1469) > at > er.extensions.eof.ERXEC$DefaultFactory.setDefaultDelegateOnEditingContext(ERXEC.java:1563) > at > er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1618) > at > er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1589) > at er.extensions.eof.ERXEC.newEditingContext(ERXEC.java:1681) > at > er.extensions.jdbc.ERXJDBCUtilities.databaseProductName(ERXJDBCUtilities.java:826) > at > er.extensions.migration.ERXMigrator._buildDependenciesForModel(ERXMigrator.java:352) > at > er.extensions.migration.ERXMigrator._buildDependenciesForModelsNamed(ERXMigrator.java:275) > at > er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:184) > at > er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1128) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122) > at > com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod(NSNotificationCenter.java:588) > at > com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:532) > at > com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:546) > at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229) > at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1241) > at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) > at er.extensions.appserver.ERXApplication.main(ERXApplication.java:726) > at com.jimijon.blessings.app.Application.main(Application.java:16) > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.eof.ERXEC$DefaultFactory - setting useSharedEditingContext > to false > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > settin
Re: Properties, Frameworks and App
James You may want to remove or comment out the connection dictionaries from everywhere other than the place you want it, i.e. in your application Properties or your Properties.james file. Paul -- Pau Yu Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Wednesday, January 11, 2012 at 10:12 AM, John Huss wrote: > Try printing out both dictionaries and look to see how they are different. > > On Wed, Jan 11, 2012 at 8:31 AM, James Cicenia (mailto:ja...@jimijon.com)> wrote: > > Now I am all confused ( I know, I know). > > > > If I just put the Global DB info in my App properties file, Wonder > > complains: > > > > IllegalArgumentException: The connection dictionaries for ERAttachment and > > BlessingsAndToasts have the same URL and username, but the connection > > dictionaries are not equal. Check your connection dictionaries carefully! > > This problem is often caused by jdbc2Info not matching between the two. > > One fix for this is to set ERAttachment.removeJdbc2Info=true and > > BlessingsAndToasts.removeJdbc2Info=true in your Properties file. > > > > So, I do as it says. Same exception. > > > > This is my first application with the Model in a separate framework. All my > > other apps had the model included so I have never seen this issue. > > > > Thanks > > James > > > > > > > > > > On Jan 11, 2012, at 4:02 AM, Amedeo Mantica wrote: > > > why not in your app properties ? > > > > > > > > > > > > On 11/gen/2012, at 02:58, James Cicenia wrote: > > > > If I have a model in a Framework, what controls it's connection > > > > configuration? > > > > > > > > I thought the properties file in the App would, but it looks like it > > > > doesn't. It barks > > > > about ERAttachment's configuration vs. the apps. If I put the > > > > connection info > > > > in the Model Frameworks's properties file, it runs... sort of. But now > > > > I get this > > > > kind of exception on startup: > > > > > > > > setting traceOpenLocks to false > > > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > > > > er.extensions.eof.ERXEC$DefaultFactory - Setting default delegate on > > > > editing context: er.extensions.eof.ERXEC@4a4854f6 allows validation: > > > > true > > > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > > > > setting delegate to > > > > er.extensions.eof.ERXDefaultEditingContextDelegate@d054f93 > > > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > > > > at er.extensions.eof.ERXEC.setDelegate(ERXEC.java:1469) > > > > at > > > > er.extensions.eof.ERXEC$DefaultFactory.setDefaultDelegateOnEditingContext(ERXEC.java:1563) > > > > at > > > > er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1618) > > > > at > > > > er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1589) > > > > at er.extensions.eof.ERXEC.newEditingContext(ERXEC.java:1681) > > > > at > > > > er.extensions.jdbc.ERXJDBCUtilities.databaseProductName(ERXJDBCUtilities.java:826) > > > > at > > > > er.extensions.migration.ERXMigrator._buildDependenciesForModel(ERXMigrator.java:352) > > > > at > > > > er.extensions.migration.ERXMigrator._buildDependenciesForModelsNamed(ERXMigrator.java:275) > > > > at > > > > er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:184) > > > > at > > > > er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1128) > > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > > at > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > > > at > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > > > at java.lang.reflect.Method.invoke(Method.java:597) > > > > at > > > > com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122) > > > > at > > > > com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod(NSNotificationCenter.java:588) > > > > at > > > > com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:532) > > > > at > > > > com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:546) > > > > at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229) > > > > at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1241) > > > > at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) > > > > at er.extensions.appserver.ERXApplication.main(ERXApplication.java:726) > > > > at com.jimijon.blessings.app.Application.main(Application.java:16) > > > > > > > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > > > > er.extensions.eof.ERXEC$DefaultFactory - setting > > > > useSharedEditingContext to false > > > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > > > > setting useUnlocker to true > > > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > > > > After pushing: [er.extensions.eof.ERXEC@4a
Re: Properties, Frameworks and App
Hi James, We did differently (maybe for this reason but I don't remember and it works from the beginning so you know…). We have a connection dic per framework: ERAttachment.URL=jdbc:mysql://databasehosting/ynp?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8 ERAttachment.DBUser=user ERAttachment.DBPassword=password ERAttachment.DBDriver=org.gjt.mm.mysql.Driver NOBusiness.URL=jdbc:mysql://databasehosting/ynp?capitalizeTypenames=true&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8 NOBusiness.DBUser=user NOBusiness.DBPassword=password NOBusiness.DBDriver=org.gjt.mm.mysql.Driver Philippe On 11 janv. 2012, at 15:31, James Cicenia wrote: > Now I am all confused ( I know, I know). > > If I just put the Global DB info in my App properties file, Wonder complains: > > IllegalArgumentException: The connection dictionaries for ERAttachment and > BlessingsAndToasts have the same URL and username, but the connection > dictionaries are not equal. Check your connection dictionaries carefully! > This problem is often caused by jdbc2Info not matching between the two. One > fix for this is to set ERAttachment.removeJdbc2Info=true and > BlessingsAndToasts.removeJdbc2Info=true in your Properties file. > > So, I do as it says. Same exception. > > This is my first application with the Model in a separate framework. All my > other apps had the model included so I have never seen this issue. > > Thanks > James > > > > > On Jan 11, 2012, at 4:02 AM, Amedeo Mantica wrote: > >> why not in your app properties ? >> >> >> >> On 11/gen/2012, at 02:58, James Cicenia wrote: >> >>> If I have a model in a Framework, what controls it's connection >>> configuration? >>> >>> I thought the properties file in the App would, but it looks like it >>> doesn't. It barks >>> about ERAttachment's configuration vs. the apps. If I put the connection >>> info >>> in the Model Frameworks's properties file, it runs... sort of. But now I >>> get this >>> kind of exception on startup: >>> >>> setting traceOpenLocks to false >>> Jan 10 19:53:00 BlessingsApp[6789] DEBUG >>> er.extensions.eof.ERXEC$DefaultFactory - Setting default delegate on >>> editing context: er.extensions.eof.ERXEC@4a4854f6 allows validation: true >>> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - setting >>> delegate to er.extensions.eof.ERXDefaultEditingContextDelegate@d054f93 >>> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - >>> at er.extensions.eof.ERXEC.setDelegate(ERXEC.java:1469) >>> at >>> er.extensions.eof.ERXEC$DefaultFactory.setDefaultDelegateOnEditingContext(ERXEC.java:1563) >>> at >>> er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1618) >>> at >>> er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1589) >>> at er.extensions.eof.ERXEC.newEditingContext(ERXEC.java:1681) >>> at >>> er.extensions.jdbc.ERXJDBCUtilities.databaseProductName(ERXJDBCUtilities.java:826) >>> at >>> er.extensions.migration.ERXMigrator._buildDependenciesForModel(ERXMigrator.java:352) >>> at >>> er.extensions.migration.ERXMigrator._buildDependenciesForModelsNamed(ERXMigrator.java:275) >>> at >>> er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:184) >>> at >>> er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1128) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122) >>> at >>> com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod(NSNotificationCenter.java:588) >>> at >>> com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:532) >>> at >>> com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:546) >>> at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229) >>> at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1241) >>> at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) >>> at er.extensions.appserver.ERXApplication.main(ERXApplication.java:726) >>> at com.jimijon.blessings.app.Application.main(Application.java:16) >>> >>> Jan 10 19:53:00 BlessingsApp[6789] DEBUG >>> er.extensions.eof.ERXEC$DefaultFactory - setting useSharedEditingContext >>> to false >>> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - setting >>> useUnlocker to true >>> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - After >>> pushing: [er.extensions.eof.ERXEC@4a4854f6] >>> Ja
Re: Properties, Frameworks and App
Try printing out both dictionaries and look to see how they are different. On Wed, Jan 11, 2012 at 8:31 AM, James Cicenia wrote: > Now I am all confused ( I know, I know). > > If I just put the Global DB info in my App properties file, Wonder > complains: > > IllegalArgumentException: The connection dictionaries for ERAttachment > and BlessingsAndToasts have the same URL and username, but the connection > dictionaries are not equal. Check your connection dictionaries carefully! > This problem is often caused by jdbc2Info not matching between the two. > One fix for this is to set ERAttachment.removeJdbc2Info=true and > BlessingsAndToasts.removeJdbc2Info=true in your Properties file. > > So, I do as it says. Same exception. > > This is my first application with the Model in a separate framework. All > my other apps had the model included so I have never seen this issue. > > Thanks > James > > > > > On Jan 11, 2012, at 4:02 AM, Amedeo Mantica wrote: > > why not in your app properties ? > > > > On 11/gen/2012, at 02:58, James Cicenia wrote: > > If I have a model in a Framework, what controls it's connection > configuration? > > I thought the properties file in the App would, but it looks like it > doesn't. It barks > about ERAttachment's configuration vs. the apps. If I put the connection > info > in the Model Frameworks's properties file, it runs... sort of. But now I > get this > kind of exception on startup: > > setting traceOpenLocks to false > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.eof.ERXEC$DefaultFactory - Setting default delegate on > editing context: er.extensions.eof.ERXEC@4a4854f6 allows validation: true > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > setting delegate to > er.extensions.eof.ERXDefaultEditingContextDelegate@d054f93 > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > at er.extensions.eof.ERXEC.setDelegate(ERXEC.java:1469) > at > er.extensions.eof.ERXEC$DefaultFactory.setDefaultDelegateOnEditingContext( > ERXEC.java:1563) > at er.extensions.eof.ERXEC$DefaultFactory._newEditingContext( > ERXEC.java:1618) > at er.extensions.eof.ERXEC$DefaultFactory._newEditingContext( > ERXEC.java:1589) > at er.extensions.eof.ERXEC.newEditingContext(ERXEC.java:1681) > at er.extensions.jdbc.ERXJDBCUtilities.databaseProductName( > ERXJDBCUtilities.java:826) > at er.extensions.migration.ERXMigrator._buildDependenciesForModel( > ERXMigrator.java:352) > at er.extensions.migration.ERXMigrator._buildDependenciesForModelsNamed( > ERXMigrator.java:275) > at er.extensions.migration.ERXMigrator.migrateToLatest( > ERXMigrator.java:184) > at er.extensions.appserver.ERXApplication.finishInitialization( > ERXApplication.java:1128) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at com.webobjects.foundation.NSSelector._safeInvokeMethod( > NSSelector.java:122) > at com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod( > NSNotificationCenter.java:588) > at com.webobjects.foundation.NSNotificationCenter.postNotification( > NSNotificationCenter.java:532) > at com.webobjects.foundation.NSNotificationCenter.postNotification( > NSNotificationCenter.java:546) > at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229) > at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1241) > at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) > at er.extensions.appserver.ERXApplication.main(ERXApplication.java:726) > at com.jimijon.blessings.app.Application.main(Application.java:16) > > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.eof.ERXEC$DefaultFactory - setting useSharedEditingContext > to false > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - > setting useUnlocker to true > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - After > pushing: [er.extensions.eof.ERXEC@4a4854f6] > Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.ERXEC.LockLogger - > locked er.extensions.eof.ERXEC@4a4854f6 > Jan 10 19:53:00 BlessingsApp[6789] DEBUG > er.extensions.localization.ERXLocalizer - FrameworkSearchPath: ("app", > "ERJars", "ERPrototypes", "ERModernLook", "ERModernDefaultSkin", > "ERModernDirectToWeb", "JavaWOExtensions", "Ajax", "ModelBlessings", > "ERAttachment", "MySQLPlugIn", "ERDirectToRest", "ExcelGenerator", > "ERExcelLook", "ERRest", "WOLips", "JavaDTWGeneration", "JavaDirectToWeb", > "JavaFoundation", "JavaXML", "JavaJDBCAdaptor", "JavaWebObjects", > "JavaEOAccess", "JavaEOControl", "JavaEOProject", "ERDirectToWeb", > "ERExtensions") > Exception > at er.extensions.eof.ERXEC.lock(ERXEC.java:513) > at er.extensions.eof.ERXEC$DefaultFactory._newEditingContext( > ERXEC.java:1620) > at er.extensions.eof.ERXEC
Re: Properties, Frameworks and App
Now I am all confused ( I know, I know). If I just put the Global DB info in my App properties file, Wonder complains: IllegalArgumentException: The connection dictionaries for ERAttachment and BlessingsAndToasts have the same URL and username, but the connection dictionaries are not equal. Check your connection dictionaries carefully! This problem is often caused by jdbc2Info not matching between the two. One fix for this is to set ERAttachment.removeJdbc2Info=true and BlessingsAndToasts.removeJdbc2Info=true in your Properties file. So, I do as it says. Same exception. This is my first application with the Model in a separate framework. All my other apps had the model included so I have never seen this issue. Thanks James On Jan 11, 2012, at 4:02 AM, Amedeo Mantica wrote: > why not in your app properties ? > > > > On 11/gen/2012, at 02:58, James Cicenia wrote: > >> If I have a model in a Framework, what controls it's connection >> configuration? >> >> I thought the properties file in the App would, but it looks like it >> doesn't. It barks >> about ERAttachment's configuration vs. the apps. If I put the connection info >> in the Model Frameworks's properties file, it runs... sort of. But now I get >> this >> kind of exception on startup: >> >> setting traceOpenLocks to false >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG >> er.extensions.eof.ERXEC$DefaultFactory - Setting default delegate on >> editing context: er.extensions.eof.ERXEC@4a4854f6 allows validation: true >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - setting >> delegate to er.extensions.eof.ERXDefaultEditingContextDelegate@d054f93 >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - >> at er.extensions.eof.ERXEC.setDelegate(ERXEC.java:1469) >> at >> er.extensions.eof.ERXEC$DefaultFactory.setDefaultDelegateOnEditingContext(ERXEC.java:1563) >> at >> er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1618) >> at >> er.extensions.eof.ERXEC$DefaultFactory._newEditingContext(ERXEC.java:1589) >> at er.extensions.eof.ERXEC.newEditingContext(ERXEC.java:1681) >> at >> er.extensions.jdbc.ERXJDBCUtilities.databaseProductName(ERXJDBCUtilities.java:826) >> at >> er.extensions.migration.ERXMigrator._buildDependenciesForModel(ERXMigrator.java:352) >> at >> er.extensions.migration.ERXMigrator._buildDependenciesForModelsNamed(ERXMigrator.java:275) >> at >> er.extensions.migration.ERXMigrator.migrateToLatest(ERXMigrator.java:184) >> at >> er.extensions.appserver.ERXApplication.finishInitialization(ERXApplication.java:1128) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at >> com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122) >> at >> com.webobjects.foundation.NSNotificationCenter$_Entry.invokeMethod(NSNotificationCenter.java:588) >> at >> com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:532) >> at >> com.webobjects.foundation.NSNotificationCenter.postNotification(NSNotificationCenter.java:546) >> at com.webobjects.appserver.WOApplication.run(WOApplication.java:1229) >> at er.extensions.appserver.ERXApplication.run(ERXApplication.java:1241) >> at com.webobjects.appserver.WOApplication.main(WOApplication.java:548) >> at er.extensions.appserver.ERXApplication.main(ERXApplication.java:726) >> at com.jimijon.blessings.app.Application.main(Application.java:16) >> >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG >> er.extensions.eof.ERXEC$DefaultFactory - setting useSharedEditingContext to >> false >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - setting >> useUnlocker to true >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.eof.ERXEC - After >> pushing: [er.extensions.eof.ERXEC@4a4854f6] >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG er.extensions.ERXEC.LockLogger - >> locked er.extensions.eof.ERXEC@4a4854f6 >> Jan 10 19:53:00 BlessingsApp[6789] DEBUG >> er.extensions.localization.ERXLocalizer - FrameworkSearchPath: ("app", >> "ERJars", "ERPrototypes", "ERModernLook", "ERModernDefaultSkin", >> "ERModernDirectToWeb", "JavaWOExtensions", "Ajax", "ModelBlessings", >> "ERAttachment", "MySQLPlugIn", "ERDirectToRest", "ExcelGenerator", >> "ERExcelLook", "ERRest", "WOLips", "JavaDTWGeneration", "JavaDirectToWeb", >> "JavaFoundation", "JavaXML", "JavaJDBCAdaptor", "JavaWebObjects", >> "JavaEOAccess", "JavaEOControl", "JavaEOProject", "ERDirectToWeb", >> "ERExtensions") >> Exception >> at er.extensions.eof.ERXEC.lock(ERXEC.java:513) >> at >> er.extensions.eof.ERXEC$DefaultFactory._newEditingContex