Hi there,

I am trying to reverse engineer a FrontBase database using the Hibernate tools in Eclipse.

For some reason I only get the Views in that database but not the tables.

I've been trying to localize what the plugin does and (if I'm correct) I end up in JDBCMetaDataDialect.getTables().

Here
getMetaData().getTables(catalog , schema , table, new String[] { "TABLE", "VIEW" });

I translated that back into a 'pure' small JDBC test APP and it sees very well the TABLES and the Views in the ResultSet.

Before I put this in JIRA is there anything else I should look for?

-- Rene

hmmm .. if views are picke up tables also should. are they by any chance in different packages ?

What do you mean with 'packages' in that context?

I've dug a little further and I think I found the error: The resultset from JDBCMetaData.getTables gets processed in the JDBC reader.processTables method.

In here there is a check for TabeType to be "TABLE" or "VIEW" but it turns out the FrontBase JDBC adaptor returns "BASE TABLE" as TableType. So the tables get sorted out in the process ;-(

Let me guess JIRA?


-- René

by packages i meant schema.

But if FrontBase uses "BASE TABLE" instead of "TABLE" then this is most likely the case.

So i guess we need a metadatadialect controlled Table_Type's. geez.

Ah .. the tables are in the same schema as the views. It's most probably the 'BASE TABLE' thingy. (I'm trying to compile the CVS source myself to verify).

The API docs from Java are indeed pretty open about possible types they say:

So someone was bound to do it different.

-- René