App Connect

 View Only
  • 1.  MongoDB implementation and Connectivity

    Posted 12 days ago

    we are implementing MongoDB as are second Database to store data to decrease are queue size but achieving that on Server we are facing connection issues.
    we implement same setup in are local environment which is running smoothly but we are enable to implement the same on server

    To connect to MongoDB, we are not using any JDBC ODBC Drivers.

    What we performed was:

    We Created one JAVA Project in JAVA perspective in which we write a Code to insert into Data in MongoDB with some External Jar files, Next, we created a procedure to link our external Java code to Transformation Compute (ESQL code).

    We were able to successfully insert our data (100%) locally into MongoDB using the previously mentioned approach.

    But when we repeated the process on the server, we discovered that only three sets of data out of fifty were really entered into the database.

    Is there any way you might assist us in determining the reason our code isn't functioning on the server?

    We are getting following error in are MongoDB pod :-

    2024-04-23 18:06:05.423327: BIP5024E: An error occur during the generation of message schema and maps in 'DefaultApplication: Error from XLXP: sch-props-correct.2: A schema cannot contain two global components with the same name; this schema contains two occurrences of ',DocumentHeaderType'.'.
    2024-04-23 18:06:05.438585: BIP9318E: Request to 'PreSetupValidate' resource 'DefaultApplication', 'DefaultApplication' of type 'Application' failed.
    2024-04-23 18:06:05.438657: BIP5024E: An error occur during the generation of message schema and maps in '/home/abcuser/ace-server/run/DefaultApplication'.
    2024-04-23 18:06:05.438684: BIP4395E: Java exception: 'org.apache.xerces.xni.XNIException'; thrown from class name: 'com.ibm.broker.schemamgr.MbSchemaCompilerCL', method name: 'error', file: 'MbSchemaCompilerCL.java', line: '529'



    ------------------------------
    Saurabh Thorat
    ------------------------------


  • 2.  RE: MongoDB implementation and Connectivity

    Posted 10 days ago

    You have to make sure that you do the operations you need to do only once.  I had to do something similar with a different MQ provider (ActiveMQ) and had to write some java code to load everything upon startup and save booleans in memory to see if it was already present or not.

    Brian



    ------------------------------
    Brian S Paskin
    Sr. Technology Engineer
    IBM Cloud Engineering
    ------------------------------