(April 2016: Lab updated for IIB10004) This lab shows the following functions:
– Deployment of applications and libraries from the Web UI;
– Explore Web UI without security
– Configure Web UI with role-based security:
– Explore Web UI with role-based security

Featuring:

  • Browser and remote admin access with HTTPS
  • Web browser administration without role security
  • Authentication with LDAP
  • Configuring Web UI with role-based security
  • Web browser admin with role security
  • BAR deploy and BAR override
  • Toolkit authorization
  • Operational Policy administration

2 comments on"[iib10] Lab 10: Web Administration Interface and File-based Security"

  1. Gary Holladay March 28, 2017

    This doesn’t work for me, and I keep getting an error on attempt to send the basic message. The error follows. Any ideas? The key seems to be ‘No suitable driver found’. Yet the HRDB data definition setup succeeds.

    Error sending request to http “http://localhost:7800/EmployeeService”
    soapenv:ServerBIP3113E: Exception detected in message flow gen.EmployeeService.SOAP Input (integration node IB10NODE_SQLS) BIP2230E: Error detected whilst processing a message in node ‘gen.EmployeeService.getEmployee_Request_Response.getEmployee_WS’.

    The integration node detected an error whilst processing a message in node ‘gen.EmployeeService.getEmployee_Request_Response.getEmployee_WS’. An exception has been thrown to cut short the processing of the message.

    See the following messages for details of the error. : F:\build\S1000_slot1\S1000_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp: 1265: ImbJniNode::evaluate: ComIbmMSLMappingNode: gen/EmployeeService#FCMComposite_1_8.gen/getEmployee_Request_Response#FCMComposite_1_1

    BIP3947E: The map processing for QName ”{default}:getEmployee_WS” has failed, with the following details: ”XProcessException com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@1e7b8f6 method:JDBCType4Connection::createNonXAConnection source:BIPmsgs key:6233 >”.

    The processing of the map has failed.

    Review and resolve the problems indicated in the message from the map processing. : MbErrorHandler.java: 148: evaluate: :

    BIP3949E: An error occurred during the processing of a message. The error message is ”com.ibm.broker.xci.BrokerXCIException: <com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@1e7b8f6 method:JDBCType4Connection::createNonXAConnection source:BIPmsgs key:6233 >

    <com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@1e7b8f6 method:JDBCType4Connection::createNonXAConnection source:BIPmsgs key:6233 >

    ”.

    An error occurred during message processing. Additional diagnostic information might be written to the user trace.

    Inspect the diagnostic information, and check the user trace for further information. : MbErrorHandlerBase.java: 131: throwableToMbException: :

    BIP6233E: An error occurred in node: ‘Broker ‘IB10NODE_SQLS’; Execution Group ‘default’; Message Flow ‘gen.EmployeeService’; Node ‘getEmployee_Request_Response.getEmployee_WS’; Node Type ‘Mapping’ There was a problem establishing a connection to the given database URL: ‘jdbc:sqlserver://localhost:49688;DatabaseName=HRDB;integratedSecurity=true’ Exception details: ‘ error message: No suitable driver, SQLState value: 08001, stack trace: [com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createNonXAConnection(JDBCType4Connection.java:348)

    com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(JDBCType4Connection.java:1131)

    com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:280)

    com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:153)

    com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)

    java.lang.reflect.Method.invoke(Method.java:620)

    com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1533)

    com.ibm.broker.ct.mapping.MappingNode.getDBConnection(MappingNode.java:1865)

    com.ibm.broker.ct.mapping.JDBCWrapper.prepare(JDBCWrapper.java:2863)

    com.ibm.broker.ct.mapping.JDBCWrapper.select(JDBCWrapper.java:653)

    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)

    java.lang.reflect.Method.invoke(Method.java:620)

    com.ibm.xml.xci.exec.BasicMutableDynamicContext$JavaMethodExecutable.execute(BasicMutableDynamicContext.java:984)

    com.ibm.xml.xci.exec.BasicDynamicContext$ExternalFunction.execute(BasicDynamicContext.java:361)

    xmap__default__getEmployee_WSe4f028e1595320a1_04__Common_Partition0.xslt2$24$getReturnAsXCICursor(com_ibm_xmlns_prod_xltxe_j_linetable)

    xmap__default__getEmployee_WSe4f028e1595320a1_04__Common_Partition0.module_3$24$$24$function$24$$7b$default$7d$getEmployees_submap$2d$1$resulttreestream(com_ibm_xmlns_prod_xltxe_j_linetable:12)

    xmap__default__getEmployee_WSe4f028e1595320a1_04__Common_Partition0.xmap__default__getEmployee_WSe4f028e1595320a1_04_$24$$24$function$24$__xquery_result_fun__$2d$3(com_ibm_xmlns_prod_xltxe_j_linetable:101)

    xmap__default__getEmployee_WSe4f028e1595320a1_04_.evaluate(xmap__default__getEmployee_WSe4f028e1595320a1_04_.java)

    com.ibm.xltxe.rnm1.xtq.xquery.drivers.XQueryExecutable.execute(XQueryExecutable.java:220)

    com.ibm.xltxe.rnm1.xtq.xquery.drivers.XQueryExecutable.execute(XQueryExecutable.java:97)

    com.ibm.broker.map.MapExecutable.execute(MapExecutable.java:418)

    com.ibm.broker.ct.mapping.MappingNode.evaluate(MappingNode.java:383)

    com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1451)]’

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

    Contact your IBM Integration Bus administrator. : JDBCCommon.java: 566: JDBCType4Connection::createNonXAConnection: :

    • ILIYA Dimitrov April 10, 2017

      Hi Gary,

      Could you please provide some details for your environment – what version of your database are you using, how did you set up your HRDB data definition (did you follow instruction from previous labs)? Was everything else working as it should?
      The error log above suggest that a connection to the database can not be established, which could be an intermitten problem if you had already used a database connection to set up the HRDB data definition.

      Thank you

Join The Discussion

Your email address will not be published. Required fields are marked *