MSSQL server audit

By -
MSSQL Server Auditing on AWS RDS Enable MSSQL Server Auditing on AWS RDS To enable MSSQL server auditing on AWS RDS, please follow these steps: Login to AWS console and go to RDS. Create an option group under RDS > Option groups Give name as 'SqlServerAudit' Provide description as 'Option group for SQL Server audit' Choose the engine as same as the one used while creating the database in RDS. Choose the latest engine version. Save. Go to RDS > Option groups and select the radio button on the option group you just created Click on Add Option. Select SQLSERVER_AUDIT under “Option name” Choose the S3 bucket name where you want to keep the audit files once they grow more than the specified limit. Choose the appropriate IAM role with write access to the S3 bucket. Scheduling > Immediately and then click on “Add Option“.
Post a Comment

Unmarshall SOAP Message (XML) to Java Object using JAXB

By -

Hello Visitor,

In this blog post I will guide you to Unmarshall the SOAP message using JAXB to your Java Object.

You might have already tried it and some of you have got the below exception when unmarshalling a soap message, then this post will help you recovering the unmarshall error. 

javax.xml.bind.UnmarshalException: unexpected element 
(uri:"http://schemas.xmlsoap.org/soap/envelope/", local:"Envelope"). Expected elements are <{}Envelope>

Here is the SOAP message which we want to unmarshall to Java object:

  <soap:envelope xmlns:ns1="http://mynamespace.com/ns1" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
      <soap:body>
          <ns1:updatemydetails>
              <ns1:items>
                  <ns1:id>1</ns1:id>
                  <ns1:name>crazy coders</ns1:name>
                  <ns1:email>crazycoders4u@gmail.com</ns1:email>
                  <ns1:age>25</ns1:age>
              </ns1:items>
          </ns1:updatemydetails>
      </soap:body>
  </soap:envelope>

If you are facing the above exception then below are correct steps to unmarshall the SOAP message.

SOAPMessage message = MessageFactory.newInstance().createMessage(null, new ClassPathResource ("soap_message.xml").getInputStream());
JAXBContext jaxbContext = JAXBContext.newInstance(UpdateMyDetails.class);
Unmarshaller jaxbUnmarshaller = jaxbContext.createUnmarshaller();
UpdateMyDetails updateMyDetails = (UpdateMyDetails) jaxbUnmarshaller.unmarshal(message.getSOAPBody().extractContentAsDocument());

Hope it helps.

Comments

  1. AnonymousDecember 20, 2016 at 2:27 PM

    this is calling the default constructor of UpdateMyDetails

    ReplyDelete
  2. UnknownJuly 8, 2018 at 2:40 AM

    Hi can get the pojo class?

    ReplyDelete
  3. Thankful GuestOctober 19, 2018 at 6:54 PM

    Thank you very much for this code!!

    ReplyDelete
  4. UnknownDecember 23, 2019 at 8:43 PM

    I am facing the same issue. Thanks a lot for the help

    ReplyDelete
  5. UnknownMay 25, 2020 at 5:48 PM

    It works for me, thanks a lot!

    ReplyDelete
  6. globleknowlegdeMay 11, 2021 at 11:32 AM

    it works

    ReplyDelete
  7. AnonymousMay 12, 2022 at 1:17 AM

    Works for me. Thanks a lot!

    ReplyDelete
  8. AnonymousNovember 30, 2023 at 2:01 AM

    Man, you're F genius!!! Thx a lot

    ReplyDelete

Post a Comment

Popular posts from this blog

Circuit breaker implementation in spring boot2

By -
Image
What is it Circuit breaker is a design pattern used in modern software development. It is used to detect failures and encapsulates the logic of preventing a failure from constantly recurring, during maintenance, temporary external system failure or unexpected system difficulties. The Circuit breaker pattern helps to prevent such a catastrophic cascading failure across multiple systems. The circuit breaker pattern allows you to build a fault tolerant and resilient system that can survive gracefully when  key services are either unavailable or have high latency. White box libraries There are many libraries which claim that they have successfully implemented the Circuit Breaker Design Pattern. Few of them are: Hystrix : Opensource Library designed by Netflix. This is the best library available as of today but it  is no longer in active development, and is currently in maintenance mode. Because of this reason we have kept it out from our scope. Sentinel : Opensource Library designe
Read more

Hibernate inserts duplicate child on cascade

By -
At times we all use hibernate's cascade feature to cascade the child entries into database for OneToMany and ManyToMany relationships. If it is a first entry in DB then everything works fine but when we want to update the number/quantity of child of an existing parent, hibernate adds duplicate children. Assume the parent already exists with few children. Below is the relationship: Parent Mapping for OneToMany with Child: @OneToMany(targetEntity = ChildrenImpl.class, mappedBy = "parent", orphanRemoval = true, fetch = FetchType.LAZY) @Cascade(value = CascadeType.ALL) private List<Children> children = new ArrayList<Children>(); Child Mapping with parent ManyToOne @ManyToOne(targetEntity = ParentImpl.class, fetch = FetchType.LAZY) @JoinColumn(name = "PARENT_ID") private Parent parent; Below is the code which leads to duplicate children. Children newChild = new ChildrenImpl(); newChild.setName("I am a new child"); /* More setters here *
Read more