Spring Data JPA simplifies database interactions in Java applications, by managing the complexity of object-relational mapping (ORM). At the hearth of this feature are annotation mapping Java objects to DB tables. In this reference, I explain how to use annotations such as @Entity, @Table, @Column, @Id, @ManyToOne, and more, using Read more…
This article provides a quick intro on how to set up an Oracle DB development environment on mac, Including installing the PL/SQL Developer tool and running Oracle XE on Docker. Tools To set up an Oracle development environment on mac, we need to 1. Install the PL/SQL developer and 2. Read more…
Installing MongoDB on Windows. Download MongoDB from its download page, and install it. I chose to install in C:\opt\MongoDB\Server\3.2. Create a folder for database and a folder for logs. Then create a mongod.cfg to represent this data. In my case, I put all under a new C:\data\ directory. And this is the Read more…
PL / SQL Some PL/SQL snippets of code backup and recovery of a table interactive input with & find keys referencing your table group and count list column names list available tables in a schema Backup and recovery of a table Create a backup copy of your table Restore the Read more…
This article introduces mybatis java (iBatis 3 for java) and summarizes its configuration and usage. The article also give suggestions on its usage. Introduction The iBATIS Data Mapper (born in 2002) is a framework that introduces SQL Mapping approach to persistence layer development. The iBATIS name and code was donated to the Apache Software Foundation; that hosted Read more…