Re: Multi-Tenant Data Architecture

2009-09-22 Thread Cheong Hee (Gmail)
I read with great interest as I encountere the same situation some time ago. In practice (at least in my case), it worked to have the app run on separate EOF stacks accessing different database. So , it simplified the case to only have one instance in JavaMonitor for multi databases. However,

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Andrew Lindesay
Hi; I've done two reasonably complex "multi-tenant" systems which are now seven and five years in production. Both are running out of unified models and I haven't heard of any issues around data authorisation issues. cheers. I did something like this a while ago and it was actually pretty

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Lachlan Deck
On 23/09/2009, at 8:46 AM, Henrique Prange wrote: Chuck Hill wrote: - problems / load on one tenant do not impact others - guaranteed that one tenant will not accidently see information from another This last one is exactly the reason why we can't have a shared database at all. This is w

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Guido Neitzer
On Sep 22, 2009, at 4:34 PM, Chuck Hill wrote: - some increase in RAM usage due to duplicated loading of code and JVM If you don't want to do that and are committed to doing this in one instance, the next best way is to tag the root object with the tenant. But you said "separate databases"

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Chuck Hill
On Sep 22, 2009, at 4:27 PM, Ramsey Lee Gurley wrote: On Sep 22, 2009, at 2:05 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:57 AM, David Avendasora wrote: On Sep 22, 2009, at 12:19 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: On Sep 22, 2009, at 11:29 AM, Freddie

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Chuck Hill
Hi Henrique, On Sep 22, 2009, at 3:46 PM, Henrique Prange wrote: Hi Chuck, Chuck Hill wrote: The easiest, and perhaps best, way to do this is to have different instances for each tenant. The configuration (in JavaMonitor or elsewhere) can then specify the database. That is our current

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Ramsey Lee Gurley
On Sep 22, 2009, at 2:05 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:57 AM, David Avendasora wrote: On Sep 22, 2009, at 12:19 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: On Sep 22, 2009, at 11:29 AM, Freddie Tilley wrote: Value class of type NSNumber doe

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Henrique Prange
Hi Denis, Thank you very much, Denis. I haven't found this thread while googling by the subject. The Eugene e-mail has exactly what I need... Sample code. :) Cheers, Henrique Denis Frolov wrote: Hi Henrique, This thread may be of interest: http://lists.apple.com/archives/webobjects-dev//20

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Henrique Prange
Hi Chuck, Chuck Hill wrote: The easiest, and perhaps best, way to do this is to have different instances for each tenant. The configuration (in JavaMonitor or elsewhere) can then specify the database. That is our current way to deploy the application. Pros: - easy Not so easy when yo

Re: Very interesting case

2009-09-22 Thread John & Kim Larson
I've been following your thread and will throw this out at you. I write a lot of components that have to broken up into different forms for layout and continuity purposes, just like you are if you're using a batch nav bar. It is quite a pain to have submit buttons all over the place. Using

Re: Very interesting case

2009-09-22 Thread Chuck Hill
On Sep 22, 2009, at 12:23 PM, Don Lindsay wrote: It is using the WONavigationBar component from WOExtensions. It is a hyperlink, inside that control. That would leave you (rhyme with duct). That works fine to navigation, but does not handle data submission. The answer is, of cours

Re: Very interesting case

2009-09-22 Thread Don Lindsay
It is using the WONavigationBar component from WOExtensions. It is a hyperlink, inside that control. Don On Sep 22, 2009, at 12:22 PM, Chuck Hill wrote: On Sep 22, 2009, at 2:32 AM, Don Lindsay wrote: Hello; I have a displayGroup displaying batches of 5 items per page. When a user cli

[Reminder] The surveys

2009-09-22 Thread Pascal Robert
Hi guys, Don't forget the annual surveys (I really do hope that we are not down to 53 organizations, right?). The organization survey ; http://www.survs.com/survey?id=CRDU8UY3&channel=T8TGXAW70R The individual : http://www.survs.com/survey?id=21MIN2X6&channel=3O47WI4G11 WO

AjaxInPlace

