RE: sun.jdbc.rowset.CachedRowSet and Temporary Table. - Clayburn Juniel - com.mysql.lists.java

4 messages in com.mysql.lists.javaRE: sun.jdbc.rowset.CachedRowSet and ...

From	Sent On	Attachments
Frondoni, Giorgio	01 Nov 2005 16:28
Clayburn Juniel	03 Nov 2005 05:19
Frondoni, Giorgio	03 Nov 2005 08:51
Clayburn Juniel	04 Nov 2005 05:22

Subject:	RE: sun.jdbc.rowset.CachedRowSet and Temporary Table.
From:	Clayburn Juniel (clay...@yahoo.com)
Date:	11/04/2005 05:22:13 AM
List:	com.mysql.lists.java

--- "Frondoni, Giorgio" <gior...@TransCore.com> wrote:

Thank you for your reply.

Let me see if I understood correctly.

1)If SHOW FULL COLUMNS works on temporary table for MySQL v 4.0.20 I should probably open a bug for version 5.0. Correct?

2)Could you be more specific with your workaround example? Because it is not clear what you have done.

Whenever a temporary table is created (through the program) the name of that program is stored by the program. The name is stored in a list for temporary tables attached to the database it is in. Whenever the program pulls up a list of tables, by show tables or DatabaseMetaData.getTables the program also searches the temporary table list and displays those found tables as well.

---------------------- Clayburn W. Juniel, III