Posts Written By: srigalamilitan

Learn Selenium Java Locator

A locator is a way to identify elements on a page. It is the argument passed to the Finding element methods. Type Locator Selenium Locator Description“IdHtml”) Locates elements whose ID attribute matches the search value“NameAtributeHtml”) Locates elements whose NAME attribute matches the search value By.xpath(“Path”) Locates elements matching an XPath expression By.className(“className”) Locates elements whose […]

Hello World Selenium

Learn Selenium Pom.xml Result WebDriver Chrome look Like this Full Code github

Docker CE, Starting A Nginx Web server

Images vs Container An Images Is The Application We wan To Run A Container is an instance of that image running as a Process Running Nginx on Docker Running nginx on foreground docker container run –publish 80:80 nginx Docker engine will look image nginx, and pull from docker hub . Then started a new container […]

How to using tuple Data Type Cassandra

Tuple data type is a fixed-length sets of typed positional fields. Use a tuple as an alternative to user-defined type(UDT). A Tuple can accommodate many fields(32768). When we create a table, for tuple datatype use angle brackets and a comma delimeter for the commponent types. Unlike other “composed” types (collections and UDT), a tuple is […]

Cassandra Data Manipulation (Insert, Update, Delete) using `cqlsh`

In previous section we learn creating user, keyspaces and managed table. Now we will learning how to insert, update, and deleting data in cassandra using cassandra.Operation DML ( Data Manipulation Language) similar to RDMS (Relational Database Management System). Using Keyword INSERT INTO for inserting data, keyword UPDATE table_name SET columns WHERE conditional for updating data, […]

Create, Alter and Drop Table Cassandra

Create, Alter and Drop Table Cassandra Table in Cassandra is a collection of ordered (by name) columns fetched by row. A row consists of columns and have a primary key. The first part of the key is a column name. Subsequent parts of a compound key are other column names that define the order of […]

Keyspace Cassandra

A keyspace is a container that holds the column families, user defined types. In Cassandra, Keyspace is similar to schema RDBMS Database. Keyspace holds column families, indexes, user defined types, data center awareness, strategy used in keyspace, replication factor, etc. Syntax CREATE KEYSPACE | SCHEMA IF NOT EXISTS keyspace_name WITH REPLICATION = map AND DURABLE_WRITES […]

How To Manage Users NoSql Cassandra using `cqlsh`

In this tutorial we learn how to manage user in database cassandra. Setting the cassandra database using username and password authentication. Learn how to login using default username and password cassandra, create user with or without password, create user superuser and nosuperuser, modifying user and dropping user. Create user Syntax for create user CREATE USER […]

Spring Boot Using Hikari Connection Pool

# Spring Boot Using Hikari Connection Pool Connection Pool In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required. Connection pools are used to enhance the performance of executing commands on a database. Opening and maintaining a […]

Dynamic Call Store Procedure and Function Database

spring-boot-call-store-procedure Dynamic calling store procedure and store function in database Dynamic calling store procedure and function 1. Via Callable Statement 2. Via SimpleJdbcCall spring-boot-starter-jdbc See Code Snippets Store Procedure DELIMITER $$ USE `training_sp`$$ DROP PROCEDURE IF EXISTS `create_product`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `create_product`(id VARCHAR(255), p_code VARCHAR(255),p_name VARCHAR(255),weight BIGINT) BEGIN INSERT INTO product(id, CODE,NAME,weight) VALUES(id,p_code,p_name,weight); END$$ DELIMITER […]