/******************************************************************************* * This file is part of OpenNMS(R). * * Copyright (C) 2009-2011 The OpenNMS Group, Inc. * OpenNMS(R) is Copyright (C) 1999-2011 The OpenNMS Group, Inc. * * OpenNMS(R) is a registered trademark of The OpenNMS Group, Inc. * * OpenNMS(R) is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published * by the Free Software Foundation, either version 3 of the License, * or (at your option) any later version. * * OpenNMS(R) 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 General Public License for more details. * * You should have received a copy of the GNU General Public License * along with OpenNMS(R). If not, see: * http://www.gnu.org/licenses/ * * For more information contact: * OpenNMS(R) Licensing <license@opennms.org> * http://www.opennms.org/ * http://www.opennms.com/ *******************************************************************************/ package org.opennms.netmgt.provision.detector.jdbc; import org.opennms.netmgt.provision.detector.jdbc.request.JDBCRequest; import org.opennms.netmgt.provision.detector.jdbc.response.JDBCResponse; import org.opennms.netmgt.provision.support.RequestBuilder; import org.opennms.netmgt.provision.support.ResponseValidator; import org.springframework.context.annotation.Scope; import org.springframework.stereotype.Component; @Component /** * <p>JdbcStoredProcedureDetector class.</p> * * @author ranger * @version $Id: $ */ @Scope("prototype") public class JdbcStoredProcedureDetector extends AbstractJdbcDetector { private final static String DEFAULT_STORED_PROCEDURE = "isRunning"; private final static String DEFAULT_SCHEMA = "test"; private String m_storedProcedure; private String m_schema = "test"; /** * <p>Constructor for JdbcStoredProcedureDetector.</p> */ protected JdbcStoredProcedureDetector(){ super("JdbcStoredProcedureDetector", 3306); setSchema(DEFAULT_SCHEMA); setStoredProcedure(DEFAULT_STORED_PROCEDURE); } /** {@inheritDoc} */ @Override protected void onInit(){ expectBanner(resultSetNotNull()); send(storedProcedure(createProcedureCall(getSchema(), getStoredProcedure())), isValidProcedureCall()); } private static ResponseValidator<JDBCResponse> isValidProcedureCall() { return new ResponseValidator<JDBCResponse>(){ public boolean validate(JDBCResponse response) { return response.isValidProcedureCall(); } }; } private static RequestBuilder<JDBCRequest> storedProcedure(final String storedProcedure) { return new RequestBuilder<JDBCRequest>(){ public JDBCRequest getRequest() { JDBCRequest request = new JDBCRequest(); request.setStoredProcedure(storedProcedure); return request; } }; } private String createProcedureCall(String schema, String procedure) { if(schema != null){ return String.format("%s.%s", schema, procedure); }else{ return procedure; } } /** * <p>setStoredProcedure</p> * * @param storedProcedure a {@link java.lang.String} object. */ public void setStoredProcedure(String storedProcedure) { m_storedProcedure = storedProcedure; } /** * <p>getStoredProcedure</p> * * @return a {@link java.lang.String} object. */ public String getStoredProcedure() { return m_storedProcedure; } /** * <p>setSchema</p> * * @param schema a {@link java.lang.String} object. */ public void setSchema(String schema) { m_schema = schema; } /** * <p>getSchema</p> * * @return a {@link java.lang.String} object. */ public String getSchema() { return m_schema; } }