Hi Sumit,
You would do well to read the list archives specifically for this
topic. There have been many posts of late.
Dave
On Mon, Jul 5, 2010 at 6:59 AM, Sumit Pandya <sumit.pandya@elitecore.com> wrote:
> Hi All,
> In this mail chain I propose to make a seamless migration path
> towards PostgreSQL. There are people who like to migrate from other database
> to PostgreSQL. However first problem in that comes is related to feature
> compliance and code-changes for same.
> Remember that code-change remains as a big hindrance for any
> programmer/company.
>
> To start with I'd like to propose compliance for JDBC and ODBC
> drivers. Reason for JDBC/ODBC selection is with the facts that
> 1> Specifications for both are into proper place,
> 2> Mostly application programmers communicate with this method
>
> There are some specification; example setQueryTimeout of JDBC; which
> PostgreSQL doesnot complies.
>
> Non compliance could be fine at some extent. But here problem is
> when a code which is written for database supporting setQueryTimeout and
> when we planned to test PostgreSQL we got exception from driver.
>
> To move further require to comment out all that code and then
> progress further.
>
> Now I propose to not throwing any exception there. It is better if
> PostgreSQL - JDBC/ODBC doesnot honor this method. It is painful to change
> product source-code for this limitation.
>
> I donot have idea on debug facility in PostgreSQL - JDBC/ODBC. If
> you have some debug-log framework available then such non-implemented call
> could be part of high level debugging messages.
>
> Please share your opinion/comments.
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>