Informix is old-school, as evident in how we perform SQL updates on a date column. If I had my way, Java applications that use it should start (Ahora Mismo!) moving to other RDBMSs that are modern, robust, scalable, and cheaper
Jenkins config.lock .git/config File exists
We can easily resolve virtually every problem in Jenkins. However, that is not true, especially when we do not have administrator access to the host Jenkins runs in. One problem is “Jenkins config.lock .git/config File exists”. This means Jenkins is
Specify Non-default PostgreSQL Schema When Connecting Using JDBC
By default, we use the public schema when we connect to PostgreSQL. Some applications use multiple schemas to store data in the database. Therefore, they need to specify explicitly which PostgreSQL schemas to use. This post shows how to connect
Rust – Connect to MySQL And Query For Data
This post is about connecting to MySQL from Rust.
PHP 7.4 – Enable PostgreSQL Driver
This post shows how to configure PHP 7.4 (or PHP 7.x, in general) php.ini to enable the PostgreSQL driver, which comes in handy when I need to work on a new version of PHP after a very long break (like
docker-compose.yml For PgAdmin And PostgreSQL
In this post, we’ll set up PgAdmin and PostgreSQL containers with docker-compose.yml for local development. We’ll also configure PgAdmin to access the PostgreSQL database under the same bridge network. Typically, we don’t deploy a PgAdmin container alongside a PostgreSQL container
JSqlServerBulkInsert with Spring JDBC Connection is Closed
When we use JSqlServerBulkInsert, we provide a database connection from the pool to bulk insert data even in Spring JDBC. As a result, it might not work well with Spring. Either we could get “Connection is Closed” errors or cause
Display a Red Asterisk before a Label in JSF for Required Fields
For the most part, this is a generic CSS/HTML tip but this article demonstrates how to display a red asterisk for labels in JSF for required fileds.
Convert the PEM files to a PPK files using PuttyGen
This post demonstrates how to convert private key .pem files generated and downloaded from AWS when creating an EC2 instance to .ppk files that are supported by putty.exe for SSH access.
How to Restore Your Custom MastHead in NetWeaver AS
Background Just as I was about to create Software Test Plan (STP) documents, I decided to restore the web application’s original header using the original masthead (.par) file when all of a sudden, the procedure did not yield the expected