Fields listed twice in CF9, CFB1, RDS DataView, under Table node

Report · Sep 27, 2009

Under some of the table nodes, the fields are listed only once each, which is correct. In others, the fields are listed twice. The entire field list is duplicated (field list is complete from first field to last field, but then after the first listing of the last field, the next item is another listing of the first field, followed by another listing of the second field, and so on)

Anyone seen this behavior? Is it a bug in CF9 or CFB1 ? How can I fix it?

Report · Sep 28, 2009

I think I have found a bug in CFB1. It has to do with field lists in the RDS DataView. Amoung the table nodes, I have two tables. Their names are:

BAA_USR

BAA_USR_OPT

The tree nodes representing fields under the BAA_USR_OP table node are listed once each, which is correct. However the tree nodes representing fields under the BAA_USR table node includes all of the fields in BAA_USR (which you would expect), but then the tree nodes continue, listing all the fields in the table BAA_USR_OPT.

This is why only *some* of my tables have this problem... because only *some* of them have other tables whose name shares the same "root" string.

I always follow this convention. Example, the above 2 tables.. the top one is the table that holds user names, the second is a child table that holds user options.

Comments anyone? Am I doing something wrong? Or not doing something I should be?

Report · Sep 29, 2009

I have built a little test database connected via Jaybird (The JDBC connector for Firebird), with all the same tables, except for one thing. In the table names, I have removed the underscores in the table names.

Fields are now listed correctly, not duplicated with the fields from other tables.

To test this further, I have built an ODBC connection to the same database and tables using ODBC instead of Jaybird. ODBC doesn't display this errant behavior, so maybe I'm barking up the wrong tree.

Maybe CF and CFB are just fine. The problem seems to be localized to Jaybird. I'll post a link to this thread on the appropriate Yahoo site, to see if I can get a response.

Report · Sep 30, 2009

I was able to get in touch with the Open Source Jaybird project leader, Roman Rokytsky. See the thread at:

http://tech.groups.yahoo.com/group/Firebird-Java/message/10022

Roman will be deciding best approach to take moving forward regarding Jaybird. I'll be watching the Jaybird home page at

http://www.firebirdsql.org/index.php?op=devel&sub=jdbc

For any news of a next release of Jaybird.