Challenges of microservices architectures
Below are some of the challenges of microservices architecture and proposed solutions: 1. Inter Services Communication — MicroServices will rely on each other and they will have to communicate. A common communication channel needs to be framed using HTTP/ESB etc. There are the different way to communicate microservices – a. Point…
Using JDBC for DB2 connectivity
As part of IBM’s “Java Everywhere” strategy, IBM has provided the OS/390 Java programmer with two access mechanisms to access DB2 data. In this article I’ll explain how to make DB2 connection using JDBC. First of all you need to download driver. You can download respective db2jcc or db2jcc4 jar file…
How to pull Jira Report into Excel
In IT industry we are using Jira for tyask management and we need to pull status reports frequently. Below are the steps can be used to get the report from Jira into Excel: Login to https://jira.mycompany.com Create a filter to get your selected issues and desired. (Example URL: https://mycompany.atlassian.net/issues/?filter=12345 ) Selected…
How to get desktop path in java
There two ways to achieve this: By using user.home property String path = System.getProperty(“user.home”) + File.separator +”Desktop”; By using FileSystemview FileSystemView view = FileSystemView.getFileSystemView(); File file = view.getHomeDirectory(); String path = file.getPath();
How to Export Mysql database to .sql file?
Install the mysql workbench 8.0 and follow the below steps after connecting to your database Step1 : Below is the screen which you will get after connecting to your database instance. Highlighted is the schema which needs to be exported into a file (.sql file) Step2 : Click on left tab…
Generating the OTP in python
There are generally combination of 4 or 6 numeric digits or a 6-digit alphanumeric. random() function can be used to generate the random OTP which is predefined in random library. You can use the below code to generate the OTP in python code,
Send an email through Amazon SES programmatically from Python
Before you begin, perform the following tasks: Verify your email address with Amazon SES—Before you can send an email with Amazon SES, you must verify that you own the sender’s email address. If your account is still in the Amazon SES sandbox, you must also verify the recipient email address. The…
Using restassured to call API behind proxy
In most of the organisations we have proxies and while using restassured we face “java.net.ConnectException: Connection timed out” or “java.net.ConnectException: Connection refused” error as proxy does not allows the traffic. To resolve same we need to set the proxy settings before making the call. To do the same there are two…
The import io.restassured.RestAssured cannot be resolved
While consuming restassured maven dependencies it has been observed that even after downloading the dependencies eclipse is not able to resolve io.restassured package. Maven repository (https://mvnrepository.com/artifact/io.rest-assured/rest-assured) has the scope set to test in the dependency tag. This limits your code from accessing that dependency’s classes within your source code. That is,…
TestNG by default disables loading DTD from unsecure Urls
While executing TestNG sometime we hit below error: org.testng.TestNGException: TestNG by default disables loading DTD from unsecure Urls. If you need to explicitly load the DTD from a http url, please do so by using the JVM argument [-Dtestng.dtd.http=true] at org.testng.xml.TestNGContentHandler.resolveEntity(TestNGContentHandler.java:102) This can be sol;ved using 3 ways. 1. First and…
How to setup Selenium & Gecko driver on MAC
Step 1. Install Selenium Create a maven project and add dependency for Selenium. To get maven details open https://mvnrepository.com/search?q=selenium. This will list down all selenium related repositories. Select selenium java and select latest version. You can find the maven details like: <!– https://mvnrepository.com/artifact/org.seleniumhq.selenium/selenium-java –><dependency> <groupId>org.seleniumhq.selenium</groupId> <artifactId>selenium-java</artifactId> <version>3.141.59</version></dependency> Step…
Write to local file system using a postman collection
There are situations when you want to write the API response on local file system. So here I am explaining how to do that. Basically there are two ways to do it. One is by using node js scrip and another way to start a local server which accepts postman requests.…
Performance Testing
Performance testing is a form of software testing that how an application is performing in a defined environment under specified load. Performance Testing is conducted to evaluate the compliance of a system or component with specified performance requirements. It checks the response time, reliability, resource usage, scalability of a software program…
Starting with Git in simple steps
Version Control System (VCS) To understand the git first let’s understand the version control system (VCS). VCS is a system that records the changes to file or set of files over time so that one can recall specific versions later on need basis. The complete version history get stored on a…
Tips to analyse logs using unix commands
I have seen many developer struggling to analyze the logs on unix. They download the files and then open file in editors which is not efficient way to analyze the logs. Task can be achieved with much easier way using commands. First thing I advise to use bash command before starting,…
How to access request body in postman
I have received few questions on how to access the Postman Request body in case we need to compare the request and response. So here is the quick answer, just use pm.request.body to access the request body. For example you need to save User ID in variable and the you can…
Sending message from python using msg91
Below is tested code which can be used for sending the sms(message) from python application. As a pre-requisite you need to have an account on http://control.msg91.com
How to use date and timestamp in postman
Many times we need to pass timestamp or date as request parameter. One way is to use predefined variable like {{$timestamp}}. But this can not be used when it’s needed in specific format. So to achieve that we should use ‘Pre-Request Script’ option. Use below code in pre request script. Here…
Difference between Springboot 1.X and Springboot 2.X
We have been using Springboot 1.X in our applications and recently started coverting the existing code to use new springboot2.X version. Moving to Spring Boot 2.X will upgrade a number of dependencies hence some of our code needs to be changed. Below are the advantages or new features we came across,…
Fundamentals of Microservices Design
Define the correct microservice scope When we talk about the scope of a microservice, we are referring to the features of an independent software module. The ability of microservices to perform as a nearly-stateless system allows it to be developed independently. Create a unique service which will act as an identifying…
Features of Spring Boot
What are important features of using Spring Boot?
Agile Methodology of Development
Agile is a software development methodology to build software incrementally using short iterations of 1 to 4 weeks so that the development is aligned with the changing business needs. Whereas the traditional “waterfall” approach has one discipline contribute to the project, then “throw it over the wall” to the next contributor,…
How to create new laravel project ( new php application )
You need to follow the below steps for creating new laravel project ( or new php application ) Step 1: Install Composer Go to https://getcomposer.org/ and download Windows installer. Step 2: If your installation is successful, by running composer on command prompt, you will see all kinds of info just by…
Hystrix (Circuit Breaker )
Hystrix in spring cloud is the implementation of Circuit Breaker pattern, which gives a control over latency and failure between distributed micro services. Here main idea is to stop cascading failures by failing fast and recover as soon as possible. Netflix created Hystrix library implementing the Circuit Breaker pattern to address…
Feign Client
Netflix provides Feign as an abstraction over REST-based calls, by which microservices can communicate with each other, but developers don’t have to bother about REST internal details. 1.Add the feign dependency to your project e.g. <dependency> <groupId>org.springframework.cloud</groupId> <artifactId>spring-cloud-starter-feign</artifactId> </dependency> 2.Tell to…
Why Spring cloud is required?
When we develop microservices with Spring Boot , we might face the below mentioned issues hence spring cloud project helps to eliminate these issues.Spring cloud is set of tools to manage and establish the service Discovery, config management and Circuit Breakers etc. It manages and handles following very efficiently, 1. Any…
Is there a way to make npm commands work properly behind a proxy?
Is there a way to make NPM commands work properly behind proxy? I was trying to install the angular library using the NPM but seems due to proxy issue its not able to download from internet. Can someone please help?
How to check the apache config on ubuntu
You can run the below commands to test and check the status of apache configuration. This will list the incorrect configuration or apache config which is breaking to start the apache, Go to apache installation directory, – cd /etc/apache2 type the command – apache2ctl configtest
Installing apache, mysql and php on ubuntu
1.login using the putty to server ( You need to generate a key if using the AWS ) 2.Use the host name as ubuntu@publicip or instance name of server and select the key under auth generated from AWS 3.switch to root user by running the command sudo su 4.get the latest…
Mcrypt PHP extension required or PHP7 is missing mcrypt or PHP missing mcrypt module
Please note that higher releases of PHP ( PHP 7.1 or PHP 7.2 + ) do not support this module anymore. This has been eliminated. We need to use the php 7 if you want to use this module inside your project, follow the below steps after switching back to php…
JVM (Java) and it’s Memory Management
JVM (Java Virtual Machine) is an abstract machine or can say it is a software implementation of a Physical Machine. It is a specification that provides runtime environment in which java bytecode can be executed. JVMs are available for many hardware and software platforms (i.e. JVM is platform dependent). What is…
Difference between Git and SVN
Version Control System A version control system (VCS) helps you to make changes in source code of the project and upload those to some central repository to keep the history of changes safe and remain available for other people of the project in order to get the updated code or merge…
REST Service
How we can design a REST service which returns both JSON and XML depending on the request header?
What is Ajax?
Ajax The term Ajax is used to describe a set of technologies that allow browsers to provide users with a more natural browsing experience. Before Ajax, Web sites forced their users into the submit/wait/reload paradigm, where the users’ actions were always synchronized with the server’s “think time. “Ajax provides the ability…
Java OOPs
What are the principle concepts of OOPS? There are four principle concepts upon which object oriented design and programming rest. They are: Abstraction Polymorphism Inheritance Encapsulation (i.e. easily remembered as A-PIE). What is Abstraction? Abstraction refers to the act of representing essential features without including the background details or explanations. What…
Difference between Static and Dynamic Web Content
Static contents : The contents of the Web page which do not change frequently irrespective of user who is requesting or the time at which request has been sent. Working of the Web Application (Static Contents): The user send the request by typing the specific URL in the client browser. The…
How to paste lotus notes link into outlook email
These days many companies switching from lotus notes to Outlook and so we get frequently need to paste notes link into outlook email. In this article I’ll be explaining how to create custom button which can paste lotus notes link into outlook email. You can download vba project VbaProject. Extract VbaProject.OTM at C:\Users\<User>\AppData\Roaming\Microsoft\Outlook or…
Generics in Java
Generics Many algorithms work in a similar way irrespective of the data types on which they are applied on All Stacks work in a similar way irrespective of the type of object they hold Generics help to write algorithms independent of a data type These algorithms can be applied to a…
How to pass parameters in downstream jenkins jobs
I got a question how to pass parameter in trailing jobs. Jenkins 2.0 provides option to use Jenkinsfile. Takes in parameter “Task_Name” Runs Job-1 and pass in parameter “Task_Name” to it Upon successful run of Job-1, it will trigger Job-2 and pass in the “Task_Name” parameter Note that Job-1 and Job-2…
Collection Framework in Java
The Collection Framework is a set of classes and interfaces Helps in handling groups of objects Standardizes the way in which groups of objects are handled The important interfaces of the Collection Framework are Collection List Queue Set SortedSet All these interfaces are generic interfaces Collection interface declares the methods that…
Exceptions and Errors in Java
Exception Exception is an exceptional case that can happen in a program An Exception occurs during the execution of a program and disrupts the normal flow of instructions. When there is an exception Normally the program crashes and prints a system generated error message Not acceptable in a mission critical application…
Testing SOAP Services with WS-Security using SOAPUI
Web Services Security (WSS): SOAP Message Security is a set of enhancements to SOAP messaging that provides message integrity and confidentiality. WSS: SOAP Message Security is extensible, and can accommodate a variety of security models and encryption technologies. WSS: SOAP Message Security provides three main mechanisms that can be used independently…
Error while decryption of SOAPUI response- “Error Getting Response :null”
In SOAPUI in many cases when we apply the wss keystore for decryption it hits error and shows message: “Error Getting Response :null”. But shows nothing in SOAPUI logs and blank output screen. When you remove Incoming WSS it shows the encrypted response. To solve this you can try below steps:…
Thread and its various states in Java
What is Thread A thread is a single sequential flow of control within a program Facility to allow multiple activities within a single process Referred as lightweight process Each thread has its own program counter, stack and local variables Threads share memory, heap area, files Why to use Thread To…
Difference between Abstract Class and Interface
Abstract Classes Interfaces Can have concrete methods Can have only abstract methods Can have variables Can have only static final (constant) data members Can have private and protected members All members are public by default Can be extended from one class Can be extended from any number of interfaces A class…
Anonymous Inner Class in Java
An inner class is a class defined within another class. An inner class is a non-static nested class. It has access to all of the variables and methods of its outer class. An inner class is fully within the scope of its enclosing class. An anonymous inner class is a class…
Newman – Command line integration with Postman
To run the test from command line window, Postman has newly npm Package (Newman). Here quick steps to start with newman: Install latest version of Node (Node.js) in the computer. Download the Windows installer from the js® web site. To see if NPM is installed, type npm -v in command prompt.…
Postman Collections and organizing test using collections
A Postman Collection allow you to group together several APIs that might be related or perhaps should be executed in a certain sequence. You can organize these requests in folders as well. Basically collections server 4 purposes: Organization of tests, Documentation, Test Suit creation, and designing conditional workflows. How to create…
What is IOC or Dependency Injection ?
Can you please explain IOC concept?
Overriding Hosts file using Fiddler
Configure a domain name instead of localhost:8080 (server ip:port) This is similar to what we have been doing with windows Hosts file (Windows\System32\drivers\etc\hosts). Due to some limitation, in some cases you can’t specify the port number in hosts file along with the IP address to map with a DNS name and there we…
Writing Tests in Postman
Using postman we also can write test cases or build request using java script code. This code can use dynamic parameters, variables, or pass data between different requests. It allows us to write javascript code at two events: Before request sent to server, we call it Pre-request script and can be…
Analyzing http and https traffic using fiddler
Fiddler tool can be used for analyzing HTTP and HTTPS (must be enabled from within the fiddler tool) transactions. This tool is a simple to use and by following below tips you can capture and analyze the request and network traffic causing any performance issue. Also you can send the captured…
Azure WebApp: Different ways to deploy website on Azure
I am here again with a new article. In this Article I am going to talk about the deployment of websites on Azure. There are lots of article available regarding this topic. I am trying to document all the different ways of the deployment of website in this Article. You will…
API Testing with Postman
These days all new web applications are being developed using service based architecture. There are many tools for API testing like SOAP UI, Parasoft SOAtest and Postman. Postman is available as a native app for Mac, Windows, and Linux operating systems. In this tutorial, we’re going to walk through the different…
Url Encoding and Decoding in Java
URL encoding/decoding in java is very useful while working with the URL which is transmitted through the network. In case your URL contains some special characters in it then it might get replaced with some other special character. Few important notes, Always use the same scheme to encode and decode the…
Recording Traffic in Parasoft Virtualize using Message Proxies
Virtualize can record live behavior of dependent system components—database queries and responses or traffic over HTTP, JMS, or MQ—then represent that behavior as a Virtual Asset. Once the Virtual Asset is created and deployed, it can emulate the captured behavior—enabling you to cut the dependencies on system components that are difficult…
Working with Message Proxies in Parasoft Virtualize
Message Proxies and benefits Message proxies are the tools Parasoft virtualized used to record live system behavior and redirect to the desired endpoints (Real or Virtual). Message proxies listen the traffic going via Parasoft Virtualize and on the basis of configuration either redirect to real end points or redirect to virtual…
Scrum – Agile Methodology
Scrum is an agile methodology to manage and control software development where change occurs rapidly (changing requirements, changing technology). Here focus area is on improved communication and maximizing cooperation. Scrum Roles – Product Owner -A Product manager who actually knows what needs to be built and in what sequence this should…
Difference between Scrum and XP (Extreme Programming)
There are small but important differences between Scrum and XP (Extreme Programming). These methodologies are definitely much aligned. In fact, if you have to choose between these two then it’s very difficult? Below are some important differences between these two, Scrum teams typically work in iterations (called sprints) that are from…
Automation advantages in Agile? Why automation is needed in Agile?
Now a day’s, agile development and testing are growing broadly and smart QA/Testing team always keep themselves with current trends and technology. Automation is a critical component to maintain agility. Continuous integration/builds, unit, functional & integration test execution and automated deployment are common examples of applying automation. While working in SCRUM/XP,…
Microservices and their key benefits
Microservices are a kind of software architectural solution that allows software to be developed into relatively small, distinct and loosely coupled components. Each of the components provides a distinct subset of the functionality of the entire application. Each microservice, can then be designed, developed, and managed independently. This allows for distributed…
What is an intern() method in the String class?
What is intern() method in the String class?
SOAP and REST web service comparison
SOAP stands for Simple Object Access Protocol. REST stands for Representational State Transfer. SOAP is a XML based messaging protocol and REST is not a protocol but an architectural style. REST does not enforces message format as XML or JSON etc. Since SOAP messages are wrapped in a SOAP envelope it…
Java Performance Tuning Tips
Sometime we need to improve the performance of our application into our code. Below are the recommendations for Java code tuning. Don’t optimize before you know it’s necessary Use a profiler to find the real bottleneck Work on the biggest bottleneck first Managing Objects Here, idea is used to use garbage…
ACID Properties – DBMS Transaction
ACID Properties are considered to be the desirable properties of any transactions.When in a database system more than one transaction are being executed simultaneously and in parallel then system maintains the below properties in order to ensure the data accuracy and integrity. A-Atomicity if something unexpected happens in the middle of…
Analysing and fixing Java Heap related Issues
Java Heap related issues can cause severe damage to our application and we might see poor user experience. Java Heap is memory used by your application which is used to create and store objects. We can define the maximum memory for heap by specifying -Xmx<size> by setting the java variable. When…
Using DUAL table in Oracle
DUAL is a special table found in some of the databases e.g Oracle, Informix and DB2 etc. MySQL, Microsoft SQL (MS SQL) does not have this table moreover MySQL allows DUAL to be specified as a table in queries that do not need data from any tables.In oracle, this DUAL table…
Difference between x-www-form-url-encoded and multipart/form-data MIME types
I am new in API testing. I want to know what is the difference between x-www-form-url-encoded and multipart/form-data MIME types.
How to copy one schema into another using SQL
Some times we don’t have the DBA access and need to copy data from one schema to another. You can perform that by executing migration SQL script in Oracle XE. Step 1. Generate migration script. SELECT table_name, (‘Select ”’||TABLE_NAME||”’ as tbl from dual;’ ||CHR(10)||’delete from <TARGET_SCHEMA>.’||TABLE_NAME||’;’||CHR(10)|| ‘insert into <TARGET_SCHEMA>.’||TABLE_NAME|| ‘ select…
How to resolve Base Site Template (BST) propagation in Liferay
I am facing an issue with Liferay Base Site Template propagation. I turn on the propagation but nothing happens in the logs and propagation does not happen. Can you please help?
Application Performance Management Tools
Depending on which language/technology your application is built on, there are several tools you could use for this. To fully manage and monitor the performance of an application, it requires collecting and monitoring a lot of different types of data. Below are important components of a complete application performance management tool, Performance…
Defining Performance and Performance Tuning
Why is My Application slow? When we find that after an application is deployed, it is not performing as desired. In other words it’s not meeting non-functional requirements. This application now requires some fixes that may correct the problem. The process of refactoring an application to improve its performance is called…
Test Driven Development
TDD is just about writing the test before the program. In other words, first think about “how to use” any component, why do we need this component or what’s it for? And only then think “how to implement”. Hence we can say, it’s a testing techniques as well as design techniques.…
Creating First Parasoft Virtual Asset
Now we know Parasoft Virtualize concepts. Today we will experience the magic of virtualization by creating our first virtual asset and testing it. First of all create an empty project as follows: Open the pull-down menu for the New toolbar button (top left) then choose Project. Choose Virtualize –> Empty Project,…
Getting started with Parasoft Virtualize
Exploring Parasoft Virtualize UI Parasoft Virualize is based on Eclipse Workbench. Prasoft has developed and integrated several perspectives. For ex: The Virtualize Perspective The Event Details Perspective The Change Advisor Perspective Let’s explore each perspective. The Virtualize Perspective The Virtualize perspective, which is built into the Eclipse workbench, provides a set…
Basic Java constructs
Java is a strongly typed language, which means that all variables must first be declared before they can be used. The basic form of variable declaration is “Variable Type followed by variable name”. For example “int myVar;” Doing so tells your program that the variable named “myVar” exists and holds numerical data[…
New features of various java releases and their comparison
Java is the choice of many software developers for writing applications. It is a popular platform that provides API and runtime environment for scripting and running enterprise software, including network applications and web-services. Oracle claims that Java is running in 97% of enterprise computers. Each Java programmer must know about these new…
Parasoft Virtualize Installation
You can download Virtualize CE or Enterprise edition from the Virtualize product page. For CE all it takes is supplying an active email address where the download link will be sent to. It’s quite a big download at 1.1 GB, but this has a reason: it includes the full version of Virtualize,…
Service Virtualization Tools
A couple of years ago, I took my first steps in the world of service virtualization when I took on a project where I developed stubs (virtual assets) to speed up the testing efforts and to enable automated testing for a telecommunications service provider. I started looking for the tools available…
Installing java SDK and writing first java program
Installing and using Java Install the java SDK from below location and follow the installation instructions, http://www.oracle.com/technetwork/java/javase/downloads/index.html Setting environment variable for Java Environmental variable is a variable that describes the operating environment of the process. Common environment variables describe the home directory, command search path etc. JAVA_HOME JAVA_HOME is a environment…
Core Java Architecture and JVM
In this lesson, we are going to explain the core Java Architecture. Java Java was conceived by a team of engineers in Sun Microsystems in 1991 as a part of a research project, which was led by James Gosling and Patrick Naughton. It was initially called Oak but was renamed as…
Object oriented concepts used in Java
Java is an Object-Oriented Language hence before learning java let us understand the object oriented Concepts first. Object An object in the software world means a bundle of related variables and functions known as methods variables and functions known as methods. Software objects are often used to model real-world objects you…
Service Virtualization
What Is Service Virtualization? Service virtualization lets you create a simulated version of a service. The simulated version is referred to as a virtual service. The virtual service does not need to duplicate all the functionality of the actual service. Service virtualization is a method to emulate the behavior of specific components…
VSAM FAQs
VSAM FAQ Q1. What are the types of VSAM datasets? A1. Entry sequenced datasets (ESDS), key sequenced datasets (KSDS) and relative record dataset (RRDS). Q2. How are records stored in an ESDS, entry sequenced dataset? A2. They are stored without respect to the contents of the records and in the…
Bug Life Cycle
Life cycle of Bug Log new defect When tester logs any new bug the mandatory fields could be: Build version, Submit On, Product, Module, Severity, Synopsis and Description to Reproduce In above list you can add some optional fields if you are using manual Bug submission template: These Optional Fields are: Customer name, Browser,…
JCL FAQs
Here list of frequently asked questions about JCL. How many levels of nesting is allowed in PROCs? Ans: 15 If the “DISP=” keyword is not coded for an existing dataset, what default values will be used for “DISP=”? Ans: If the “DISP=” keyword is not coded ,then the DEFAULT Values are…
How to integrate elastic search with spring boot application
We can use elastic search with spring boot application and for this below are the detailed steps which can be followed. (Please note there some compatibility issue with some version of elastic search hence choose the appropriate one as per your need, I have used the version 2.4.0 with my spring…
How to create custom page template in WordPress
Custom page template should be used when you want a different layout on any page. There can be multiple reasons for actual uses in your site created on wordpress. This is simple and can be done by following below steps , you just need simple knowledge about php, html and css.…
Email validator in java
You can use the below validator class for email address in your java projects, /* Email Validator */ package com.tms.utility; import java.util.regex.Pattern; /** * * @author aarnav */ public class EmailValidator { private static final String EMAIL_PATTERN = “^[_A-Za-z0-9-\\+]+(\\.[_A-Za-z0-9-]+)*@” + “[A-Za-z0-9-]+(\\.[A-Za-z0-9]+)*(\\.[A-Za-z]{2,})$”; public EmailValidator() { } /** * Validate hex with regular…
Converting a number to english word in java
You can use the below java class to convert a number to english word, /* * Number to English word converter */ package com.tms.utility; /** * * @author aarnav */ import java.text.DecimalFormat; public class EnglishNumberToWords { private static final String[] tensNames = { “”, ” ten”, ” twenty”, ” thirty”, “…
How to find index or constraint in Oracle?
I am using liferay and many times I see the error stating index name or constraint names SYS_C00381400 or IX_C7057FF7. But don’t know how to find the actual table impacted so that I can fix it.
How to sign SOAP request in Jmeter
In this post we will see how to test a SOAP web service in JMeter. Using JMeter, we can do both functional testing as well as load testing of a SOAP web services. As we know that web services are headless so, we can’t use the record and playback feature of…
How to write to local file system using a postman collection java script
Ensure that you have node and npm installed. Install newman with: npm install newman. Create a file with the following contents: var fs = require(‘fs’), newman = require(‘newman’), results = []; newman.run({ reporters: ‘cli’, collection: ‘/path/to/collection.json’, environment: ‘/path/to/environment.json’ // This is not necessary }) .on(‘request’, function (err, args) { if (!err) { // here, args.response represents…
Changing the forgotten password of System
Use the below SQL query by logging with sysdba account, alter user system identified by “newpassword”;
SQL query to search in CLOB field
You can use below SQL query to search a string in CLOB object stored in database, select * from tablename where dbms_lob.instr(clob column name , ‘search string’ )>0;
How to get file name from HttpServletRequest
You can use the below java method which returns the file name from part private String getFileName(Part part) { for (String content : part.getHeader(“content-disposition”).split(“;”)) { if (content.trim().startsWith(“filename”)) { return content.substring(content.indexOf(‘=’) + 1).trim().replace(“\””, “”); } } return null; }
Deep copmpare of JSON
Hi, I need to deep compare two json objects. Need js function.
Recover oracle database from error ORA-00333
To restore the oracle from ORA-00333: redo log error , you need to follow the below steps, SQL> connect system Enter password: ERROR: ORA-01033: ORACLE initializatio Process ID: 0 Session ID: 0 Serial number: 0 ORA-00333: redo log read error block 767 count 7428 SQL>connect sys as sysdba password SQL> startup SQL>select l.status,…
Integration of Rich File Manager with ckeditor
This article is helpful to those developers or programmers who are facing the issues with file upload functionality and are using the ckfinder a paid service. Rich file manager is open source and is free to use. You can follow the below steps to integrate this with ckeditor in your spring…