[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
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
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
jvc214

neo

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

Sounds easy.

Where does terracotta persist the data?

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.
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

jvc214

neo

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

James,

I decided to go with the terracotta server.
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