/*
* JBoss, Home of Professional Open Source.
* See the COPYRIGHT.txt file distributed with this work for information
* regarding copyright ownership. Some portions may be licensed
* to Red Hat, Inc. under one or more contributor license agreements.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*/
package org.teiid.jboss.deployers;
import java.io.Serializable;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.lang.reflect.Proxy;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.SQLException;
import java.sql.SQLXML;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collection;
import java.util.Collections;
import java.util.Date;
import java.util.List;
import java.util.Properties;
import java.util.Set;
import java.util.concurrent.Callable;
import java.util.concurrent.Future;
import java.util.concurrent.TimeUnit;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.resource.spi.XATerminator;
import javax.resource.spi.work.WorkManager;
import javax.security.auth.login.LoginException;
import javax.transaction.TransactionManager;
import org.jboss.managed.api.ManagedOperation.Impact;
import org.jboss.managed.api.annotation.ManagementComponent;
import org.jboss.managed.api.annotation.ManagementObject;
import org.jboss.managed.api.annotation.ManagementOperation;
import org.jboss.managed.api.annotation.ManagementParameter;
import org.jboss.managed.api.annotation.ManagementProperties;
import org.jboss.managed.api.annotation.ManagementProperty;
import org.jboss.managed.api.annotation.ViewUse;
import org.jboss.profileservice.spi.ProfileService;
import org.jboss.util.naming.Util;
import org.teiid.adminapi.Admin;
import org.teiid.adminapi.AdminComponentException;
import org.teiid.adminapi.AdminException;
import org.teiid.adminapi.AdminProcessingException;
import org.teiid.adminapi.Admin.Cache;
import org.teiid.adminapi.impl.CacheStatisticsMetadata;
import org.teiid.adminapi.impl.DQPManagement;
import org.teiid.adminapi.impl.RequestMetadata;
import org.teiid.adminapi.impl.SessionMetadata;
import org.teiid.adminapi.impl.VDBMetaData;
import org.teiid.adminapi.impl.WorkerPoolStatisticsMetadata;
import org.teiid.adminapi.jboss.AdminProvider;
import org.teiid.cache.CacheFactory;
import org.teiid.client.DQP;
import org.teiid.client.RequestMessage;
import org.teiid.client.ResultsMessage;
import org.teiid.client.security.ILogon;
import org.teiid.client.security.InvalidSessionException;
import org.teiid.client.util.ExceptionUtil;
import org.teiid.client.util.ResultsFuture;
import org.teiid.core.ComponentNotFoundException;
import org.teiid.core.TeiidComponentException;
import org.teiid.core.TeiidException;
import org.teiid.core.TeiidRuntimeException;
import org.teiid.core.util.LRUCache;
import org.teiid.deployers.VDBLifeCycleListener;
import org.teiid.deployers.VDBRepository;
import org.teiid.deployers.VDBStatusChecker;
import org.teiid.dqp.internal.process.DQPConfiguration;
import org.teiid.dqp.internal.process.DQPCore;
import org.teiid.dqp.internal.process.DQPWorkContext;
import org.teiid.dqp.internal.process.DataTierManagerImpl;
import org.teiid.dqp.internal.process.TransactionServerImpl;
import org.teiid.dqp.service.BufferService;
import org.teiid.dqp.service.SessionService;
import org.teiid.dqp.service.SessionServiceException;
import org.teiid.dqp.service.TransactionService;
import org.teiid.events.EventDistributor;
import org.teiid.events.EventDistributorFactory;
import org.teiid.jboss.IntegrationPlugin;
import org.teiid.logging.Log4jListener;
import org.teiid.logging.LogConstants;
import org.teiid.logging.LogManager;
import org.teiid.logging.MessageLevel;
import org.teiid.metadata.AbstractMetadataRecord;
import org.teiid.metadata.Column;
import org.teiid.metadata.ColumnStats;
import org.teiid.metadata.MetadataRepository;
import org.teiid.metadata.Procedure;
import org.teiid.metadata.Schema;
import org.teiid.metadata.Table;
import org.teiid.metadata.TableStats;
import org.teiid.metadata.Table.TriggerEvent;
import org.teiid.net.TeiidURL;
import org.teiid.query.QueryPlugin;
import org.teiid.query.metadata.TransformationMetadata;
import org.teiid.query.optimizer.relational.RelationalPlanner;
import org.teiid.query.processor.DdlPlan;
import org.teiid.query.tempdata.TempTableStore;
import org.teiid.security.SecurityHelper;
import org.teiid.transport.ClientServiceRegistry;
import org.teiid.transport.ClientServiceRegistryImpl;
import org.teiid.transport.LogonImpl;
import org.teiid.transport.ODBCSocketListener;
import org.teiid.transport.SocketConfiguration;
import org.teiid.transport.SocketListener;
import org.teiid.vdb.runtime.VDBKey;
@ManagementObject(name="RuntimeEngineDeployer", isRuntime=true, componentType=@ManagementComponent(type="teiid",subtype="dqp"), properties=ManagementProperties.EXPLICIT)
public class RuntimeEngineDeployer extends DQPConfiguration implements DQPManagement, Serializable , ClientServiceRegistry, EventDistributor, EventDistributorFactory {
private static final long serialVersionUID = -4676205340262775388L;
private transient SocketConfiguration jdbcSocketConfiguration;
private transient SocketConfiguration adminSocketConfiguration;
private transient SocketConfiguration odbcSocketConfiguration;
private transient SocketListener jdbcSocket;
private transient SocketListener adminSocket;
private transient SocketListener odbcSocket;
private transient TransactionServerImpl transactionServerImpl = new TransactionServerImpl();
private transient DQPCore dqpCore = new DQPCore();
private transient SessionService sessionService;
private transient ILogon logon;
private transient Admin admin;
private transient ClientServiceRegistryImpl csr = new ClientServiceRegistryImpl();
private transient VDBRepository vdbRepository;
private transient VDBStatusChecker vdbStatusChecker;
private transient ProfileService profileService;
private transient String jndiName;
private String eventDistributorName;
private transient EventDistributor eventDistributor;
public RuntimeEngineDeployer() {
// TODO: this does not belong here
LogManager.setLogListener(new Log4jListener());
}
@Override
public <T> T getClientService(Class<T> iface)
throws ComponentNotFoundException {
return this.csr.getClientService(iface);
}
@Override
public SecurityHelper getSecurityHelper() {
return this.csr.getSecurityHelper();
}
public void start() {
dqpCore.setTransactionService((TransactionService)LogManager.createLoggingProxy(LogConstants.CTX_TXN_LOG, transactionServerImpl, new Class[] {TransactionService.class}, MessageLevel.DETAIL));
if (this.eventDistributorName != null) {
try {
InitialContext ic = new InitialContext();
this.eventDistributor = (EventDistributor) ic.lookup(this.eventDistributorName);
} catch (NamingException ne) {
//log at a detail level since we may not be in the all profile
LogManager.logDetail(LogConstants.CTX_RUNTIME, ne, IntegrationPlugin.Util.getString("jndi_failed", new Date(System.currentTimeMillis()).toString())); //$NON-NLS-1$
}
}
this.dqpCore.start(this);
this.dqpCore.getDataTierManager().setEventDistributor(this.eventDistributor);
// create the necessary services
createClientServices();
int offset = 0;
String portBinding = System.getProperty("jboss.service.binding.set"); //$NON-NLS-1$
if (portBinding != null && portBinding.startsWith("ports-")) { //$NON-NLS-1$
if (portBinding.equals("ports-default")) { //$NON-NLS-1$
offset = 0;
}
else {
try {
offset = Integer.parseInt(portBinding.substring(portBinding.length()-2))*100;
} catch (NumberFormatException e) {
offset = 0;
}
}
}
this.csr.registerClientService(ILogon.class, logon, LogConstants.CTX_SECURITY);
DQP dqpProxy = proxyService(DQP.class, this.dqpCore, LogConstants.CTX_DQP);
this.csr.registerClientService(DQP.class, dqpProxy, LogConstants.CTX_DQP);
Admin adminProxy = proxyService(Admin.class, admin, LogConstants.CTX_ADMIN_API);
this.csr.registerClientService(Admin.class, adminProxy, LogConstants.CTX_ADMIN_API);
ClientServiceRegistryImpl jdbcCsr = new ClientServiceRegistryImpl();
jdbcCsr.registerClientService(ILogon.class, logon, LogConstants.CTX_SECURITY);
jdbcCsr.registerClientService(DQP.class, dqpProxy, LogConstants.CTX_DQP);
if (this.jdbcSocketConfiguration.getEnabled()) {
this.jdbcSocket = new SocketListener(this.jdbcSocketConfiguration, jdbcCsr, this.dqpCore.getBufferManager(), offset);
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("socket_enabled","Teiid JDBC = ",(this.jdbcSocketConfiguration.getSSLConfiguration().isSslEnabled()?"mms://":"mm://")+this.jdbcSocketConfiguration.getHostAddress().getHostName()+":"+(this.jdbcSocketConfiguration.getPortNumber()+offset))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$
} else {
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("socket_not_enabled", "jdbc connections")); //$NON-NLS-1$ //$NON-NLS-2$
}
ClientServiceRegistryImpl adminCsr = new ClientServiceRegistryImpl(Type.Admin);
adminCsr.registerClientService(ILogon.class, logon, LogConstants.CTX_SECURITY);
adminCsr.registerClientService(Admin.class, adminProxy, LogConstants.CTX_ADMIN_API);
if (this.adminSocketConfiguration.getEnabled()) {
this.adminSocket = new SocketListener(this.adminSocketConfiguration, adminCsr, this.dqpCore.getBufferManager(), offset);
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("socket_enabled","Teiid Admin", (this.adminSocketConfiguration.getSSLConfiguration().isSslEnabled()?"mms://":"mm://")+this.adminSocketConfiguration.getHostAddress().getHostName()+":"+(this.adminSocketConfiguration.getPortNumber()+offset))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$
} else {
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("socket_not_enabled", "admin connections")); //$NON-NLS-1$ //$NON-NLS-2$
}
if (this.odbcSocketConfiguration.getEnabled()) {
this.vdbRepository.odbcEnabled();
this.odbcSocket = new ODBCSocketListener(this.odbcSocketConfiguration, this.dqpCore.getBufferManager(), offset, getMaxODBCLobSizeAllowed());
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("odbc_enabled","Teiid ODBC - SSL=", (this.odbcSocketConfiguration.getSSLConfiguration().isSslEnabled()?"ON":"OFF")+" Host = "+this.odbcSocketConfiguration.getHostAddress().getHostName()+" Port = "+(this.odbcSocketConfiguration.getPortNumber()+offset))); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$ //$NON-NLS-6$
} else {
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("odbc_not_enabled")); //$NON-NLS-1$
}
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("engine_started", getRuntimeVersion(), new Date(System.currentTimeMillis()).toString())); //$NON-NLS-1$
if (jndiName != null) {
final InitialContext ic ;
try {
ic = new InitialContext() ;
Util.bind(ic, jndiName, this) ;
} catch (final NamingException ne) {
// Add jndi_failed to bundle
LogManager.logError(LogConstants.CTX_RUNTIME, ne, IntegrationPlugin.Util.getString("jndi_failed", new Date(System.currentTimeMillis()).toString())); //$NON-NLS-1$
}
}
// add vdb life cycle listeners
this.vdbRepository.addListener(new VDBLifeCycleListener() {
private Set<VDBKey> recentlyRemoved = Collections.newSetFromMap(new LRUCache<VDBKey, Boolean>(10000));
@Override
public void removed(String name, int version) {
recentlyRemoved.add(new VDBKey(name, version));
}
@Override
public void added(String name, int version) {
if (!recentlyRemoved.remove(new VDBKey(name, version))) {
return;
}
// terminate all the previous sessions
try {
Collection<SessionMetadata> sessions = sessionService.getActiveSessions();
for (SessionMetadata session:sessions) {
if (name.equalsIgnoreCase(session.getVDBName()) && version == session.getVDBVersion()){
sessionService.terminateSession(session.getSessionId(), null);
}
}
} catch (SessionServiceException e) {
//ignore
}
// dump the caches.
dqpCore.clearCache(Cache.PREPARED_PLAN_CACHE.toString(), name, version);
dqpCore.clearCache(Cache.QUERY_SERVICE_RESULT_SET_CACHE.toString(), name, version);
}
});
}
public void stop() {
if (jndiName != null) {
final InitialContext ic ;
try {
ic = new InitialContext() ;
Util.unbind(ic, jndiName) ;
} catch (final NamingException ne) {
}
}
try {
this.dqpCore.stop();
} catch(TeiidRuntimeException e) {
// this bean is already shutdown
}
// Stop socket transport(s)
if (this.jdbcSocket != null) {
this.jdbcSocket.stop();
this.jdbcSocket = null;
}
if (this.adminSocket != null) {
this.adminSocket.stop();
this.adminSocket = null;
}
if (this.odbcSocket != null) {
this.odbcSocket.stop();
this.odbcSocket = null;
}
LogManager.logInfo(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("engine_stopped", new Date(System.currentTimeMillis()).toString())); //$NON-NLS-1$
}
private void createClientServices() {
this.logon = new LogonImpl(this.sessionService, "teiid-cluster"); //$NON-NLS-1$
if (profileService != null) {
this.admin = AdminProvider.getLocal(profileService, vdbStatusChecker);
} else {
try {
this.admin = AdminProvider.getLocal(vdbStatusChecker);
} catch (AdminComponentException e) {
throw new TeiidRuntimeException(e.getCause());
}
}
}
/**
* Creates an proxy to validate the incoming session
*/
private <T> T proxyService(final Class<T> iface, final T instance, String context) {
return iface.cast(Proxy.newProxyInstance(this.getClass().getClassLoader(), new Class[] {iface}, new LogManager.LoggingProxy(instance, context, MessageLevel.TRACE) {
public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
Throwable exception = null;
try {
sessionService.validateSession(DQPWorkContext.getWorkContext().getSessionId());
return super.invoke(proxy, method, args);
} catch (InvocationTargetException e) {
exception = e.getTargetException();
} catch(Throwable t){
exception = t;
}
throw ExceptionUtil.convertException(method, exception);
}
}));
}
public void setJdbcSocketConfiguration(SocketConfiguration socketConfig) {
this.jdbcSocketConfiguration = socketConfig;
}
public void setAdminSocketConfiguration(SocketConfiguration socketConfig) {
this.adminSocketConfiguration = socketConfig;
}
public void setOdbcSocketConfiguration(SocketConfiguration socketConfig) {
this.odbcSocketConfiguration = socketConfig;
}
public void setXATerminator(XATerminator xaTerminator){
this.transactionServerImpl.setXaTerminator(xaTerminator);
}
public void setTransactionManager(TransactionManager transactionManager) {
this.transactionServerImpl.setTransactionManager(transactionManager);
}
public void setWorkManager(WorkManager mgr) {
this.transactionServerImpl.setWorkManager(mgr);
}
public void setSessionService(SessionService service) {
this.sessionService = service;
service.setDqp(this.dqpCore);
}
public void setBufferService(BufferService service) {
this.dqpCore.setBufferService(service);
}
public void setSecurityHelper(SecurityHelper helper) {
this.csr.setSecurityHelper(helper);
}
public void setVDBRepository(VDBRepository repo) {
this.vdbRepository = repo;
}
public void setVDBStatusChecker(VDBStatusChecker vdbStatusChecker) {
this.vdbStatusChecker = vdbStatusChecker;
}
public void setProfileService(final ProfileService profileService) {
this.profileService = profileService ;
}
public void setJndiName(final String jndiName) {
this.jndiName = jndiName ;
}
@Override
@ManagementOperation(description="Requests for perticular session", impact=Impact.ReadOnly,params={@ManagementParameter(name="sessionId",description="The session Identifier")})
public List<RequestMetadata> getRequestsForSession(String sessionId) {
return this.dqpCore.getRequestsForSession(sessionId);
}
@Override
@ManagementOperation(description="Requests using a certain VDB", impact=Impact.ReadOnly,params={@ManagementParameter(name="vdbName",description="VDB Name"), @ManagementParameter(name="vdbVersion",description="VDB Version")})
public List<RequestMetadata> getRequestsUsingVDB(String vdbName, int vdbVersion) throws AdminException {
List<RequestMetadata> requests = new ArrayList<RequestMetadata>();
try {
Collection<SessionMetadata> sessions = this.sessionService.getActiveSessions();
for (SessionMetadata session:sessions) {
if (session.getVDBName().equals(vdbName) && session.getVDBVersion() == vdbVersion) {
requests.addAll(this.dqpCore.getRequestsForSession(session.getSessionId()));
}
}
} catch (SessionServiceException e) {
throw new AdminComponentException(e);
}
return requests;
}
@Override
@ManagementOperation(description="Active requests", impact=Impact.ReadOnly)
public List<RequestMetadata> getRequests() {
return this.dqpCore.getRequests();
}
@Override
@ManagementOperation(description="Long running requests", impact=Impact.ReadOnly)
public List<RequestMetadata> getLongRunningRequests() {
return this.dqpCore.getLongRunningRequests();
}
@Override
@ManagementOperation(description="Get thread statistics worker pool", impact=Impact.ReadOnly,params={@ManagementParameter(name="identifier",description="Get thread statistics worker pool")})
public WorkerPoolStatisticsMetadata getWorkerPoolStatistics(){
return this.dqpCore.getWorkerPoolStatistics();
}
@Override
@ManagementOperation(description="Terminate a Session",params={@ManagementParameter(name="terminateeId",description="The session to be terminated")})
public void terminateSession(String terminateeId) {
this.sessionService.terminateSession(terminateeId, DQPWorkContext.getWorkContext().getSessionId());
}
@Override
@ManagementOperation(description="Cancel a Request",params={@ManagementParameter(name="sessionId",description="The session Identifier"), @ManagementParameter(name="executionId",description="The Execution Identifier")})
public boolean cancelRequest(String sessionId, long executionId) throws AdminException {
try {
return this.dqpCore.cancelRequest(sessionId, executionId);
} catch (TeiidComponentException e) {
throw new AdminComponentException(e);
}
}
@Override
@ManagementOperation(description="Get Cache types in the system", impact=Impact.ReadOnly)
public Collection<String> getCacheTypes(){
return this.dqpCore.getCacheTypes();
}
@Override
@ManagementOperation(description="Clear the caches in the system", impact=Impact.ReadOnly)
public void clearCache(String cacheType) {
this.dqpCore.clearCache(cacheType);
}
@Override
@ManagementOperation(description="Clear the caches in the system for a VDB", params={@ManagementParameter(name="cacheType",description="Type of Cache"), @ManagementParameter(name="vdbName",description="VDB Name"),@ManagementParameter(name="version",description="VDB Version")}, impact=Impact.ReadOnly)
public void clearCache(String cacheType, String vdbName, int version) {
this.dqpCore.clearCache(cacheType, vdbName, version);
}
@Override
@ManagementOperation(description="Get the cache statistics", impact=Impact.ReadOnly)
public CacheStatisticsMetadata getCacheStatistics(String cacheType) {
return this.dqpCore.getCacheStatistics(cacheType);
}
@Override
@ManagementOperation(description="Active sessions", impact=Impact.ReadOnly)
public Collection<SessionMetadata> getActiveSessions() throws AdminException {
try {
return this.sessionService.getActiveSessions();
} catch (SessionServiceException e) {
throw new AdminComponentException(e);
}
}
@Override
@ManagementProperty(description="Active session count", use={ViewUse.STATISTIC}, readOnly=true)
public int getActiveSessionsCount() throws AdminException{
try {
return this.sessionService.getActiveSessionsCount();
} catch (SessionServiceException e) {
throw new AdminComponentException(e);
}
}
@Override
@ManagementOperation(description="Active Transactions", impact=Impact.ReadOnly)
public Collection<org.teiid.adminapi.Transaction> getTransactions() {
return this.dqpCore.getTransactions();
}
@Override
@ManagementOperation(description="Terminate the transaction", impact=Impact.ReadOnly)
public void terminateTransaction(String xid) throws AdminException {
this.dqpCore.terminateTransaction(xid);
}
@Override
@ManagementOperation(description="Merge Two VDBs",params={@ManagementParameter(name="sourceVDBName"),@ManagementParameter(name="sourceVDBName"), @ManagementParameter(name="targetVDBName"), @ManagementParameter(name="targetVDBVersion")})
public void mergeVDBs(String sourceVDBName, int sourceVDBVersion,
String targetVDBName, int targetVDBVersion) throws AdminException {
this.vdbRepository.mergeVDBs(sourceVDBName, sourceVDBVersion, targetVDBName, targetVDBVersion);
}
public void setCacheFactory(CacheFactory factory) {
this.dqpCore.setCacheFactory(factory);
}
@Override
@ManagementOperation(description="Execute a sql query", params={@ManagementParameter(name="vdbName"),@ManagementParameter(name="vdbVersion"), @ManagementParameter(name="command"), @ManagementParameter(name="timoutInMilli")})
public List<List> executeQuery(final String vdbName, final int version, final String command, final long timoutInMilli) throws AdminException {
Properties properties = new Properties();
properties.setProperty(TeiidURL.JDBC.VDB_NAME, vdbName);
properties.setProperty(TeiidURL.JDBC.VDB_VERSION, String.valueOf(version));
String user = "JOPR ADMIN"; //$NON-NLS-1$
LogManager.logDetail(LogConstants.CTX_RUNTIME, IntegrationPlugin.Util.getString("admin_executing", user, command)); //$NON-NLS-1$
SessionMetadata session = null;
try {
session = this.sessionService.createSession(user, null, "JOPR", properties, false, false); //$NON-NLS-1$
} catch (SessionServiceException e1) {
throw new AdminProcessingException(e1);
} catch (LoginException e1) {
throw new AdminProcessingException(e1);
}
final long requestID = 0L;
DQPWorkContext context = new DQPWorkContext();
context.setSession(session);
try {
return context.runInContext(new Callable<List<List>>() {
@Override
public List<List> call() throws Exception {
ArrayList<List> results = new ArrayList<List>();
long start = System.currentTimeMillis();
RequestMessage request = new RequestMessage(command);
request.setExecutionId(0L);
request.setRowLimit(getMaxRowsFetchSize()); // this would limit the number of rows that are returned.
Future<ResultsMessage> message = dqpCore.executeRequest(requestID, request);
ResultsMessage rm = message.get(timoutInMilli, TimeUnit.MILLISECONDS);
if (rm.getException() != null) {
throw new AdminProcessingException(rm.getException());
}
if (rm.isUpdateResult()) {
results.addAll(new ArrayList(Arrays.asList("update count"))); //$NON-NLS-1$
results.addAll(Arrays.asList(rm.getResults()));
}
else {
results.addAll(new ArrayList(Arrays.asList(rm.getColumnNames())));
results.addAll(Arrays.asList(fixResults(rm.getResults())));
while (rm.getFinalRow() == -1 || rm.getLastRow() < rm.getFinalRow()) {
long elapsed = System.currentTimeMillis() - start;
message = dqpCore.processCursorRequest(requestID, rm.getLastRow()+1, 1024);
rm = message.get(timoutInMilli-elapsed, TimeUnit.MILLISECONDS);
results.addAll(Arrays.asList(fixResults(rm.getResults())));
}
}
long elapsed = System.currentTimeMillis() - start;
ResultsFuture<?> response = dqpCore.closeRequest(requestID);
response.get(timoutInMilli-elapsed, TimeUnit.MILLISECONDS);
return results;
}
});
} catch (Throwable t) {
throw new AdminProcessingException(t);
} finally {
try {
sessionService.closeSession(session.getSessionId());
} catch (InvalidSessionException e) { //ignore
}
}
}
/**
* Managed Object framework has bug that does not currently allow
* sending a NULL in the Collection Value, so sending literal string "null".
* If you send them as Array Value, the MO is packaged as composite object and would like
* all the elements in array to be same type which is not the case with results.
*/
List[] fixResults(List[] rows) throws SQLException {
List[] newResults = new List[rows.length];
for(int i = 0; i < rows.length; i++) {
List row = rows[i];
ArrayList<Object> newRow = new ArrayList<Object>();
for (Object col:row) {
if (col == null) {
newRow.add("null"); //$NON-NLS-1$
}
else {
if (col instanceof Number || col instanceof String || col instanceof Character) {
newRow.add(col);
}
else if (col instanceof Blob) {
newRow.add("blob"); //$NON-NLS-1$
}
else if (col instanceof Clob) {
newRow.add("clob"); //$NON-NLS-1$
}
else if (col instanceof SQLXML) {
SQLXML xml = (SQLXML)col;
newRow.add(xml.getString());
}
else {
newRow.add(col.toString());
}
}
}
newResults[i] = newRow;
}
return newResults;
}
public String getEventDistributorName() {
return eventDistributorName;
}
public void setEventDistributorName(String eventDistributorName) {
this.eventDistributorName = eventDistributorName;
}
@Override
public void updateMatViewRow(String vdbName, int vdbVersion, String schema,
String viewName, List<?> tuple, boolean delete) {
VDBMetaData vdb = this.vdbRepository.getVDB(vdbName, vdbVersion);
if (vdb == null) {
return;
}
TempTableStore globalStore = vdb.getAttachment(TempTableStore.class);
if (globalStore == null) {
return;
}
try {
this.dqpCore.getDataTierManager().updateMatViewRow(globalStore, RelationalPlanner.MAT_PREFIX + (schema + '.' + viewName).toUpperCase(), tuple, delete);
} catch (TeiidException e) {
LogManager.logError(LogConstants.CTX_DQP, e, QueryPlugin.Util.getString("DQPCore.unable_to_process_event")); //$NON-NLS-1$
}
}
@Override
public void dataModification(String vdbName, int vdbVersion, String schema,
String... tableNames) {
updateModified(true, vdbName, vdbVersion, schema, tableNames);
}
private void updateModified(boolean data, String vdbName, int vdbVersion, String schema,
String... objectNames) {
Schema s = getSchema(vdbName, vdbVersion, schema);
if (s == null) {
return;
}
long ts = System.currentTimeMillis();
for (String name:objectNames) {
Table table = s.getTables().get(name);
if (table == null) {
continue;
}
if (data) {
table.setLastDataModification(ts);
} else {
table.setLastModified(ts);
}
}
}
@Override
public void setColumnStats(String vdbName, int vdbVersion,
String schemaName, String tableName, String columnName,
ColumnStats stats) {
Table t = getTable(vdbName, vdbVersion, schemaName, tableName);
if (t == null) {
return;
}
for (Column c : t.getColumns()) {
if (c.getName().equalsIgnoreCase(columnName)) {
c.setColumnStats(stats);
t.setLastModified(System.currentTimeMillis());
break;
}
}
}
@Override
public void setTableStats(String vdbName, int vdbVersion,
String schemaName, String tableName, TableStats stats) {
Table t = getTable(vdbName, vdbVersion, schemaName, tableName);
if (t == null) {
return;
}
t.setTableStats(stats);
t.setLastModified(System.currentTimeMillis());
}
private Table getTable(String vdbName, int vdbVersion, String schemaName,
String tableName) {
Schema s = getSchema(vdbName, vdbVersion, schemaName);
if (s == null) {
return null;
}
return s.getTables().get(tableName.toUpperCase());
}
private Schema getSchema(String vdbName, int vdbVersion, String schemaName) {
VDBMetaData vdb = this.vdbRepository.getVDB(vdbName, vdbVersion);
if (vdb == null) {
return null;
}
TransformationMetadata tm = vdb.getAttachment(TransformationMetadata.class);
if (tm == null) {
return null;
}
return tm.getMetadataStore().getSchemas().get(schemaName.toUpperCase());
}
@Override
public void setInsteadOfTriggerDefinition(String vdbName, int vdbVersion,
String schema, String viewName, TriggerEvent triggerEvent,
String triggerDefinition, Boolean enabled) {
Table t = getTable(vdbName, vdbVersion, schema, viewName);
if (t == null) {
return;
}
DdlPlan.alterInsteadOfTrigger(this.vdbRepository.getVDB(vdbName, vdbVersion), t, triggerDefinition, enabled, triggerEvent);
}
@Override
public void setProcedureDefinition(String vdbName, int vdbVersion,
String schema, String procName, String definition) {
Schema s = getSchema(vdbName, vdbVersion, schema);
if (s == null) {
return;
}
Procedure p = s.getProcedures().get(procName.toUpperCase());
if (p == null) {
return;
}
DdlPlan.alterProcedureDefinition(this.vdbRepository.getVDB(vdbName, vdbVersion), p, definition);
}
@Override
public void setViewDefinition(String vdbName, int vdbVersion,
String schema, String viewName, String definition) {
Table t = getTable(vdbName, vdbVersion, schema, viewName);
if (t == null) {
return;
}
DdlPlan.alterView(this.vdbRepository.getVDB(vdbName, vdbVersion), t, definition);
}
@Override
public void setProperty(String vdbName, int vdbVersion, String uuid,
String name, String value) {
VDBMetaData vdb = this.vdbRepository.getVDB(vdbName, vdbVersion);
if (vdb == null) {
return;
}
TransformationMetadata tm = vdb.getAttachment(TransformationMetadata.class);
if (tm == null) {
return;
}
AbstractMetadataRecord record = DataTierManagerImpl.getByUuid(tm.getMetadataStore(), uuid);
if (record != null) {
record.setProperty(name, value);
}
}
@Override
public EventDistributor getEventDistributor() {
if (this.eventDistributor != null) {
return eventDistributor;
}
return this;
}
@Override
public MetadataRepository getMetadataRepository() {
return this.vdbRepository.getMetadataRepository();
}
}