Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

sql error from insert.TaskLock syntax in oracle.properties

Description

The insert.TaskLock query is defined as the following now in 1.0.2_RC02:

insert.TaskLock = insert into dash_task_lock (id, task, server_id, claim_time, last_update) values (dash_task_lock_seq, ?, ?, ?, ?)1

where dash_task_lock_seq.NEXTVAL should be used instead.

The correct setting results the following error in the app log:

2012-10-15 13:36:17,511 WARN Dashboard Event Processing Thread org.sakaiproject.dash.dao.impl.DashboardDaoImpl - addTaskLock: Error executing query: class org.springframework.jdbc.BadSqlGrammarException:PreparedStatementCallback; bad SQL grammar [insert into dash_task_lock (id, task, server_id, claim_time, last_update) values (dash_task_lock_seq, ?, ?, ?, ?)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00984: column not allowed here

Activity

Show:

Zhen Qian October 15, 2012 at 11:35 AM

r81597 has been merged into 1.0.x in r81599.

Zhen Qian October 15, 2012 at 11:33 AM

r81597. updated the syntax of insert.TaskLock query.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created October 15, 2012 at 11:24 AM
Updated July 31, 2013 at 11:57 AM
Resolved October 15, 2012 at 11:33 AM

Flag notifications