Blog Archives
1 … 10 11 12 13 14 15 16 17 18

Notepad++ to construct SQL where clause

Let’s take a tutorial like scenario to demonstrate power of Notepad++ as a developer productivity tool.

This approach can be used in other text editors like sublime, atom, etc that support regular expression (i.e regex) based find & replace.

Q. How will you extract rule_name values from a tabular data shown below and convert it to a comma separated values that can be used in an SQL WHERE clause.

…

Read more ›



Orika Bean Mapping Tutorial

This tutorial compliments Basic Dozer Tutorial. Orika is another bean mapping framework.

Step 1: Create a simple Maven project from a command-line. Just press enter for all the prompts.

Step 2: Import the above “simple-orika” folder in the file system into eclipse.

…

Read more ›



Orika Bean Mapping with Spring

This tutorial extends Orika Bean Mapping Tutorial by using Spring to configure Orika.

Step 1: Create a simple Maven project from a command-line. Just press enter for all the prompts.

Step 2: Import the above “simple-orika” folder in the file system into eclipse.

…

Read more ›



Part #1: JPA Hibernate Spring Maven Eclipse Tutorial – setting up pom.xml

Any non trivial application needs to talk to databases. JPA is for ORM (Object to Relational Mapping) frameworks like Hibernate as JDBC is database connectivity.

The finished project artifacts are shown below, and it consists of Java classes, properties files, and Spring “JavaConfig” files with @Configuration annotation.

Let’s start with bringing in the dependent jar files via maven pom.xml in this part.

…

Read more ›



Part #2: JPA Hibernate Spring Maven Eclipse Tutorial – JPA configs and repository

This extends Part #1: JPA Hibernate Spring Maven Eclipse Tutorial. Spring wires dependencies with “MyDomainConfiguration” JavaConfig file. You have a Service Layer –> DAO (or Repository) Layer –> Entity (i.e. maps relational data to an object). … Read more ›...

This content is for 30-Day-Full-Access, 100-Day-Full-Access, 200-Day-Full-Access, and 365-Day-Full-Access members only. Register 80+ Free Java FAQs 80+ Free Big Data FAQs
Already a member? Log in here


Part #3: JPA Hibernate Spring Maven Eclipse Tutorial – testing data access with HSQLDB

This tutorial focuses on testing data access logic with spring-test and hsqldb. This extends Part #2: JPA Hibernate Spring Maven Eclipse Tutorial – JPA configs and repository Testing the mapping of entities managed by hibernate and wiring up of JPA, Hibernate, etc via Spring. Schema and mock data similar to...

This content is for 30-Day-Full-Access, 100-Day-Full-Access, 200-Day-Full-Access, and 365-Day-Full-Access members only. Register 80+ Free Java FAQs 80+ Free Big Data FAQs
Already a member? Log in here


Part 1: Creating an empty multi module maven project structure

Enterprise projects will have multi maven modules.

Step 1: Create simple-app-parent is a package of type “pom”

press “Y” for all the questions.

Step 2: cd into your newly created root dir “simple-app-parent”

Step 3: Create a child module “simple-app-service”,

…

Read more ›



Part 2- Adding dependency jars to multi-module MVN project

This extends Part 1: Creating an empty multi module maven project structure.

Dependency Management allows you to consolidate and centralize the management of dependency versions without adding dependencies which are inherited by all children. The dependencyManagement control the versions of artifacts used in transitive dependencies.

…

Read more ›



Part 3- Adding plugins to multi-module MVN project to perform specific tasks

This extends Part 1: Creating an empty multi module maven project structure and Part 2- Adding dependency jars to multi-module MVN project. The “pluginManagement” defines the settings for plugins that will be inherited by modules in your build. Let’s define the jaxb2 plugin in the parent pom file “simple-app-parent/pom.xml”

…

Read more ›



Passing Pentaho DI (i.e. Kettle) rows of data to Java layer (i.e. POJOs)

This extends the tutorials on Pentaho DI 1) Part 1: Pentaho with user defined Java transformer tutorial. 2) Part 2: Invoking a Pentaho DI (i.e. Kettle) transformation from Java. Step 1: Modify the flow in “Part 1” … Read more ›...

This content is for 30-Day-Full-Access, 100-Day-Full-Access, 200-Day-Full-Access, and 365-Day-Full-Access members only. Register 80+ Free Java FAQs 80+ Free Big Data FAQs
Already a member? Log in here


Pentaho with user defined Java transformer tutorial

What is Pentaho Data Integration (aka Kettle)? Pentaho Data Integration (or Kettle) delivers Extraction, Transformation, and Loading (ETL) feature. Similar to what Spring batch does, but Kettle has a graphical interface. In this tutorial, the transformer is defined as a user defined Java class. Step 1: Download Pentaho Data Integration...

This content is for 30-Day-Full-Access, 100-Day-Full-Access, 200-Day-Full-Access, and 365-Day-Full-Access members only. Register 80+ Free Java FAQs 80+ Free Big Data FAQs
Already a member? Log in here


Power of Excel spreadsheet to dynamically generate SQL

When you have some data in tabular (e.g. Excel spreadsheet) format and would like to insert into a database table, you need to write an SQL insert query. Manually writing SQL query for multiple records can be cumbersome. This is where Excel spreadsheet comes in handy as demonstrated below. A single SQL query can be copied down where the formulas get copied with incrementing column numbers.

…

Read more ›



Power of regex for productivity with Notepad++ or Sublime Text

This post is based on industrial strength examples of applying regular expression to increase your productivity as a software engineer. Many text editors like Notepad++, Sublime Text, Atom, etc support regular expressions in their find and replace functionality. If you are new to regular expression, practice at https://regexr.com/ or https://regex101.com/...

This content is for 30-Day-Full-Access, 100-Day-Full-Access, 200-Day-Full-Access, and 365-Day-Full-Access members only. Register 80+ Free Java FAQs 80+ Free Big Data FAQs
Already a member? Log in here


1 … 10 11 12 13 14 15 16 17 18

300+ Java Interview Questions - FAQs

Tutorials on Java & Big Data