Field 'SCHED_NAME' doesn't have a default value

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: 2 Major 2 Major
  • Resolution: Not a Bug
  • Affects Version/s: 2.1.5
  • Fix Version/s: None
  • Component/s: JDBC JobStores
  • Labels:
    None
  • Terracotta Target:
    Vicente_Holding

Description

we have applied mysql db creation script from v 2.1.5
CREATE TABLE QRTZ_SCHEDULER_STATE (
SCHED_NAME VARCHAR(120) NOT NULL,
INSTANCE_NAME VARCHAR(200) NOT NULL,
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13) NOT NULL,
PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))
TYPE=InnoDB;
1. it doesn't have a default value like in migration script
alter table qrtz_scheduler_state add column sched_name varchar(120) not null DEFAULT 'TestScheduler';
2. why it tries to add column without specifying SCHED_NAME field?
INSERT INTO QRTZ_SCHEDULER_STATE (INSTANCE_NAME, LAST_CHECKIN_TIME, CHECKIN_INTERVAL) VALUES('PersistentQuartz', 1345034381285, 20000);
I'm confused it has the next row in database

PersistentQuartzScheduler PersistentQuartz 1345202815277 20000

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
James House added a comment -

the name column should match the name of your scheduler (in the quartz.properties).

Show
James House added a comment - the name column should match the name of your scheduler (in the quartz.properties).
Hide
Permalink
Anatoly Deyneka added a comment -

yes, it's set
<property name="schedulerName" value="PersistentQuartzScheduler" />
But even with this property I see sometimes queries without SCHED_NAME.

Show
Anatoly Deyneka added a comment - yes, it's set <property name="schedulerName" value="PersistentQuartzScheduler" /> But even with this property I see sometimes queries without SCHED_NAME.
Hide
Permalink
Anatoly Deyneka added a comment -

Also as I see by java-doc in SchedulerFactoryBean the scheduler name should be always set.

"If not specified, the bean name will be used as default scheduler name.
...
public void setSchedulerName(String schedulerName) {
...
"

Show
Anatoly Deyneka added a comment - Also as I see by java-doc in SchedulerFactoryBean the scheduler name should be always set. "If not specified, the bean name will be used as default scheduler name. ... public void setSchedulerName(String schedulerName) { ... "
Hide
Permalink
James House added a comment -

You must have a version of quartz pre 2.0 in your classpath.

Show
James House added a comment - You must have a version of quartz pre 2.0 in your classpath.
Hide
Permalink
Anatoly Deyneka added a comment -

I see by the code that it can be executed on versions below 2.0.
Probably we had some problems with our repository.
After redeploying all artifacts the problem has disappeared.
Sorry for disturbing.

Show
Anatoly Deyneka added a comment - I see by the code that it can be executed on versions below 2.0. Probably we had some problems with our repository. After redeploying all artifacts the problem has disappeared. Sorry for disturbing.

People

  • Assignee:
    James House
    Reporter:
    Anatoly Deyneka
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: