From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Dror Matalon <dror(at)matal(dot)com> |
Cc: | PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Porting from Mysql to Postgres |
Date: | 2001-02-02 08:55:33 |
Message-ID: | 981104133.3a7a760599663@webmail.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Quoting Dror Matalon <dror(at)matal(dot)com>:
>
> Hi,
>
> I'm in the midst of porting Dbjay, a java based frontend, from MySQL to
> Postgres. More info about dbjay can be found at http://www.dbjay.com.
>
> 1. When I insert a CHAR field and then fetch it, I find out that
> the server padded it with spaces to the size of the field. This
> happens in Postgres but not in MySQL. I'm using String.trim() on
> it on the Java side. Is there a better way to do this, like setting
> a flag to tell the server to trim?
CHAR's are meant to pad. VARCHAR's don't pad.
> 2. Looking at the JDBC code it looks like getTableName in a resultset
> returns "" rather than the table name. This is a big problem, cause
> without the tablename it's impossible to let the user update the
> resultset when the table name is unknown. Seeing that php doesn't
> offer it and looking at the backend code, it looks like it's both
> not Java specific and not easy to implement. Still, what are the
> chances of having this available?
Possibly by 7.1, but I've yet to find out how to do it. I was going to post a
question to the hackers list about this at the weekend. This is needed for the
implementation of UpdateableResultSet.
> 3. Once Dbjay is available what are the appropriate newsgroups and
> mailing lists to announce it to the Postgres community.
The announce list, and as it's jdbc the jdbc list.
Peter
--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Luis LG | 2001-02-02 13:05:30 | JDBC documentation |
Previous Message | Peter T Mount | 2001-02-02 08:50:20 | Re: [INTERFACES] Re: [PATCHES] Re: Fixes and enhancements to JDBC driver(take 2) |