找不到在postgresql建quartz表的脚本,只好用mysql的改造。以job details表为例,如下:
CREATE TABLE qrtz_job_details (
sched_name varchar(120) NOT NULL,
job_name varchar(80) NOT NULL,
job_group varchar(80) NOT NULL,
description varchar(120) DEFAULT NULL,
job_class_name varchar(128) NOT NULL,
is_durable integer NOT NULL,
is_nonconcurrent integer NOT NULL,
is_update_data integer NOT NULL,
requests_recovery integer NOT NULL,
job_data bytea,
PRIMARY KEY (sched_name, job_name, job_group)
)
WITH (
OIDS = FALSE
)
配置文件、java代码都弄好之后,调试运行时总是报:
PSQLException: ERROR: column "is_durable" is of type integer but expression is of type boolean
尝试把数据库表里的is_durable改boolean类型(另外几个类似的字段也都改成boolean),报的错误又变成:
PSQLException: ERROR: operator does not exist: integer = boolean
配置中的org.quartz.jobStore.driverDelegateClass也改成了org.quartz.impl.jdbcjobstore.PostgreSQLDelegate。
请教问题出在哪里?有没有postgresql建表的脚本给参考一下。万分感谢了!
CREATE TABLE qrtz_job_details (
sched_name varchar(120) NOT NULL,
job_name varchar(80) NOT NULL,
job_group varchar(80) NOT NULL,
description varchar(120) DEFAULT NULL,
job_class_name varchar(128) NOT NULL,
is_durable integer NOT NULL,
is_nonconcurrent integer NOT NULL,
is_update_data integer NOT NULL,
requests_recovery integer NOT NULL,
job_data bytea,
PRIMARY KEY (sched_name, job_name, job_group)
)
WITH (
OIDS = FALSE
)
配置文件、java代码都弄好之后,调试运行时总是报:
PSQLException: ERROR: column "is_durable" is of type integer but expression is of type boolean
尝试把数据库表里的is_durable改boolean类型(另外几个类似的字段也都改成boolean),报的错误又变成:
PSQLException: ERROR: operator does not exist: integer = boolean
配置中的org.quartz.jobStore.driverDelegateClass也改成了org.quartz.impl.jdbcjobstore.PostgreSQLDelegate。
请教问题出在哪里?有没有postgresql建表的脚本给参考一下。万分感谢了!