Home » Tag Archives: MySQL (page 2)

Tag Archives: MySQL

Using MySQL autoincrement PK column in ADF Entity PK attribute

mysql-logo

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

mysql-logo

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

couchbase-logo

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

spring-data-logo

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 »

Caveats With MySQL Pagination

mysql-logo

We’ve all done pagination – it’s sensible for both lists in the UI and for processing data in batches. “SELECT (columns) FROM table LIMIT X, Y”. Possibly “SELECT (columns) FROM table ORDER BY some_column LIMIT X, Y”. What’s the caveat? Especially when working with an ORM and when processing batches, where order doesn’t matter, you are likely to omit the ...

Read More »

MySql connections autodrop after a certain hours

mysql-logo

MySql is configured to drop any connection which has been Idle for more than 8 hours. What is the implication of this? After you return to your deployed app after a gap of 8 hours (If default SQL parameters have not been changed), you will be greeted with an exception. How to solve this issue? Increase the wait_time parameter -Not ...

Read More »

Getting started with Quartz Scheduler on MySQL database

quartz-scheduler-logo

Here are some simple steps to get you fully started with Quartz Scheduler on MySQL database using Groovy. The script below will allow you to quickly experiment different Quartz configuration settings using an external file.                   First step is to setup the database with tables. Assuming you already have installed MySQL and ...

Read More »

Debugging SQL query in MySQL

mysql-logo

Recently I started writing SQL query for analyzing and debugging the production code. But I was surprised to see that some queries takes longer time to execute to achieve the same output. I did research and found some interesting stuff about how to debug the SQL query. I have a very simple table who’s definition is as following. In test ...

Read More »
Do you want to know how to develop your skillset and become a ...

Subscribe to our newsletter to start Rocking right now!

To get you started we give you our best selling eBooks for FREE!
Get ready to Rock!
To download the books, please verify your email address by following the instructions found on the email we just sent you.

THANK YOU!

Close