Keep it simple and stick to basics
There is a detailed explanation of this difference here. There is no static analyser tool going to check and help fixing those in advance. We end up checking such empty string only with the help of testing, going back to code to fix them. In short, keep following in mind, Oracle considers Empty String(”) and…
Both Oracle and PostgreSQL supports Date as the data type. However there is a difference, In oracle date includes timestamp and in case of PostgreSQL it gives only date omitting timestamp. It is mainly because PostgreSQL has we have another data type called “Timestamp”. Having said that, If you are using JPA annotation @Temporal in…
The PRAGMA AUTONOMOUS_TRANSACTION is one of the technique in oracle used to make sure the sub-program runs in different transaction with out affecting main transaction. The usecase you might find such thing exists in oracle is to write error or audit the failures. During Oracle two ProgreSQL Migration, never mind – PRAGMA AUTONOMOUS_TRANSACTION doesn’t exists…
In our Oracle to PostgrSQL migration project, once we cover the issues reported by static code analysers we brought up the instances in development and did Brut Force Testing to capture all SQL Failures in the database layer. We enabled all debug logs at the database and as result it started throwing exceptions like the…
Xml file parsing in Linux via command line, I once thought it is not possible better create simple Java application. I have heard about “xmllint – command line XML tool” once, hence thought of giving a try, My xml content is something like below, My requirement here is to get the list of table name…
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, The specified account (abc_owner) does not have sufficient privileges for working with the following object(s): ORACLE Server : [SELECT ANY DICTIONARY] Run following command as system user in oracle server, grant select any dictionary to…