Using explicit schema names in the Quartz database

[areel]

Hi

We have a product that supports the use of SQLServer,Oracle and MySQL
as the backend DB.

We use an explicit schema name in order to help in the admin of
supporting 3 DB vendors. We would like to store the quartz database
inside our existing database. To do so I believe we need to have the
tables etc associated with our schema.

So, is it possible to configure Quartz to use an explicit schema_name?


e.g
with SQLServer use [my_schema_name].[quartzTable] rather than [dbo].
[quartzTable]
with Oracle use "my_schema_name"."quartzTable" rather than
"defaultUserSchema"."quartzTable"
("defaultUserSchema" Oracle uses the schema of the logged on user, so
in the supplied quartz oracle sql script no explicit schema_name is
required/given, but the result is that these tables etc belong to who
ever is logged on when the script is executed).


Regards


Aidan

[Marko Lahma]

Hi,

Try setting table prefix with schema included, like this:

properties["quartz.jobStore.tablePrefix"] = "[dbo].QRTZ_";

Hope this helps,

-Marko

[areel]

Hi,

Just to let you know that your suggestion works. I have tested it on
SQLServer 2005 schema.

I would also like to say Thanks for the effort you and your colleagues
have put into this product.
I really do appreciate it.

Regards

Aidan

On Feb 19, 7:40 am, Marko Lahma <marko.la...@gmail.com> wrote:
> Hi,
>
> Try setting table prefix with schema included, like this:
>
> properties["quartz.jobStore.tablePrefix"] = "[dbo].QRTZ_";
>
> Hope this helps,
>
> -Marko
>