Pablo Hernandez pablohdzvizcarra

🛏️

Need Sleep

Software Engineer

pablohdzvizcarra / callApiAndPerseRequestInPOJO.java

Last active July 1, 2021 13:05

call api with HttpClient Java and parse json to POJO

	package org.example;

	import com.fasterxml.jackson.core.type.TypeReference;
	import com.fasterxml.jackson.databind.ObjectMapper;

	import java.io.IOException;
	import java.net.URI;
	import java.net.http.HttpClient;
	import java.net.http.HttpRequest;
	import java.net.http.HttpResponse;

pablohdzvizcarra / DBLauncher.java

Created July 2, 2021 14:16

simple config H2 database to Gradle

	package com.example.infrastructure;

	import org.h2.tools.Server;

	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.SQLException;
	import java.sql.Statement;

	public class DBLauncher

pablohdzvizcarra / Main.java

Created July 10, 2021 23:06

run only one async task

	package org.async;

	import java.util.concurrent.CompletableFuture;

	public class Main
	{
	public static void main(String[] args)
	{
	// TODO: 7/10/21 Create a simple Task
	// TODO: 7/10/21 Add sleep to thread, for the asynchronous task to be executed

pablohdzvizcarra / SavesAndReadBlobsAndClobs.java

Created July 13, 2021 14:29

operations to save and read clobs, blobs in mysql

	package com.pluralsight.jdbc.course.m6c1;

	import java.io.FileInputStream;
	import java.io.InputStream;
	import java.io.InputStreamReader;
	import java.io.Reader;
	import java.sql.*;

	public class SavesAndReadBlobsAndClobs
	{

pablohdzvizcarra / ProceduresMySQL.java

Created July 13, 2021 16:56

example two procedures operation with mysql

	package com.pluralsight.jdbc.course.m6c2;

	import java.sql.*;
	import java.util.ArrayList;
	import java.util.List;

	public class Procedures
	{
	private static final String URL
	= "jdbc:mysql://localhost:3306/classicmodels?user=root&password=my-secret-pw";

pablohdzvizcarra / ProceduresMySQL.java

Created July 13, 2021 16:58

update example

	package com.pluralsight.jdbc.course.m6c2;

	import java.sql.*;
	import java.util.ArrayList;
	import java.util.List;

	public class Procedures
	{
	private static final String URL
	= "jdbc:mysql://localhost:3306/classicmodels?user=root&password=my-secret-pw";

pablohdzvizcarra / SequenceTwoTransacctionsSQL.java

Created July 14, 2021 13:38

way to create two transactions in MySQL

	package com.pluralsight.jdbc.course.m7c2;

	import java.sql.*;

	public class OrderComponent
	{
	public static void main(String[] args) throws SQLException
	{
	int customer = 112;
	LineItem lineItem =

pablohdzvizcarra / RowSet.java

Created July 14, 2021 14:37

create a file with data form the database and read the data

	package com.pluralsight.jdbc.course.m7c3;

	import javax.sql.rowset.CachedRowSet;
	import javax.sql.rowset.RowSetFactory;
	import javax.sql.rowset.RowSetProvider;
	import java.io.*;
	import java.sql.SQLException;

	public class RowSet
	{

pablohdzvizcarra / logging.properties__config-file

Created July 16, 2021 18:18

file to config logging java

	handlers=java.util.logging.ConsoleHandler, java.util.logging.FileHandler

	# To also add the FileHandler, use the following line instead.
	# handler=java.util.logging.FileHandler, java.util.logging.ConsoleHandler

	# level of all loggers and handlers
	.level=INFO

	# FileHandler specific props
	java.util.logging.FileHandler.pattern = src/main/java/logs/main%u.log

pablohdzvizcarra / build.gradle

Created July 22, 2021 13:32

example file