[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
[Expert]
create script for ms sql server 2008  XML
Forum Index -> Quartz
Author Message
[Post New]01/14/2010 07:45:28
    Subject: create script for ms sql server 2008
[Up]
jvc214

neo

Joined: 01/14/2010 07:41:41
Messages: 4
Offline
Does anyone have a script for creating the Quartz tables in a sql server 2008 database?

I'm not a DB guy, and the documentation for sql server says to not use the IMAGE field type which is used in the sqlServer script that comes with quartz.

-Jim
[Post New]01/14/2010 07:47:05
    Subject: Re:create script for ms sql server 2008
[Up]
steve

ophanim

Joined: 05/24/2006 14:22:53
Messages: 619
Offline
Might be easier to just cluster it with terracotta.

http://dsoguy.blogspot.com/2009/12/clustered-quartz-scheduler-in-5-minutes.html
Want to post to this forum? Join the Terracotta Community
[Post New]01/15/2010 09:13:08
    Subject: Re:create script for ms sql server 2008
[Up]
jvc214

neo

Joined: 01/14/2010 07:41:41
Messages: 4
Offline
Sounds easy.

Where does terracotta persist the data?

[Post New]01/16/2010 08:45:52
    Subject: Re:create script for ms sql server 2008
[Up]
jhouse

seraphim
[Avatar]
Joined: 11/06/2009 15:29:56
Messages: 1703
Offline
You have to run a separate Terracotta server, and set it up for persistence to disk, or run an array of Terracotta servers.
[Post New]01/16/2010 08:48:43
    Subject: create script for ms sql server 2008
[Up]
jhouse

seraphim
[Avatar]
Joined: 11/06/2009 15:29:56
Messages: 1703
Offline

> I'm not a DB guy, and the documentation for sql server says to not use the IMAGE field type which is used in the sqlServer script that comes with quartz.


Then use a different field type that translates into a BLOB type via JDBC. Probably VARBINARY would be appropriate.

Can you please confirm that that works (I don't have ready access to sql server 2008) -- and then I'll update the docs.

james

[Post New]01/19/2010 06:48:16
    Subject: Re:create script for ms sql server 2008
[Up]
jvc214

neo

Joined: 01/14/2010 07:41:41
Messages: 4
Offline
James,

I decided to go with the terracotta server.
[Post New]01/19/2010 06:49:33
    Subject: Re:create script for ms sql server 2008
[Up]
jvc214

neo

Joined: 01/14/2010 07:41:41
Messages: 4
Offline
In Steve's quick setup example for terracotta, where does it persist? or is there something I would have to change to make it persist to disk?

 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team