When executing the above cord segment I'm getting an SQLException saying that the "SUBSCRIBER_ID" doesn't exist.
org.postgresql.util.PSQLException: ERROR: column "SUBSCRIBER_ID" does not exist Position: 128 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at ConnectionTest.TestAddSubscriber(ConnectionTest.java:48).
Simply by changing the case of SUBSCRIBER_ID to lower case, in return column array ,this error can be avoided. But the problem is that change is not feasible. This problem occurred when trying to use a Postgre db where initially it had been using a MySql db.
Is it possible to solve this problem by changing the DDL statement or any connection parameters?