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
CREATE PROCEDURE INSERT_CITY_MAS (IN countryCode VARCHAR(20), IN countryName VARCHAR(30)) LANGUAGE SQL BEGIN insert into COUNTRY values(countryCode, countryName); END
Java CodeĀ
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.*; public class TestSQLProcedure { public static void main(String[] args) { if (args.length < 1) { System.out.println("Usage: "); } try { // load the DB2 Driver Class.forName("com.ibm.db2.jcc.DB2Driver"); // establish a connection to DB2 Connection db2Conn = DriverManager.getConnection("jdbc:db2://HOSTNAME:PORTNO/DB_NAME","DB_USER_NAME","PASSWORD"); // use a statement to gather data from the database CallableStatement cs = db2Conn.prepareCall("{call INSERT_CITY_MAS(?, ?)}"); // Set the value for the IN parameter cs.setString(1, args[0]); cs.setString(2, args[1]); // Execute the stored procedure cs.execute(); cs.close(); db2Conn.close(); } catch (ClassNotFoundException cnfe) { cnfe.printStackTrace(); } catch (SQLException sqle) { sqle.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } } }
- 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)