Hello pgsql-jdbc--
I am working on a project where my organization would like to migrate a load of existing Oracle databases to
PostgreSQL. There is a requirement, however, that we be able to continue to write reports against the databases using
CrystalReports / Crystal Enterprise. This seems to be largely possible from our Linux servers through the use of your
JDBCdrivers, with the one exception that postgres text datatypes appear to Crystal as String fields of length -1, which
confusesthe software and prohibits their use. This is particularly problematic given postgresql's proclivity for
castingthe results of concatenations, unions, etc. to text on-the-fly.
I see a long thread related to this topic from about a year ago here:
http://archives.postgresql.org/pgsql-jdbc/2007-12/msg00145.php, but it seems to have run its course without coming to
anyspecific conclusions. Can anyone please update me on the status of this issue? It seems a small stumbling block,
butcould prove to be a show-stopper if we can't get around it somehow...
Thanks,
--Ken Boss
Minnesota DNR