2009-09-22 Thread Francesco Romano
Hi.. I'm using an AjaxInPlace component. I'd like to perform a validation. I bound the ajaxinplace with a saveaction. But... even if my "validation" fails, the edit template switch to the view template. I'd like to stay in the edit mode until either the user presses cancel or the validation i

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread David Avendasora
On Sep 22, 2009, at 2:05 PM, Chuck Hill wrote: Here's my custom Prototype: Here's my attribute that implements the Boolean prototype: Not sure why that works and not inclined to dig into it right now. Agreed. Dave ___ Do not post admin reques

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Chuck Hill
On Sep 22, 2009, at 9:57 AM, David Avendasora wrote: On Sep 22, 2009, at 12:19 PM, Chuck Hill wrote: On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: On Sep 22, 2009, at 11:29 AM, Freddie Tilley wrote: Value class of type NSNumber does not work for me, using a value class of java.

Re: Very interesting case

2009-09-22 Thread Chuck Hill
On Sep 22, 2009, at 2:32 AM, Don Lindsay wrote: Hello; I have a displayGroup displaying batches of 5 items per page. When a user clicks the next page, What is "clicks the next page"? If it is a WOHyperlink then the form values will not get submitted. You need to use a WOSubmitButton

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Chuck Hill
On Sep 22, 2009, at 9:07 AM, David Avendasora wrote: On Sep 22, 2009, at 11:29 AM, Freddie Tilley wrote: Value class of type NSNumber does not work for me, using a value class of java.lang.Boolean does. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but

Re: writing to nfs mounts

2009-09-22 Thread Chuck Hill
On Sep 22, 2009, at 7:43 AM, Gordon Belray wrote: Hey, we're having trouble writing to nfs mounts from within WebObjects. Even if we change ownership to appserver, it isn't writing. drwxrwxrwx 9 _appserver 100 4096 Sep 21 15:15 media drwxrwxrwx 2 _appserver 100

Re: Rewrite Rule

2009-09-22 Thread Guido Neitzer
So, if you're going through apache and you have the two patterns set and not commented, it should rewrite. Make sure there is no space or so at the end of the pattern. Also, make sure you're running with the ERXWOContext54 in your classpath if you are using WO 5.4. Set a breakpoint in _rewr

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread David Avendasora
On Sep 22, 2009, at 11:29 AM, Freddie Tilley wrote: Value class of type NSNumber does not work for me, using a value class of java.lang.Boolean does. Interesting. It is odd to have a ValueType of c with a ValueClass of NSNumber... but it's working for me. Okay, Chuck, here's where you put

Re: DirectAction with cookies and session

2009-09-22 Thread Fred Wells
Doh! I needed to add the session id through SWFUpload post params not through directActionURLForActionNamed's query dictionary. thanks. -fw Chuck Hill 09/21/2009 09:53 PM To Fred Wells cc webobjects-dev@lists.apple.com Subject Re: DirectAction with cookies and session On Sep 21,

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Freddie Tilley
Value class of type NSNumber does not work for me, using a value class of java.lang.Boolean does. Thanks! 2009/9/22 David Avendasora : > Okay, let's try it completely manually. > Here's what I have setup in one of my custom Prototypes for MS SQL Server: > External Type: bit > Class: java.lang.Boo

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread David Avendasora
Okay, let's try it completely manually. Here's what I have setup in one of my custom Prototypes for MS SQL Server: External Type: bit Class: java.lang.Boolean Data Type: Custom - Custom External Width: Value Class: NSNumber Value Type: c Factory Method: ConversionMethod: Init Argument: These

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Freddie Tilley
This will give me class cast errors java.lang.Short cannot be cast to java.lang.Boolean 2009/9/22 David Avendasora : > That prototype doesn't do what you think it does. That will convert the > boolean value true to the string "true" and and false to "false" which > obviously won't save into a bi

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread David Avendasora
On Sep 22, 2009, at 10:39 AM, David Avendasora wrote: I think there is a bug in Entity Modeler that doesn't properly update the external type when changing to "intBoolean". And yes, I'll finally create a Jira ticket for this. :-) Dave ___ Do not

writing to nfs mounts

2009-09-22 Thread Gordon Belray
Hey, we're having trouble writing to nfs mounts from within WebObjects. Even if we change ownership to appserver, it isn't writing. drwxrwxrwx 9 _appserver 100 4096 Sep 21 15:15 media drwxrwxrwx 2 _appserver 100 4096 Sep 21 19:18 mediaupload This has worked in t

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread David Avendasora
That prototype doesn't do what you think it does. That will convert the boolean value true to the string "true" and and false to "false" which obviously won't save into a bit column. Look at the intBoolean Wonder prototype. You may need to set the Prototype to "intNumber" first, and then to

