Keep it simple and stick to basics
Let my first tell you that I’m not an active C/C++ developer any more. I’m into Java development for more than a decade now. One of my client wanted to use PgBouncer as Database pooling implementation besides their application pool implementation This section will give list of steps (build and run) that I followed to…
While converting application from Oracle to PostgreSQL database and if the application uses procedure, following might be one of the exception you should have seen, Caused by: org.postgresql.util.PSQLException: ERROR: getCalculatedValues() is a procedure Hint: To call a procedure, use CALL. The following line of code might exists in your code base, While calling procedures…
Following type of SQL’s can cause “subquery in FROM must have an alias” issue. They are like below, It needs to be fixed to meet the SQL standards. There is no question asked about why PostgreSQL did not support 🙂 why should I create alias in all the cases 🙂 The correct query with alias…
The code like this in your program can throw “Data Type Mismatch Error” at run time. Following is the actual runtime error will come in the application, Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: smallint <> character varying Hint: No operator matches the given name and argument types. You might need to add explicit…
If you face Insufficient privileges issue while connecting to oracle database from Amazon AWS Schema Conversion Tool (SCT) like below, ORACLE Server : [SELECT ANY DICTIONARY] Run following command as system user in oracle server, grant select any dictionary to abc_owner;
I installed following P4V client version on my Mac and found that when I try to view difference of a file in change list it doesn’t open P4Merge, I had searched over Internet to find resolution but all went in pain. Finally I tried to configure the P4Merge in P4V like below and to my…
Following is the longest Linux command using pipe which I came across today while working with some API gateway, This is a standard access log filtering to find out client identifier involved in API failure. Here is the details about what this command will do step by step, The cat command will read the access…
We are one such happy customer using JBOSS Messaging Service from JBOSS 5.1. When we plan to upgrade our applications to Wildfly 10.1, we had no option other than using Wildfly with JBOSS 5.1 messaging Service. It is because we have no plan to upgrade our legacy messaging system which meets the requirement well and…
We have been trying to upgrade our application from using JBOSS 5.1 to Wildfly 10.1. We have rolled out the changes and got stuck in production due to missing performance settings. This blog is to give those performance settings in Wildfly 10.1 that we used. The most important miss we did is we did not…
Is there is some one in your organization feeling secured about accessing his Linux system and provided you Putty Private Key (PPK) file. This blog will tell you how to Login using PPK file using Putty. I assume that you have already installed Putty in your system and path has been updated to invoke from command line.…