Hi,

When i am trying to run the Hibernate plugin for Middlegen to generate configuration mapping files it gives this exception "middlegen.MiddlegenException: Middlegen successfully connected to the database, but couldn't find any tables. Perhaps the specified schema or catalog is wrong? -Or maybe there aren't any tables in the database at all?"

Iam using the DB2 DB , i am sure that i have given the correct url, user id and password as you see it says succesfully connected and on top of that i had created quite a few tables making usage of the same properties and build file.

Please let me know what can be the problem?

Thanks

The error is saying that it cannot find any tables. Maybe the tables are owned by a differnet user and appropriate grants have not been made for you. Maybe looking into a diffenet schema. You could try squirrel SQL or some other tool to see what tables can be viewed using a an alternative tool.

Hi David,

Thanks for the reply.

I did checked out various scenarios, i logged in with the same user in DB2 Database and created another table and even checked out what kind of grants are there (select,update,delet even administrative grants - everything is there). I have been able to select the records, update the records by making use of hibernate (with statless session bean, JBoss application server(Datasource configured with the same set of URL, userid,password) -- this also verifies that it has proper rights on the db tables.)

This is the latest free trail of DB2 personal edition i have downloaded to test things out and the driver file must be the recent one i.e. db2java.zip.

Can there be a problem with that driver ?


Thanks

Middlegen makes heavy use of JDBC meta data facilities so if the driver does not provide that or its not good implementation then middlegen will not be able to ask the questions, such as, tell all the table names, now tell me all the columns and the types etc etc. You could code up a simple JDBC test to see what is returned by the JBDC driver.

Make sure you have enabled JDBC2 support in DB2 by running the little batch file!

I wrote a sample test java class to get the metadata related information, in the end it came out that i had to give the schema name and table name in "UPPERCASE".

Thanks for all the help guys , in the end it is resolved and now the hibernate plugin for middlegen is running cool.

I can see that table name can be in UPPERCASE but i dont see any reasons why schema name to be in upper case? Any ideas guys? Is this a problem with the jdbc driver?

But in the end its resolved thats cool :)

Thanks

Cool - Glad you sorted out the problem.

David,

I had the same problem occur as Vijpan, in getting the "no tables found" message, using Oracle8i personal edition on Win2K. I also determined that the schema name needs to be in uppercase. Now, middlegen seems to be getting SOMEWHERE with tables (where it says "no table elements specified, retrieving all tables, this may take awhile"...).

It used to fail with "no tables found" in about 10 seconds or less. No, however, it just sits there for about 5-6 minutes. On the Windows task manager I can see the Oracle service just keep sucking up more and more memory and using 99% of the CPU, eventually I get an exception related to the inability to allocate memory.

I've setup a user name specific for me, and I can use Squirrel and the oracle thin driver to see the tables and their contents. They are all there, as expected! There are only 8 tables, and none has more than 10 fields, so it is not that complex. Using MySQL, it only takes a few seconds and the GUI springs up with the tables.

Somewhere the wheels must be spinning, not sure where.

How does one specify specific table elements, so I could perhaps try it this way? Its not a big deal to include these elements since there are only 8 tables...

Sounds a little odd but I have never had much success with any Personal edition of Oracle. I use Oracle everyday and always install Enterprise edition. Its free for development so just use it. I can see you have done a few checks with other tools but anyway check that the JDBC driver is OK. Try the latest version for the database.

Anyway, there is a tag for the Ant task that can be used to define the tables that are to be processed. It is documented (sort of) on the Middlegen site. I don't spend any time testing it with this tag being used - should work fine but you never know.

David,

I decided to try your suggestion and deleted the Oracle personal edition and downloaded/installed Oracle Enterprise edition. Although I had to recreate the database from scratch (Oracle could see that the database existed, but would not accept any credentials), once I did this, the middlegen hibernate plugin worked as advertised. Lesson learned - Use Enterprise Edition, not Personal Edition. Thanks!

Great - I have seen plenty of problems/limitations with personal edition. Glad your up and running.