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

Mule - Bypass all requests through proxy like Charles

By -

Hello,
Many times during development of a Mule application we need to see the request and response which Mule receives/sends to another flow/endpoint. Its very easy in Mule to bypass all the calls through any Proxy server. You just need to add 1 connector in your mule flow xml file and then Mule will send all the requests to Proxy server. Below is the connector

<http:connector name="localproxy" proxyHostname="127.0.0.1" 
proxyPort="8888" doc:name="charlesproxy"></http:connector>

This example is of using a local proxy server like Charles which runs on port 8888 on localhost. You can also use remote proxy by providing remote proxy host name in proxyHostname tag and port of that server.

Make sure you remove this proxy connector for production version of your Mule application.

Thanks.

Comments

Post a Comment

Popular posts from this blog

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>
Read more

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