/**
*
* Copyright 2004 The Apache Software Foundation
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.geronimo.timer.jdbc;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import javax.sql.DataSource;
import com.thoughtworks.xstream.XStream;
import org.apache.geronimo.timer.PersistenceException;
import org.apache.geronimo.timer.Playback;
import org.apache.geronimo.timer.WorkInfo;
import org.apache.geronimo.timer.WorkerPersistence;
/**
* TODO use an insert returning or stored procedure to insert.
*
* @version $Rev: 355877 $ $Date: 2005-12-11 03:48:27 +0100 (Sun, 11 Dec 2005) $
*/
public class JDBCWorkerPersistence implements WorkerPersistence {
private static final String createSequenceSQL = "create sequence timertasks_seq";
private static final String createTableSQLWithSequence = "create table timertasks (id long primary key, serverid varchar(256) not null, timerkey varchar(256) not null, userid varchar(4096), userinfo varchar(4096), firsttime long not null, period long, atfixedrate boolean not null)";
private static final String createTableSQLWithIdentity = "create table timertasks (id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), serverid varchar(256) not null, timerkey varchar(256) not null, userid varchar(4096), userinfo varchar(4096), firsttime NUMERIC(18,0) not null, period NUMERIC(18, 0), atfixedrate CHAR(1))";
private static final String sequenceSQL = "select timertasks_seq.nextval";
private static final String identitySQL = "values IDENTITY_VAL_LOCAL()";
private static final String insertSQLWithSequence = "insert into timertasks (id, serverid, timerkey, userid, userinfo, firsttime, period, atfixedrate) values (?, ?, ?, ?, ?, ?, ?, ?)";
private static final String insertSQLWithIdentity = "insert into timertasks (serverid, timerkey, userid, userinfo, firsttime, period, atfixedrate) values (?, ?, ?, ?, ?, ?, ?)";
private static final String deleteSQL = "delete from timertasks where id=?";
private static final String selectSQL = "select id, userid, userinfo, firsttime, period, atfixedrate from timertasks where serverid = ? and timerkey=?";
private static final String fixedRateUpdateSQL = "update timertasks set firsttime = firsttime + period where id = ?";
private static final String intervalUpdateSQL = "update timertasks set firsttime = ? where id = ?";
private static final String selectByKeySQL = "select id from timertasks where serverid = ? and timerkey = ? and (userid = ? or ? is null)";
private final String serverUniqueId;
private final DataSource dataSource;
private boolean useSequence = false;
protected JDBCWorkerPersistence(String serverUniqueId, DataSource datasource, boolean useSequence) throws SQLException {
this.serverUniqueId = serverUniqueId;
this.dataSource = datasource;
this.useSequence = useSequence;
if (this.useSequence) {
execSQL(createSequenceSQL);
execSQL(createTableSQLWithSequence);
} else {
execSQL(createTableSQLWithIdentity);
}
}
public void save(WorkInfo workInfo) throws PersistenceException {
try {
Connection c = dataSource.getConnection();
try {
if (useSequence) {
long id;
PreparedStatement seqStatement = c.prepareStatement(sequenceSQL);
try {
ResultSet seqRS = seqStatement.executeQuery();
try {
seqRS.next();
id = seqRS.getLong(1);
} finally {
seqRS.close();
}
} finally {
seqStatement.close();
}
workInfo.setId(id);
PreparedStatement insertStatement = c.prepareStatement(insertSQLWithSequence);
try {
String serializedUserId = serialize(workInfo.getUserId());
String serializedUserKey = serialize(workInfo.getUserInfo());
insertStatement.setLong(1, id);
insertStatement.setString(2, serverUniqueId);
insertStatement.setString(3, workInfo.getKey());
insertStatement.setString(4, serializedUserId);
insertStatement.setString(5, serializedUserKey);
insertStatement.setLong(6, workInfo.getTime().getTime());
if (workInfo.getPeriod() == null) {
insertStatement.setNull(7, Types.NUMERIC);
} else {
insertStatement.setLong(7, workInfo.getPeriod().longValue());
}
insertStatement.setBoolean(8, workInfo.getAtFixedRate());
int result = insertStatement.executeUpdate();
if (result != 1) {
throw new PersistenceException("Could not insert!");
}
} finally {
insertStatement.close();
}
} else {
PreparedStatement insertStatement = c.prepareStatement(insertSQLWithIdentity);
try {
String serializedUserId = serialize(workInfo.getUserId());
String serializedUserKey = serialize(workInfo.getUserInfo());
insertStatement.setString(1, serverUniqueId);
insertStatement.setString(2, workInfo.getKey());
insertStatement.setString(3, serializedUserId);
insertStatement.setString(4, serializedUserKey);
insertStatement.setLong(5, workInfo.getTime().getTime());
if (workInfo.getPeriod() == null) {
insertStatement.setNull(6, Types.NUMERIC);
} else {
insertStatement.setLong(6, workInfo.getPeriod().longValue());
}
insertStatement.setBoolean(7, workInfo.getAtFixedRate());
int result = insertStatement.executeUpdate();
if (result != 1) {
throw new PersistenceException("Could not insert!");
}
} finally {
insertStatement.close();
}
long id;
PreparedStatement identityStatement = c.prepareStatement(identitySQL);
try {
ResultSet seqRS = identityStatement.executeQuery();
try {
seqRS.next();
id = seqRS.getLong(1);
} finally {
seqRS.close();
}
} finally {
identityStatement.close();
}
workInfo.setId(id);
}
} finally {
c.close();
}
} catch (SQLException e) {
throw new PersistenceException(e);
}
}
public void cancel(long id) throws PersistenceException {
try {
Connection c = dataSource.getConnection();
try {
PreparedStatement deleteStatement = c.prepareStatement(deleteSQL);
try {
deleteStatement.setLong(1, id);
deleteStatement.execute();
} finally {
deleteStatement.close();
}
} finally {
c.close();
}
} catch (SQLException e) {
throw new PersistenceException(e);
}
}
public void playback(String key, Playback playback) throws PersistenceException {
try {
Connection c = dataSource.getConnection();
try {
PreparedStatement selectStatement = c.prepareStatement(selectSQL);
selectStatement.setString(1, serverUniqueId);
selectStatement.setString(2, key);
try {
ResultSet taskRS = selectStatement.executeQuery();
try {
while (taskRS.next()) {
long id = taskRS.getLong(1);
String serizalizedUserId = taskRS.getString(2);
Object userId = deserialize(serizalizedUserId);
String serializedUserInfo = taskRS.getString(3);
Object userInfo = deserialize(serializedUserInfo);
long timeMillis = taskRS.getLong(4);
Date time = new Date(timeMillis);
Long period = null;
period = new Long(taskRS.getLong(5));
if (!taskRS.wasNull()) {
period = null;
}
boolean atFixedRate = taskRS.getBoolean(6);
//TODO make sure the reference to this is ok, meaning we can't use a handle to this WorkerPersistence.
WorkInfo workInfo = new WorkInfo(key, userId, userInfo, time, period, atFixedRate);
workInfo.setId(id);
playback.schedule(workInfo);
}
} finally {
taskRS.close();
}
} finally {
selectStatement.close();
}
} finally {
c.close();
}
} catch (SQLException e) {
throw new PersistenceException(e);
}
}
public void fixedRateWorkPerformed(long id) throws PersistenceException {
try {
Connection c = dataSource.getConnection();
try {
PreparedStatement updateStatement = c.prepareStatement(fixedRateUpdateSQL);
try {
updateStatement.setLong(1, id);
updateStatement.execute();
} finally {
updateStatement.close();
}
} finally {
c.close();
}
} catch (SQLException e) {
throw new PersistenceException(e);
}
}
public void intervalWorkPerformed(long id, long period) throws PersistenceException {
long next = System.currentTimeMillis() + period;
try {
Connection c = dataSource.getConnection();
try {
PreparedStatement updateStatement = c.prepareStatement(intervalUpdateSQL);
try {
updateStatement.setLong(1, next);
updateStatement.setLong(2, id);
updateStatement.execute();
} finally {
updateStatement.close();
}
} finally {
c.close();
}
} catch (SQLException e) {
throw new PersistenceException(e);
}
}
public Collection getIdsByKey(String key, Object userId) throws PersistenceException {
Collection ids = new ArrayList();
try {
Connection c = dataSource.getConnection();
try {
PreparedStatement selectStatement = c.prepareStatement(selectByKeySQL);
selectStatement.setString(1, serverUniqueId);
selectStatement.setString(2, key);
if (userId == null) {
selectStatement.setNull(3, Types.VARCHAR);
selectStatement.setNull(4, Types.VARCHAR);
} else {
String userIdString = serialize(userId);
selectStatement.setString(3, userIdString);
selectStatement.setString(4, userIdString);
}
try {
ResultSet taskRS = selectStatement.executeQuery();
try {
while (taskRS.next()) {
long id = taskRS.getLong(1);
ids.add(new Long(id));
}
} finally {
taskRS.close();
}
} finally {
selectStatement.close();
}
} finally {
c.close();
}
} catch (SQLException e) {
throw new PersistenceException(e);
}
return ids;
}
private String serialize(Object task) {
XStream xStream = new XStream();
return xStream.toXML(task);
}
private Object deserialize(String serializedRunnable) {
XStream xStream = new XStream();
return xStream.fromXML(serializedRunnable);
}
private void execSQL(String sql) throws SQLException {
Connection c = dataSource.getConnection();
try {
PreparedStatement updateStatement = c.prepareStatement(sql);
try {
updateStatement.execute();
} catch (SQLException e) {
//ignore... table already exists.
} finally {
updateStatement.close();
}
} finally {
c.close();
}
}
}