Home » Tag Archives: MySQL (page 3)

Tag Archives: MySQL

MySQL Transaction Isolation Levels and Locks

Recently, an application that my team was working on encountered problems with a MySQL deadlock situation and it took us some time to figure out the reasons behind it. This application that we deployed was running on a 2-node cluster and they both are connected to an AWS MySQL database. The MySQL db tables are mostly based on InnoDB which ...

Read More »

How to create MySQL DataSource in WebLogic Server

One cool thing about using an application server is that it allows you to create DataSource outside of your application and it can manage it along with thread pool and transaction manager etc. With WebLogic Server, it comes with quite a few built in JDBC drivers such as Oracle Database and MySQL etc ready for your use. Here I will ...

Read More »

Using MySQL autoincrement PK column in ADF Entity PK attribute

Hello all. Continuing with the ADF + MySQL workaround series, today we are going to see what we need to do in order to use MySQL PK autoincrement columns with our ADF Entities PK attributes. If we were using Oracle database, we would use the oracle.jbo.domain.DBSequence along with a sequence and a trigger in order to do that out-of-the-box. For simplicity, we ...

Read More »

Configuring MySQL for ADF development

Hi all. Today I’m going to show you how to configure MySQL database for Oracle ADF development. IMHO when you are using ADF with other databases rather than Oracle DB you won’t be able to use the full power of Oracle ADF and sometimes you’ll find yourself looking for workarounds in order to achieve some behavior that with Oracle DB ...

Read More »

SQL to NoSQL : Copy your data from MySQL to Couchbase

Introduction During my last interactions with the Couchbase community, I had the question how can I easily import my data from my current database into Couchbase. And my answer was always the same: Take an ETL such as Talend to do it Just write a small program to copy the data from your RDBMS to Couchbase… So I have written ...

Read More »

Spring JPA Data + Hibernate + MySQL + Maven

Development of web-applications with the help of Spring MVC implies creation of several logical layers of architecture. One of the layers is a DAO (Repository) layer. It is responsible for communication with a database. If you developed the DAO layer at least once, you should know that it involves a lot of boilerplate code. A Spring Data take a part ...

Read More »

Spring MVC: Security with MySQL and Hibernate

spring-interview-questions-answers

Spring has a lot of different modules. All of them are useful for the concrete purposes. Today I’m going to talk about Spring Security. This module provides flexible approach to manage permitions for access to different parts of web-application. In the post I’ll examine integration of Spring MVC, Hibernate, MySQL with Spring Security. A regular case for any web-application is ...

Read More »