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

by , on April 20th, 2018

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

by , on April 19th, 2018

Posted In: Database

How to concatenate db columns

MySQL Oracle PostgreSQL MongoDB

Read More

by , on November 20th, 2017

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 More

Tags:

by , on September 20th, 2017

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

by , on August 24th, 2017

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

by , on August 21st, 2017

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 More

Tags:

by , on March 28th, 2017

  • Categories