From: Date: March 18 2003 6:16pm
Subject: Re: Interactive query works, JDBC fails, related to correlation names
List-Archive: http://lists.mysql.com/java/5216
Message-Id: <RQNL1XB8A90954Z65421UEARNA9FDC8.3e775488@M-STUARTF>
MIME-Version: 1.0
Content-Type: text/plain; charset="windows-1252"

> Are you asking for updatable result sets? If so, the driver is getting
> confused while trying to build the SQL queries to make that possible.

Aha!  Yes, I am.  That also explains why similar queries didn't have the
problem (they were using different statements).

> The real fix is in the works, but it will require MySQL 4.1, as only
> MySQL-4.1 returns the original column and table names as part of the
> field-level metadata.

OK, good to know.  Can you mention this fix in the Connector/J release
notes when finished so I know when to pick up the upgrade?

Thanks very much for the quick, definitive reply!