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 […]
Very basic – Reverse a string
Hello There, When i was in a college (around 2000), i had learned an algorithm which i did not know the stuff that i learn here. They told me, it’s a very basic code that i need to achieve at first semester. I was dealing with a coding problem that involved reversing a string. 😩. […]
3DES algorithm : Double vs Triple Length Keys
Hello There! Just a quick introduction about what is the difference between double length and triple length in 3DES algorithm. I have created some small sample scripts written in Java to generate a 3DES key in different size of length. 1. GENERATING 3DES KEY IN TRIPLE LENGTH OF SIZE 2. GENERATING 3DES KEY IN DOUBLE […]
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 […]