When working on modern applications, having a reliable and consistent database environment is crucial for local development. Setting up PostgreSQL directly on your machine can sometimes be cumbersome 😩, especially when dealing with different versions, dependencies, or conflicting configurations. Docker provides a simple and efficient way to run PostgreSQL in an isolated container, ensuring that […]
Oracle – ORA-00922: missing or invalid option
Hello There! I recently did test in my Java code to have a SQL statement for copy table from TABLE 1 toTABLE 2. I need both tables identical during the application goes boot-up. But, suddenly i got : ORA-00922: missing or invalid option. 1. ORACLE DOCUMENTATION Based on Oracle error documentation ORA-00922 says : Cause […]
PostgreSQL – Enable field name quote in hibernate
Hello There! Recently, i did a POC that involving 4 databases at the same time in one application. My application just do a simple CRUD in 4 databases which are MySQL, Oracle, Microsoft SQL Server and PostgreSQL. You can image that, one application can be use 4 databases as well. THE PROBLEM At this note […]
Microsoft SQL Server UDF For REST API call
Hello There! Just continue again what i have done in my previous note. I was writing some UDF for Oracle Database to execute a REST API to CipherTrust Tokenization Server. In this note, i will going to explain how we do REST API at the same way in Microsoft SQL. System administrators, DBAs, and application […]
Oracle UDF For Thales CipherTrust Tokenization
Hello there! I just continue what i have done in my prior note, i did create some simple HTTP JSON POST written in C/C++, you may find it here. Today, i’m going to explain, the process and creating Oracle UDF to execute HTTPS in Oracle to Thales CipherTrust Tokenization (CT-VL). Before you begin, ensure your […]
Fetch data via REST API over HTTPS using Oracle Wallet
Hello there! This note explains how to obtain and manage security credentials for Oracle Application Server resources and accessing outside database. Security administrators can use Oracle Wallet Manager and its command-line utility using orapki to manage public key infrastructure (PKI) credentials on Oracle clients and servers. These tools create credentials that can be read by […]
Designing a merchant acquiring system
Hello There! Today, i’m going to explain a merchant acquiring system that i had designed in my previous company. What is acquiring bank? according to wiki, an acquiring bank (also known simply as an acquirer) is a bank or financial institution that processes credit or debit card payments on behalf of a merchant. Acquirers collaborate […]