I'm hoping to generate some mapping files with Hibernate Tools.

It properly connects to my Oracle 10g database. However, for the list of tables in the Database, it lists all the system tables, and actually gives an error about too many cursors open, so it's not able to actually get to my tables :( It's flooded with all the system tables.

Is there any way to change this behaviour?

Thanks
Greg

section 3.2 can show you how to solve this problem if you are running ant. otherwise, look around for a UI feature that will allow you to create a reveng.xml file, or reverse engineering strategy.

http://www.hibernate.org/hib_docs/tools/ant/index.html

fyi the too many cursors is an oracle driver bug; using datadirect drivers and no cursors are leaking.

and yes, create reveng.xml to limit the amount of tables need.

number of cursor is oracle parameter - client can open xxx cursors in one moment
this parametre is default small and it can be increased

'too many open cursors' is error when you break this limit - this can't be driver bug - if you get 'too many cursor' then clinet opne (and no close) cursors and another driver will not resolve problem

Greg's problem
if this in database tab it can't be resolved with reveng.xml . reveng work only with artifact wizard - it is the best that you set hibernate default schema parameter in *cfg.xml

database tab is slow and unusable for me , too (i have big schema and open database tab load all tables,columns, relations - this is very slow).I think that max have to make better databse explorer (sqlexplorer plugin is fine) or set preferences that remove this tab

Did you actually try and change driver ?
The code does *not* run out of connections when i run it with datadirect driver - thus its definitly a driver issue (until someone proves me wrong)

What is "database tab" ?



i have not had a single jira request for this stuff so hard to know that is an issue for anyone!

(but yes, i know it wont scale for large db's, that is why its a *lazy* tree - dont click if you dont want it....and use reveng.xml to limit the number of tables it scans for)

But again - if I dont get request, suggestions, patches for this things I have no idea on what bothers users the most....

you claim this : code throw ' too many cursors' with oracle drivers and when you use datadirect it work

maybe, if oracle driver don't close internal currsors when explore schema , but last driver work fine

I haven't this problem with my schema (it is big schema and last oracle's driver) because i increase this parameter to 6000 (default is 50 for oracle 9i)


database item in console tree

Do you use reveng.xml for expand database item ?

i told with you about explorer (and call reverse artifact with popup menu on database objects), but you tell that you insist on wtp rdb plugins (now dtp) - this plugin is very bad and doesn't support most databases (postgresql , for example and oracle support is only generic) - dtp plan is 6Q1 for release and it is better choose another plugin (sqlexplorer is great and maybe quantum)

so, we can't good stuff with rdb (or dtp) now and another plugin isn't option . Correct ?

Yes, oracle drivers seem to leak cursors (or rather throw an error that indicates a cursor leak) when running through all metadata tables.

I you increase the cursor parameter to 6000 you wont hit that; but users should not need to increase that parameter since the code *does* not leak ;)

What did I insist on with resp to WTP/DTP ? You submitted a patch which idea I found good (using the dtp db tree to start the reverse eng), but could not apply since it introduced too much duplication of code. That had nothing to do with the db schema in the hibernate configuration tree.

I am working on making this node better for large db's, but right now it is not vital for me and you dont need to click on it since we now have the reveng.xml editor which utilizes the reveng.xml to minimize the load of tables.

i set open cursor to default (50) and try open database tree item - it throw ' too many cursors' - I can beleive that oracle drivers have leak
How I can try datadirect driver ?


I want say only that rdb (dtp) currently isn't good choice for database explorer (maybe isn't vital, but it is very friendly for this work) - i stop work beacuse dtp plugin is bad (for now)

reveng.xml is good for reveng artifact, but i think that database tree item don't use it
(i don't set it anywhere) - it is best add another plugin

yet another suggestion : there is good plugin for explore java bean (hibernate POJO) - jbclipse - you can include it in hibernate tools or make better

one question : what about orm plugin (jsr220orm) - I think that it is good, but base is rdb(dtp) and because is currently unusable ?

yes WTP/DTP has serious limitation that is one of the reasons I want as little dependency on it as possible.

I don't want to add an extra plugin to navigate the database since we already have the code for it. Just need to make it more incremental than it is now.

How to try datadirect driver ? Go to there homepage and download it.

And no, the tree in configuration view does not use reveng.xml, but the db trees in the reveng.xml editor does; so use those ;)

I saw the jbclipse plugin, looks nice - but what does it provide that we don't already have ? (and it does not use the hibernate metamodel, meaning it would need extension)

JBoss is part of the Dali project (ejb-orm) which coorporates with the jsr220 orm. When these projects has something that is usable (and does not crash the first time i launch it) then we'll consider bundle it. Until then, it will be a separate download.

dali news on eclipse doesn't work (don't receive post) - i want ask what is base database plugin for dali ?

I try datadirect with my schema and default cursors and it work , but it is very slow and a i can't wait finish for my schema - oracle driver with 50 open cursors crash quick

I think that oracle driver haven't leak - it open more cursors only when you explore data dictionary and it quicker for this case

default value (50) is too low mostly and you have to increase

I'm not using ANT, I'm just using the built in tools. So does this reveng.xml apply to me?

What are these data direct drivers? Where can I get them?

if you use eclipse plugins you have reveng.xml
see new-hibernate - hibernate reverse engineering
or documentation for tools on tools.hibernate.org

datadirect are commercial jdbc drivers for many databases (and oracle)

you can download evaluation (15 days) on www.datadirect.com
you can increase open_cursors parameter and use oracle drivers, too

i call database item with oracle and datadirect drivers at the same time (with open_cursor 6000) - oracle driver is much quicker (datadirect work and now until type this)

yes, but it was not performance we talked about; it was wether connection were leaking ;)