mqsireportproperties MB7BROKER -o Microsoft_SQL_Server -c JDBCProviders -r

JDBCProviders
  Microsoft_SQL_Server
    connectionUrlFormat='jdbc:sqlserver://[serverName]:[portNumber];databaseName
:[databaseName];user=[user];password=[password];'
    connectionUrlFormatAttr1=''
    connectionUrlFormatAttr2=''
    connectionUrlFormatAttr3=''
    connectionUrlFormatAttr4=''
    connectionUrlFormatAttr5=''
    databaseName='esb_system1'
    databaseType='Microsoft SQL Server'
    databaseVersion='9.0.4035'
    description='SAMPLE database'
    environmentParms='default_none'
    jarsURL='F:\mssql_2k5'
    portNumber='1211'
    securityIdentity='Microsoft_SQL_Server'
    serverName='COMP1\SQLEXPRESS'
    type4DatasourceClassName='com.microsoft.sqlserver.jdbc.SQLServerXADataSource
'
    type4DriverClassName='com.microsoft.sqlserver.jdbc.SQLServerDriver'

BIP8071I: Successful command completion.

public void evaluate(MbMessageAssembly assembly) throws MbException {
		MbOutputTerminal out = getOutputTerminal("out");
		MbMessage message = assembly.getMessage();
		// ----------------------------------------------------------
		// Add user code below
		try {
			String jdbcConn = "Microsoft_SQL_Server";
			System.out.println("Begin connection "+jdbcConn);
			Connection conn = getJDBCType4Connection(jdbcConn, JDBC_TransactionType.MB_TRANSACTION_AUTO);
			System.out.println("End connectont");
			Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			ResultSet rs = stmt.executeQuery("SELECT * FROM tb_shops");
			while (rs.next()) {
				System.out.println(rs.getString( 1 ));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			System.out.println(e.getMessage());
		}
		// End of user code
		// ----------------------------------------------------------

		// The following should only be changed
		// if not propagating message to the 'out' terminal

		out.propagate(assembly);

Begin connection Microsoft_SQL_Server
[BIPmsgs: 6233 ]BIP6233E: An error occurred in node: JavaCompute There was a problem establishing a connection to the given database URL: Microsoft_SQL_Server Exception details: java.lang.reflect.InvocationTargetException 

The node was unable to establish a connection to the given database URL. 

Contact your WebSphere Message Broker administrator. : Failed to obtain JDBC Connection

databaseName
:[databaseName]