Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
*
* Copyright (c) 2000-2012 Oracle and/or its affiliates. All rights reserved.
*
* The contents of this file are subject to the terms of either the GNU
* General Public License Version 2 only ("GPL") or the Common Development
* and Distribution License("CDDL") (collectively, the "License"). You
* may not use this file except in compliance with the License. You can
* obtain a copy of the License at
* https://glassfish.dev.java.net/public/CDDL+GPL_1_1.html
* or packager/legal/LICENSE.txt. See the License for the specific
* language governing permissions and limitations under the License.
*
* When distributing the software, include this License Header Notice in each
* file and include the License file at packager/legal/LICENSE.txt.
*
* GPL Classpath Exception:
* Oracle designates this particular file as subject to the "Classpath"
* exception as provided by Oracle in the GPL Version 2 section of the License
* file that accompanied this code.
*
* Modifications:
* If applicable, add the following below the License Header, with the fields
* enclosed by brackets [] replaced by your own identifying information:
* "Portions Copyright [year] [name of copyright owner]"
*
* Contributor(s):
* If you wish your version of this file to be governed by only the CDDL or
* only the GPL Version 2, indicate your decision by adding "[Contributor]
* elects to include this software in this distribution under the [CDDL or GPL
* Version 2] license." If you don't indicate a single choice of license, a
* recipient has the option to distribute your version of this file under
* either the CDDL, the GPL Version 2 or to extend the choice of license to
* its licensees as provided above. However, if you add GPL Version 2 code
* and therefore, elected the GPL Version 2 license, then the option applies
* only if the new code is made subject to such option by the copyright
* holder.
*/
/*
*/
package com.sun.messaging.jmq.jmsserver.persist.jdbc;
import java.sql.*;
import java.util.HashMap;
import com.sun.messaging.jmq.io.Packet;
import com.sun.messaging.jmq.io.Status;
import com.sun.messaging.jmq.io.SysMessageID;
import com.sun.messaging.jmq.util.log.Logger;
import com.sun.messaging.jmq.jmsserver.util.*;
import com.sun.messaging.jmq.jmsserver.resources.*;
import com.sun.messaging.jmq.jmsserver.Globals;
import com.sun.messaging.jmq.jmsserver.FaultInjection;
import com.sun.messaging.jmq.jmsserver.core.DestinationUID;
import com.sun.messaging.jmq.jmsserver.cluster.api.BrokerState;
import com.sun.messaging.jmq.jmsserver.persist.jdbc.comm.CommDBManager;
import com.sun.messaging.jmq.jmsserver.persist.api.HABrokerInfo;
/**
*/
class MySQLMessageDAOImpl extends MessageDAOImpl {
private static String PROC_DELETE = null;
private String dropStoredProcSQL = null;
/**
* Constructor
* @throws com.sun.messaging.jmq.jmsserver.util.BrokerException
*/
MySQLMessageDAOImpl() throws BrokerException {
super();
PROC_DELETE =
"MQ"+JDBCStore.STORE_VERSION+"SP0MSG"+JDBCStore.STORED_PROC_VERSION+
DBManager.getDBManager().getTableSuffix();
dropStoredProcSQL = new StringBuffer(128)
.append( "DROP PROCEDURE IF EXISTS "+PROC_DELETE)
.toString();
}
@Override
public void createStoredProc( Connection conn ) throws BrokerException {
boolean myConn = false;
Exception myex = null;
String sql = "";
Statement stmt = null;
try {
DBManager dbMgr = DBManager.getDBManager();
if ( conn == null ) {
conn = dbMgr.getConnection( true );
myConn = true; // Set to true since this is our connection
}
sql = new StringBuffer(128)
.append( "CREATE PROCEDURE " ).append( PROC_DELETE )
.append( "( IN msgID VARCHAR (100), " )
.append( "IN brokerID VARCHAR(100), " )
.append( "OUT row_affected INT, ")
.append( "OUT beingTakenOver INT, ")
.append( "OUT brokerState INT )" )
.append( " BEGIN " )
.append( " DECLARE not_found INT; " )
.append( " DECLARE CONTINUE HANDLER FOR NOT FOUND SET not_found=1; " )
.append( " SET not_found=0; " )
.append( " SET row_affected=1; " )
.append( " SET beingTakenOver=0; " )
.append( " SET autocommit=0; " )
.append( "DELETE FROM " ).append( tableName )
.append( " WHERE " )
.append( ID_COLUMN ).append( " = " ).append( "msgID; " )
.append( " IF not_found = 1 THEN " )
.append( " SET row_affected=0; " )
.append( " END IF; ")
.append( " IF not_found = 0 AND brokerID IS NOT NULL THEN " )
.append( " CALL "+MySQLBrokerDAOImpl.PROC_IS_BEING_TAKENOVER+"(")
.append( "brokerID, beingTakenOver, brokerState); ")
.append( " END IF; " )
.append( " IF beingTakenOver = 0 THEN ")
.append( "DELETE FROM " ).append( dbMgr.getDAOFactory().
getConsumerStateDAO().getTableName() )
.append( " WHERE " )
.append( ConsumerStateDAO.MESSAGE_ID_COLUMN ).append( " = msgID; " )
.append( " END IF; " )
.append ( "END;" ).toString();
stmt = conn.createStatement();
try {
stmt.executeUpdate(sql);
} catch (SQLException ee) {
int ec = ee.getErrorCode();
String et = ee.getSQLState();
if (!(ec == 1304 && (et == null || et.equals("42000")))) {
throw ee;
} else {
logger.log(Logger.INFO,
br.getKString(br.I_STORED_PROC_EXISTS, PROC_DELETE));
return;
}
}
Globals.getLogger().log(Logger.INFO, br.getKString(
BrokerResources.I_CREATED_STORED_PROC, PROC_DELETE));
if (DEBUG) {
Globals.getLogger().log(Logger.INFO, sql);
}
} catch (Exception e) {
myex = e;
try {
if ( (conn != null) && !conn.getAutoCommit() ) {
conn.rollback();
}
} catch ( SQLException rbe ) {
logger.log( Logger.ERROR, BrokerResources.X_DB_ROLLBACK_FAILED, rbe );
}
Exception ex;
if ( e instanceof BrokerException ) {
throw (BrokerException)e;
} else if ( e instanceof SQLException ) {
ex = CommDBManager.wrapSQLException("[" + sql + "]", (SQLException)e);
} else {
ex = e;
}
throw new BrokerException("Failed to execute "+sql, ex);
} finally {
if ( myConn ) {
closeSQLObjects( null, stmt, conn, myex );
} else {
closeSQLObjects( null, stmt, null, myex );
}
}
}
@Override
public void dropStoredProc( Connection conn ) throws BrokerException {
boolean myConn = false;
Exception myex = null;
String sql = dropStoredProcSQL;
Statement stmt = null;
try {
DBManager dbMgr = DBManager.getDBManager();
if ( conn == null ) {
conn = dbMgr.getConnection( true );
myConn = true; // Set to true since this is our connection
}
stmt = conn.createStatement();
stmt.execute(sql);
if (DEBUG) {
Globals.getLogger().log(Logger.INFO, "DONE "+sql);
}
} catch (Exception e) {
myex = e;
try {
if ( (conn != null) && !conn.getAutoCommit() ) {
conn.rollback();
}
} catch ( SQLException rbe ) {
logger.log( Logger.ERROR, BrokerResources.X_DB_ROLLBACK_FAILED, rbe );
}
Exception ex;
if ( e instanceof BrokerException ) {
throw (BrokerException)e;
} else if ( e instanceof SQLException ) {
ex = CommDBManager.wrapSQLException("[" + sql + "]", (SQLException)e);
} else {
ex = e;
}
throw new BrokerException("Failed to execute "+sql, ex);
} finally {
if ( myConn ) {
closeSQLObjects( null, stmt, conn, myex );
} else {
closeSQLObjects( null, stmt, null, myex );
}
}
}
@Override
public void delete( Connection conn,
DestinationUID dstUID,
SysMessageID sysMsgID, boolean replaycheck )
throws BrokerException {
String id = sysMsgID.getUniqueName();
boolean myConn = false;
CallableStatement stmt = null;
Exception myex = null;
String sql = "{call "+PROC_DELETE +" (?, ?, ?, ?, ?)}";
try {
DBManager dbMgr = DBManager.getDBManager();
if ( conn == null ) {
conn = dbMgr.getConnection( false );
myConn = true; // Set to true since this is our connection
}
if (fi.FAULT_INJECTION) {
HashMap fips = new HashMap();
fips.put(FaultInjection.DST_NAME_PROP,
DestinationUID.getUniqueString(dstUID.getName(), dstUID.isQueue()));
fi.checkFaultAndExit(FaultInjection.FAULT_TXN_COMMIT_1_8, fips, 2, false);
}
if (DEBUG) {
Globals.getLogger().log(Logger.INFO, "before call "+sql+"("+id+")");
}
String brokerid = dbMgr.getBrokerID();
stmt = conn.prepareCall(sql);
stmt.setString(1, id);
if (Globals.getHAEnabled()) {
stmt.setString(2, brokerid);
} else {
stmt.setNull(2, Types.VARCHAR);
}
stmt.registerOutParameter(3, Types.INTEGER);
stmt.registerOutParameter(4, Types.INTEGER);
stmt.registerOutParameter(5, Types.INTEGER);
stmt.execute();
int row_affected = stmt.getInt(3);
int beingTakenOver = stmt.getInt(4);
int bstate = stmt.getInt(5);
if (Globals.getHAEnabled() && beingTakenOver != 0 ) {
HABrokerInfo binfo = null;
try {
binfo = dbMgr.getDAOFactory().getBrokerDAO().
getBrokerInfo(conn, brokerid);
} catch (Exception e) {
/* ignore */
}
throw new StoreBeingTakenOverException(
br.getKString( BrokerResources.E_STORE_BEING_TAKEN_OVER)+
"["+BrokerState.getState(bstate).toString()+"]"+binfo);
}
if (row_affected == 0) {
throw new BrokerException(
br.getKString( BrokerResources.E_MSG_NOT_FOUND_IN_STORE,
id, dstUID ), Status.NOT_FOUND );
}
if (DEBUG) {
Globals.getLogger().log(Logger.INFO, "After call "+sql+"("+id+")");
}
if (myConn) {
conn.commit();
}
} catch (Exception e) {
myex = e;
try {
if ( (conn != null) && !conn.getAutoCommit() ) {
conn.rollback();
}
} catch ( SQLException rbe ) {
logger.log( Logger.ERROR, BrokerResources.X_DB_ROLLBACK_FAILED, rbe );
}
Exception ex;
if ( e instanceof BrokerException ) {
throw (BrokerException)e;
} else if ( e instanceof SQLException ) {
ex = CommDBManager.wrapSQLException("[" + sql + "]", (SQLException)e);
} else {
ex = e;
}
throw new BrokerException("Failed to execute "+sql, ex);
} finally {
if ( myConn ) {
closeSQLObjects( null, stmt, conn, myex );
} else {
closeSQLObjects( null, stmt, null, myex );
}
}
}
}
