/**
* The parameter must follow the syntax "page:nr" where nr is the number of the page to be
* displayed.
*
* <p>
*
* @see org.opencms.file.collectors.I_CmsResourceCollector#getResults(org.opencms.file.CmsObject,
* java.lang.String, java.lang.String)
*/
public List<CmsResource> getResults(CmsObject cms, String collectorName, String parameter)
throws CmsException {
synchronized (this) {
if (LOG.isDebugEnabled()) {
LOG.debug(Messages.get().getBundle().key(Messages.LOG_COLLECTOR_GET_RESULTS_START_0));
}
if (parameter == null) {
parameter = m_collectorParameter;
}
List<CmsResource> resources = new ArrayList<CmsResource>();
if (getWp().getList() != null) {
Iterator<CmsListItem> itItems = getListItems(parameter).iterator();
while (itItems.hasNext()) {
CmsListItem item = itItems.next();
resources.add(getResource(cms, item));
}
} else {
Map<String, String> params =
CmsStringUtil.splitAsMap(
parameter,
I_CmsListResourceCollector.SEP_PARAM,
I_CmsListResourceCollector.SEP_KEYVAL);
resources = getInternalResources(cms, params);
}
if (LOG.isDebugEnabled()) {
LOG.debug(
Messages.get()
.getBundle()
.key(Messages.LOG_COLLECTOR_GET_RESULTS_END_1, new Integer(resources.size())));
}
return resources;
}
}
/**
* Test batched prepared statement concurrency. Batch prepares must not disappear between the
* moment when they were created and when they are executed.
*/
public void testConcurrentBatching() throws Exception {
// Create a connection with a batch size of 1. This should cause prepares and actual batch
// execution to become
// interspersed (if correct synchronization is not in place) and greatly increase the chance of
// prepares
// being rolled back before getting executed.
Properties props = new Properties();
props.setProperty(Messages.get(net.sourceforge.jtds.jdbc.Driver.BATCHSIZE), "1");
props.setProperty(
Messages.get(net.sourceforge.jtds.jdbc.Driver.PREPARESQL),
String.valueOf(TdsCore.TEMPORARY_STORED_PROCEDURES));
Connection con = getConnection(props);
try {
Statement stmt = con.createStatement();
stmt.execute(
"create table #testConcurrentBatch (v1 int, v2 int, v3 int, v4 int, v5 int, v6 int)");
stmt.close();
Vector exceptions = new Vector();
con.setAutoCommit(false);
Thread t1 = new ConcurrentBatchingHelper(con, exceptions);
Thread t2 = new ConcurrentBatchingHelper(con, exceptions);
t1.start();
t2.start();
t1.join();
t2.join();
assertEquals(0, exceptions.size());
} finally {
con.close();
}
}
/**
* Substitute actual data for the parameter markers to simulate parameter substitution in a
* PreparedStatement.
*
* @param sql The SQL containing parameter markers to substitute.
* @param list The parameter descriptors.
* @param connection The current connection.
* @return The modified SQL statement.
*/
static String substituteParameters(String sql, ParamInfo[] list, ConnectionJDBC2 connection)
throws SQLException {
int len = sql.length();
for (int i = 0; i < list.length; i++) {
if (!list[i].isRetVal && !list[i].isSet && !list[i].isOutput) {
throw new SQLException(
Messages.get("error.prepare.paramnotset", Integer.toString(i + 1)), "07000");
}
Object value = list[i].value;
if (value instanceof java.io.InputStream || value instanceof java.io.Reader) {
try {
if (list[i].jdbcType == java.sql.Types.LONGVARCHAR
|| list[i].jdbcType == java.sql.Types.CLOB
|| list[i].jdbcType == java.sql.Types.VARCHAR) {
// TODO: Should improve the character set handling here
value = list[i].getString("US-ASCII");
} else {
value = list[i].getBytes("US-ASCII");
}
// Replace the stream/reader with the String/byte[]
list[i].value = value;
} catch (java.io.IOException e) {
throw new SQLException(Messages.get("error.generic.ioerror", e.getMessage()), "HY000");
}
}
if (value instanceof String) {
len += ((String) value).length() + 5;
} else if (value instanceof byte[]) {
len += ((byte[]) value).length * 2 + 4;
} else {
len += 32; // Default size
}
}
StringBuffer buf = new StringBuffer(len + 16);
int start = 0;
for (int i = 0; i < list.length; i++) {
int pos = list[i].markerPos;
if (pos > 0) {
buf.append(sql.substring(start, list[i].markerPos));
start = pos + 1;
final boolean isUnicode = connection.getTdsVersion() >= Driver.TDS70 && list[i].isUnicode;
Support.embedData(buf, list[i].value, isUnicode, connection);
}
}
if (start < sql.length()) {
buf.append(sql.substring(start));
}
return buf.toString();
}
public boolean execute(String sql, String[] columnNames) throws SQLException {
if (columnNames == null) {
throw new SQLException(Messages.get("error.generic.nullparam", "execute"), "HY092");
} else if (columnNames.length != 1) {
throw new SQLException(Messages.get("error.generic.needcolname", "execute"), "HY092");
}
return execute(sql, RETURN_GENERATED_KEYS);
}
public void deleteRow() throws SQLException {
checkOpen();
checkUpdateable();
if (currentRow == null) {
throw new SQLException(Messages.get("error.resultset.norow"), "24000");
}
if (onInsertRow) {
throw new SQLException(Messages.get("error.resultset.insrow"), "24000");
}
//
// Construct an SQL DELETE statement
//
StringBuffer sql = new StringBuffer(128);
ArrayList params = new ArrayList();
sql.append("DELETE FROM ");
sql.append(tableName);
//
// Create the WHERE clause
//
ParamInfo parameters[] = buildWhereClause(sql, params, false);
//
// Execute the delete statement
//
updateTds.executeSQL(
sql.toString(),
null,
parameters,
false,
0,
statement.getMaxRows(),
statement.getMaxFieldSize(),
true);
int updateCount = 0;
while (!updateTds.isEndOfResponse()) {
if (!updateTds.getMoreResults()) {
if (updateTds.isUpdateCount()) {
updateCount = updateTds.getUpdateCount();
}
}
}
updateTds.clearResponseQueue();
statement.getMessages().checkErrors();
if (updateCount == 0) {
// No delete. Possibly row was changed on database by another user?
throw new SQLException(Messages.get("error.resultset.deletefail"), "24000");
}
rowDeleted = true;
currentRow = null;
if (resultSetType != ResultSet.TYPE_FORWARD_ONLY) {
// Leave a 'hole' in the result set array.
rowData.set(pos - 1, null);
}
}
public boolean execute(String sql, int[] columnIndexes) throws SQLException {
checkOpen();
if (columnIndexes == null) {
throw new SQLException(Messages.get("error.generic.nullparam", "execute"), "HY092");
} else if (columnIndexes.length != 1) {
throw new SQLException(Messages.get("error.generic.needcolindex", "execute"), "HY092");
}
return execute(sql, RETURN_GENERATED_KEYS);
}
/**
* @see
* org.opencms.workplace.list.A_CmsListDialog#setMultiActions(org.opencms.workplace.list.CmsListMetadata)
*/
@Override
protected void setMultiActions(final CmsListMetadata metadata) {
// add copy multi action
CmsListMultiAction deleteMultiAction = new CmsListMultiAction(LIST_MACTION_COPY);
deleteMultiAction.setName(
Messages.get().container(Messages.GUI_LIST_SEARCHINDEX_MACTION_COPY_NAME_0));
deleteMultiAction.setHelpText(
Messages.get().container(Messages.GUI_LIST_SEARCHINDEX_MACTION_COPY_HELP_0));
deleteMultiAction.setIconPath(ICON_MULTI_ADD);
metadata.addMultiAction(deleteMultiAction);
}
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException {
checkOpen();
if (sql == null || sql.length() == 0) {
throw new SQLException(Messages.get("error.generic.nosql"), "HY000");
}
closeCurrentResultSet();
boolean returnKeys;
String sqlWord = "";
if (escapeProcessing) {
ArrayList params = new ArrayList();
String tmp[] = new SQLParser(sql, params, connection).parse(false);
if (tmp[1].length() != 0 || params.size() > 0) {
throw new SQLException(Messages.get("error.statement.badsql"), "07000");
}
sql = tmp[0];
sqlWord = tmp[2];
} else {
// Escape processing turned off so
// see if we can extract "insert" from start of statement
sql = sql.trim();
if (sql.length() > 5) {
sqlWord = sql.substring(0, 6).toLowerCase();
}
}
if (autoGeneratedKeys == RETURN_GENERATED_KEYS) {
returnKeys = sqlWord.equals("insert");
} else if (autoGeneratedKeys == NO_GENERATED_KEYS) {
returnKeys = false;
} else {
throw new SQLException(
Messages.get(
"error.generic.badoption", Integer.toString(autoGeneratedKeys), "executeUpate"),
"HY092");
}
if (returnKeys) {
if (connection.getServerType() == Driver.SQLSERVER
&& connection.getDatabaseMajorVersion() >= 8) {
sql += " SELECT SCOPE_IDENTITY() AS ID";
} else {
sql += " SELECT @@IDENTITY AS ID";
}
}
executeSQL(sql, null, sqlWord, null, returnKeys, true);
return getUpdateCount(0);
}
/**
* Sets the name of the menu rule set.
*
* <p>
*
* @param name the name of the menu rule set
*/
public void setName(String name) {
if (m_frozen) {
throw new CmsRuntimeException(Messages.get().container(Messages.ERR_MENURULE_FROZEN_0));
}
m_name = name;
}
public void refreshRow() throws SQLException {
checkOpen();
if (onInsertRow) {
throw new SQLException(Messages.get("error.resultset.insrow"), "24000");
}
//
// If row is being updated discard updates now
//
if (concurrency == CONCUR_UPDATABLE) {
cancelRowUpdates();
rowUpdated = false;
}
if (resultSetType == ResultSet.TYPE_FORWARD_ONLY || currentRow == null) {
// Do not try and refresh the row in these cases.
return;
}
//
// If result set is keyed we can refresh the row data from the
// database using the key.
// NB. MS SQL Server #Temporary tables with keys are not identified correctly
// in the column meta data sent after 'for browse'. This means that
// temporary tables can not be used with this logic.
//
if (isKeyed) {
// OK all tables are keyed
refreshKeyedRows();
} else {
// No good have to use brute force approach
refreshReRead();
}
}
/** @see org.opencms.workplace.CmsWorkplace#initMessages() */
protected void initMessages() {
// add specific dialog resource bundle
addMessages(Messages.get().getBundleName());
// add default resource bundles
super.initMessages();
}
public MSSqlServerInfo(String host) throws SQLException {
try {
InetAddress addr = InetAddress.getByName(host);
DatagramSocket socket = new DatagramSocket();
byte[] msg = new byte[] {0x02};
DatagramPacket p = new DatagramPacket(msg, msg.length, addr, 1434);
socket.send(p);
byte[] buf = new byte[4096];
p = new DatagramPacket(buf, buf.length);
socket.setSoTimeout(m_timeout);
for (int i = 0; i < m_numRetries; i++) {
try {
socket.receive(p);
String infoString = extractString(buf, p.getLength());
m_serverInfoStrings = split(infoString, ';');
return;
} catch (InterruptedIOException toEx) {
}
}
} catch (Exception e) {
// Ignore...
}
throw new SQLException(Messages.get("error.msinfo.badinfo", host), "HY000");
}
/**
* Checks if this job info configuration is frozen.
*
* <p>
*
* @throws CmsRuntimeException in case the configuration is already frozen
*/
protected void checkFrozen() throws CmsRuntimeException {
if (m_frozen) {
throw new CmsRuntimeException(
Messages.get().container(Messages.ERR_JOB_INFO_FROZEN_1, getJobName()));
}
}
/** @see org.opencms.workplace.CmsWorkplace#initMessages() */
@Override
protected void initMessages() {
// add specific dialog resource bundle
addMessages(Messages.get().getBundleName());
super.initMessages();
}
/**
* @return SKIP_BODY
* @see javax.servlet.jsp.tagext.Tag#doStartTag()
*/
@Override
public int doStartTag() throws JspException {
ServletRequest req = pageContext.getRequest();
// This will always be true if the page is called through OpenCms
if (CmsFlexController.isCmsRequest(req)) {
try {
String setting = elementSettingTagAction(getName(), m_defaultValue, m_escapeHtml, req);
// Make sure that no null String is returned
if (setting == null) {
setting = "";
}
pageContext.getOut().print(setting);
} catch (Exception ex) {
if (LOG.isErrorEnabled()) {
LOG.error(
Messages.get().getBundle().key(Messages.ERR_PROCESS_TAG_1, "elementSetting"), ex);
}
throw new javax.servlet.jsp.JspException(ex);
}
}
return SKIP_BODY;
}
/**
* Reads the resources available for processing based on the path parameters.
*
* <p>
*
* @return the resources available for processing based on the path parameters.
*/
@SuppressWarnings("unchecked")
private List<CmsResource> getResources() {
List<CmsResource> result = new LinkedList<CmsResource>();
CmsObject cms = this.getCms();
CmsResourceFilter filter = CmsResourceFilter.ALL;
try {
for (String path : this.m_paths) {
List<CmsResource> resources = cms.readResources(path, filter, true);
// filter out any resource that is no XML content:
for (CmsResource resource : resources) {
if (resource.isFile()) {
if (CmsResourceTypeXmlContent.isXmlContent(resource)) {
result.add(resource);
} else if (CmsResourceTypeXmlPage.isXmlPage(resource)) {
result.add(resource);
}
}
}
}
} catch (CmsException e) {
LOG.error(Messages.get().getBundle().key(Messages.LOG_ERR_LANGUAGECOPY_READRESOURCES_0), e);
result = Collections.emptyList();
}
return result;
}
/** @see org.opencms.cache.I_CmsLruCacheObject#addToLruCache() */
public void addToLruCache() {
// do nothing here...
if (LOG.isDebugEnabled()) {
LOG.debug(Messages.get().getBundle().key(Messages.LOG_FLEXCACHEENTRY_ADDED_ENTRY_1, this));
}
}
/** @see org.opencms.workplace.CmsWorkplace#initMessages() */
protected void initMessages() {
// add specific dialog resource bundle
addMessages(Messages.get().getBundleName());
// add default resource bundles
addMessages(org.opencms.workplace.Messages.get().getBundleName());
addMessages(org.opencms.workplace.tools.Messages.get().getBundleName());
}
/**
* Sets the name of the class to schedule.
*
* <p>
*
* @param className the class name to set
*/
public void setClassName(String className) {
checkFrozen();
if (!CmsStringUtil.isValidJavaClassName(className)) {
CmsMessageContainer message =
Messages.get().container(Messages.ERR_BAD_JOB_CLASS_NAME_1, className);
if (OpenCms.getRunLevel() > OpenCms.RUNLEVEL_2_INITIALIZING) {
throw new CmsIllegalArgumentException(message);
} else {
LOG.warn(message.key());
}
} else {
Class<?> jobClass;
try {
jobClass = Class.forName(className);
if (!I_CmsScheduledJob.class.isAssignableFrom(jobClass)) {
CmsMessageContainer message =
Messages.get()
.container(
Messages.ERR_JOB_CLASS_BAD_INTERFACE_2,
className,
I_CmsScheduledJob.class.getName());
if (OpenCms.getRunLevel() > OpenCms.RUNLEVEL_2_INITIALIZING) {
throw new CmsIllegalArgumentException(message);
} else {
LOG.warn(message.key());
}
}
} catch (ClassNotFoundException e) {
CmsMessageContainer message =
Messages.get().container(Messages.ERR_JOB_CLASS_NOT_FOUND_1, className);
if (OpenCms.getRunLevel() > OpenCms.RUNLEVEL_2_INITIALIZING) {
throw new CmsIllegalArgumentException(message);
} else {
LOG.warn(message.key());
}
}
}
m_className = className;
if (getJobName() == null) {
// initialize job name with class name as default
setJobName(className);
}
}
/**
* @see
* org.opencms.workplace.list.A_CmsListDialog#setColumns(org.opencms.workplace.list.CmsListMetadata)
*/
@SuppressWarnings("unchecked")
@Override
protected void setColumns(final CmsListMetadata metadata) {
// enforce re-invocation of this method because columns are varying and must not be cached:
metadata.setVolatile(true);
// add column for icon
CmsListColumnDefinition iconCol = new CmsListColumnDefinition(LIST_COLUMN_ICON);
iconCol.setName(Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_ICON_NAME_0));
iconCol.setHelpText(Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_ICON_HELP_0));
iconCol.setAlign(CmsListColumnAlignEnum.ALIGN_LEFT);
iconCol.setWidth("16");
iconCol.setSorteable(false);
metadata.addColumn(iconCol);
iconCol.setPrintable(true);
// add column for name
CmsListColumnDefinition nameCol = new CmsListColumnDefinition(LIST_COLUMN_PATH);
nameCol.setName(Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_PATH_NAME_0));
nameCol.setHelpText(Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_PATH_HELP_0));
nameCol.setAlign(CmsListColumnAlignEnum.ALIGN_LEFT);
nameCol.setSorteable(true);
metadata.addColumn(nameCol);
nameCol.setPrintable(true);
// add column for resource type
CmsListColumnDefinition typeCol = new CmsListColumnDefinition(LIST_COLUMN_RESOURCETYPE);
typeCol.setName(
Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_RESOURCETYPE_NAME_0));
typeCol.setHelpText(
Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_RESOURCETYPE_HELP_0));
typeCol.setAlign(CmsListColumnAlignEnum.ALIGN_LEFT);
typeCol.setSorteable(true);
metadata.addColumn(typeCol);
typeCol.setPrintable(true);
// add columns for languages:
List<Locale> sysLocales = OpenCms.getLocaleManager().getAvailableLocales();
CmsListColumnDefinition langCol;
for (Locale locale : sysLocales) {
langCol = new CmsListColumnDefinition(locale.toString());
langCol.setName(
Messages.get()
.container(
Messages.GUI_LIST_LANGUAGECOPY_COL_LANGUAGE_NAME_1,
new Object[] {locale.toString()}));
langCol.setHelpText(
Messages.get().container(Messages.GUI_LIST_LANGUAGECOPY_COL_LANGUAGE_HELP_0));
langCol.setAlign(CmsListColumnAlignEnum.ALIGN_LEFT);
langCol.setSorteable(false);
metadata.addColumn(langCol);
langCol.setPrintable(true);
}
}
public void setQueryTimeout(int seconds) throws SQLException {
checkOpen();
if (seconds < 0) {
throw new SQLException(Messages.get("error.generic.optltzero", "setQueryTimeout"), "HY092");
}
this.queryTimeout = seconds;
}
/**
* Sets the context information for the user executing the job.
*
* <p>This will also "freeze" the context information that is set.
*
* <p>
*
* @param contextInfo the context information for the user executing the job
* @see CmsContextInfo#freeze()
*/
public void setContextInfo(CmsContextInfo contextInfo) {
checkFrozen();
if (contextInfo == null) {
throw new CmsIllegalArgumentException(
Messages.get().container(Messages.ERR_BAD_CONTEXT_INFO_0));
}
m_context = contextInfo;
}
public void setFetchSize(int rows) throws SQLException {
checkOpen();
if (rows < 0 || (maxRows > 0 && rows > maxRows)) {
throw new SQLException(Messages.get("error.generic.optltzero", "setFetchSize"), "HY092");
}
this.fetchSize = rows;
}
public void setMaxRows(int max) throws SQLException {
checkOpen();
if (max < 0) {
throw new SQLException(Messages.get("error.generic.optltzero", "setMaxRows"), "HY092");
}
this.maxRows = max;
}
public void dataReceived(List<JSOModel> models) {
ConfirmDialog saved = new ConfirmDialog("Survey Cancelled!");
saved.show();
saved.center();
// assume that the cancellation is
// done to a bcast in the first page
Messages.get().loadBroadcasts(0);
}
/**
* Sets the job name.
*
* <p>
*
* @param jobName the job name to set
*/
public void setJobName(String jobName) {
checkFrozen();
if (CmsStringUtil.isEmpty(jobName) || !jobName.trim().equals(jobName)) {
throw new CmsIllegalArgumentException(
Messages.get().container(Messages.ERR_BAD_JOB_NAME_1, jobName));
}
m_jobName = jobName;
}
public ResultSet executeQuery(String sql) throws SQLException {
checkOpen();
if (sql == null || sql.length() == 0) {
throw new SQLException(Messages.get("error.generic.nosql"), "HY000");
}
if (escapeProcessing) {
ArrayList params = new ArrayList();
String tmp[] = new SQLParser(sql, params, connection).parse(false);
if (tmp[1].length() != 0 || params.size() > 0) {
throw new SQLException(Messages.get("error.statement.badsql"), "07000");
}
sql = tmp[0];
}
return this.executeSQLQuery(sql, null, null, false);
}
/**
* Sets the job parameters.
*
* <p>
*
* @param parameters the parameters to set
*/
public void setParameters(SortedMap<String, String> parameters) {
checkFrozen();
if (parameters == null) {
throw new CmsIllegalArgumentException(
Messages.get().container(Messages.ERR_BAD_JOB_PARAMS_0));
}
// make sure the parameters are a sorted map
m_parameters = new TreeMap<String, String>(parameters);
}
/** Get the string searching in the chain */
public String get(String key) {
for (Iterator iter = chain.iterator(); iter.hasNext(); ) {
Messages msgs = (Messages) iter.next();
String str = msgs.get(key);
if (!str.startsWith("???")) {
return str;
}
}
return "???" + key + "???";
}
/**
* Retrieve the value of an output parameter.
*
* @param parameterIndex the ordinal position of the parameter
* @return the parameter value as an <code>Object</code>
* @throws SQLException if the parameter has not been set
*/
protected Object getOutputValue(int parameterIndex) throws SQLException {
ParamInfo parameter = getParameter(parameterIndex);
if (!parameter.isOutput) {
throw new SQLException(
Messages.get("error.callable.notoutput", new Integer(parameterIndex)), "07000");
}
Object value = parameter.getOutValue();
paramWasNull = (value == null);
return value;
}