Help: How to use Quartz in a SaaS/Multi-Tenancy application?

View: New views
2 Messages — Rating Filter:   Alert me  

Help: How to use Quartz in a SaaS/Multi-Tenancy application?

by Peagmaguice :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

We are building a multi-tenancy application and planning on using Quartz for the scheduling functions within the application.

Just to clarify, the application supports multiple tenants (or subscribers) and is available as a hosted offering.    To ensure data security, each table has TENANT_ID.  Adding this colum has the effect of partitioning the table for each TENANT.

As we start looking into integration with Quartz, the immediate question is how to build multitenancy into the standard schema provided by Quartz.  Clearly, we cannot mix records from Company A and Company B.   At this point, changing the Quartz schema or Quartz code is beyond the scope of the project.

Any insights into potential solutions / work arounds is appreciated.

Thank you.

John
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=402043&messageID=489341#489341


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...


Re: Help: How to use Quartz in a SaaS/Multi-Tenancy application?

by Peagmaguice :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have no code base available for now, so I give u a pointer for searching.

I think it is possible to change the prefix 'QRTZ_' with an own one like 'COMPANY_A_QRTZ_'.
So u setup the table structure for every company u need.
Do u like to provide only ONE scheduler for every company ? May that's not possible...

I'm unsure... look into quartz.properties for the prefix.
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=402043&messageID=490474#490474


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

LightInTheBox - Buy quality products at wholesale price