
Posted In: DB2, Java Core, JDBC
DB2: Java Inserting data using stored procedure
Accesing and executing DB2 stored procedure using Java JDBC Inserting data into sample COUNTRY table: Table Schema: COUNTRY_CODE VARCHAR(20) COUNTRY_NAME VARCHAR(30) Crating a db2 stored procedure Java Code
Read More
Posted In: Database, JDBC
DB2 : Java Accessing the resultset returned from Stored Procedure
Taking sample example of Countries, we will return the list of countries from stored procedure matching the required criteria Creating Table Inserting Sample Values: Writing Stored Procedure: Instead of fetching rows in a loop by the fetch statement, you can return a complete result set to the calling client program. the stored procedure […]
Read More

Posted In: cpanel, Database, MySQL
cpanel – Host xxx is not allowed to connect to this MySQL server
When connecting to hosted DB server from local MySQL client you may get “Host xxx is not allowed to connect to this MySQL server”. To resolve you need to add the IP to MySQL remote access hosts settings Error Open cpanel and go to Remote MySQL Add host IP
Read MoreTags: Setting your own hosted Java website/application

Posted In: Database, MySQL
MySQL AUTO_INCREMENT column
In case you worked most of life on Oracle DB you must be wondering where is the SEQUENCE. AUTO_INCREMENT column in MySQL is used for primary key column. For each insert MySQL will automatically update the column to next max value. For each new row, MySQL increments the value automatically and persist it to table. […]
Read More
Posted In: Database, MySQL
MySQL table names are case sensitive
I have own product called www.labworkflows.com. After moving application from my Windows local environment to Linux CentOS server I observed lot of my queries stopped working. e.g. select * from LABTESTS works on Windows default MySQL installation but dis not work on CentOS. After digging more into it observed that scripts that I generated through […]
Read More
Posted In: Database, MySQL, Testing
How to import test data into MySQL table using csv file
Tools Used 1. MySQL Workbench 2. http://www.generatedata.com/ Let us first create test data CSV file Now import using MySQL Workbench
Read MoreTags: MySQL Workbench
- Apache (13)
- Build Tools (2)
- Gradle (2)
- Caching (1)
- cpanel (1)
- cURL (1)
- Database (7)
- Hibernate (5)
- Java Core (38)
- Java Script (15)
- Bootstrap (1)
- File Upload (7)
- jQuery (3)
- React (3)
- JEE (13)
- JSON (41)
- GSON (13)
- Jackson 1X (1)
- Jackson 2X (12)
- jsoniter (1)
- Logging (2)
- Apache Commons Logging (1)
- Apache Log4J (1)
- Logback (1)
- SLF4J (1)
- MongoDB (1)
- OS (1)
- Linux (1)
- Security (5)
- Server (4)
- Tomcat (4)
- Service (2)
- Micro (2)
- Spring (46)
- Pattern (2)
- Spring Boot (20)
- Spring Data (4)
- Spring MVC (8)
- Spring REST (13)
- Spring Security (7)
- Testing (11)
- XML (5)
- JDOM XML Parser (1)