Hello

Forgive me if this is not the right forum to post my question. I am working with oracle10g and middlegen; the tool is not discovering my tables, it suggest that my schema does not contain anything. This is not true, I wrote a jdbc connection with java and used the getMetaData().getTables() and was able to read tables from my schema. Why middlegen has this problem. I start middlege with ant:

<middlegen appname="xxxx"
prefsdir="${basedir}"
gui="true"
databaseurl="jdbc:oracle:thin:@machine:1521:sid"
driver="oracle.jdbc.driver.OracleDriver"
username="username"
password="pass">

I think this is the right way to connect to oracle. If I add schema and catalog I get ORA-01424: error. Please advice

try add
schema="username"
catalog=""

regards

It turned that Oracle will retuen tables with names starts with $ which will cause the problem. Can we exclude tables from the schema like:

<middlegen appname="xxx"
prefsdir="${basedir}"
gui="true"
databaseurl="jdbc:oracle:thin:@xxx:1521:xx"
driver="oracle.jdbc.driver.OracleDriver"
username="xxx"
password="xxx"
schema="xxx">
<table name="xxx.*"/>
<hibernate destination="${basedir}/src" package="xxxx"/>
</middlegen>

Thank You

You can do it.See table element, for example

<table name="tablename">

regards

You might want to consider getting a CVS build as it has a number of fixes for various items. One being a minor patch for Oracle.