Re: WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Freddie Tilley
the EOJDBCSQLServerPrototypes boolean type defaults to bit with a custom data type as follows: External Width: 5 Value Class: java.lang.Boolean Value type: c Factory Method: valueOf Conversion Method: toString Init Argument: String 2009/9/22 David Avendasora : > Hi Freddie, > > I don't believe Mi

WebObjects 5.4.3 and SQL Server 2005

2009-09-22 Thread Freddie Tilley
I have a problem with writing a boolean value to the database, using the EOJDBCSQLServerPrototypes and the boolean type. I'm also using Chuck Hills MicrosoftPlugin. If I set the boolean to true when creating an object it actually sets this value in the db when saving. But if I edit the object aga

Re: Very interesting case

2009-09-22 Thread Don Lindsay
Hello; I have a displayGroup displaying batches of 5 items per page. When a user clicks the next page, which uses displayNextBatch() for the display group, if the user goes back to the previous page, all of their answers have been cleared as if they never entered anything. If I use a WOS

Re: WebObjects and dependency injection (DI)

2009-09-22 Thread Andrus Adamchik
On Sep 22, 2009, at 11:31 AM, Andrus Adamchik wrote: We normally use Class.forName().newInstance() in some way or other to handle that. So can DI help me there? If yes, how? Also there's a number of standard scenarios, where you can swap the actual service implementation behind the immuta

Re: Recommendations for deployment on VPS?

2009-09-22 Thread Paul Hoadley
On 20/09/2009, at 4:41 PM, Chan Yeow Heong, Jerome wrote: Does anyone have any recommendations of which VPS hosting provider / solution to use for a deployment of a WebObjects application? :P I have some apps deployed on a VPS at eapps.com (CentOS) under JavaMonitor. -- Paul. w http://

Re: Proper Wonder/App Initialization for testing

2009-09-22 Thread Denis Frolov
Here is what we do using JUnit 4: 1. Add a super-class for all your test classes, e.g.: public class IntegrationTest { @BeforeClass public static void init() { ERXExtensions.initApp(Application.class, new String[0]); } } 2. Extend your test classe

Re: WebObjects and dependency injection (DI)

2009-09-22 Thread Andrus Adamchik
On Sep 22, 2009, at 9:07 AM, Anjo Krank wrote: My argument being, I have a lot of code that depends on various "services" and their instantiation. But 90% of the time, this code depends on user input, program state and external stuff. It's very rare that I actually know at compile time wha

Re: Multi-Tenant Data Architecture

2009-09-22 Thread Denis Frolov
Hi Henrique, This thread may be of interest: http://lists.apple.com/archives/webobjects-dev//2007/Jul/msg00390.html We are still using the approach described by Eugene in this thread. On Sat, Sep 19, 2009 at 7:09 PM, Henrique Prange wrote: > Hi all, > > Is there a way to configure EOF to access

Re: WebObjects and dependency injection (DI)

2009-09-22 Thread Andrus Adamchik
On Sep 22, 2009, at 10:50 AM, Lachlan Deck wrote: Yeah, this is what I assumed Anjo was getting at - after some thought, of course (as Anjo's usually the king of succinctness :) It seems to me that factory instantiations (as above) and/or making use of delegates provides all the opportun

WebObjects jobs in Paris

2009-09-22 Thread Philippe Rabier
Hi guys, Some of you know me as a Sophiacom employee. But I'm also working for another company and we are looking for WO developers. See below the job description. Please email your applications to h...@bebook.com . Have a good day. Philippe Rabier ---

Re: WebObjects and dependency injection (DI)

2009-09-22 Thread Lachlan Deck
On 22/09/2009, at 1:18 AM, Henrique Prange wrote: Andrus Adamchik wrote: I know it is not the traditional "WO way" of doing things, but from my experience using a dependency injection container in your app (Spring, Guice, etc.) is one single thing that you can do to dramatically improve th

Re: WebObjects and dependency injection (DI)

2009-09-22 Thread Lachlan Deck
On 22/09/2009, at 4:07 PM, Anjo Krank wrote: I'm not sure you understand... the String thing is only the bottleneck. I have caller code like: ERXSQLHelper sqlHelper = ERXSQLHelper.newSQLHelper(ec, model.name ()); ERXSQLHelper sqlHelper = ERXSQLHelper.newSQLHelper(ec, dbc);