I have tried getting my head around middlgen and would appreciate some help. In simple, layman terms, how does one go about configuring middlegen to an already existing database ?

I have an oracle database that I want middlegen to connect to so that I can generate the hbm.xml files ? How do I do this ? Any specific ant tasks that I would need to change will be helpful.

Any help is as always much appreciated !

S

Ok, did some more reading and now it seems to connect to the database, but I keep getting this error :


0: 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?

Here is my oracle.xml :

<!-- please set your Oracle-SID according to your needs -->

<property environment="env"/>

<property name="database.script.file" value="${src.dir}/sql/${name}-oracle.sql"/>
<property name="database.driver.file" value="${env.ORACLE_HOME}/jdbc/lib/classes12.jar"/>
<property name="database.driver.classpath" value="${database.driver.file}"/>
<property name="database.driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url" value="jdbc:oracle:thin:@xxx.yyy.com:1521:databaseSID"/>
<property name="database.userid" value="straw"/>
<property name="database.password" value="password"/>
<property name="database.schema" value=""/>
<property name="database.catalog" value=""/>

<!--property name="jboss.datasource.mapping" value="Oracle7"/-->
<property name="jboss.datasource.mapping" value="Oracle8"/>
<!--property name="jboss.datasource.mapping" value="Oracle9i"/-->


Can anyone tell me what I need to do ? I read that sometimes taking out the schema or the catalog seems to solve the problem, but I tried both and it didnt seem to work.

S

This first step is to get it running against the sample that I supply. For example the R4 release is just about ready to go, eg, set the classpath and your operating.

Another option is to download the Tools demo. This demo includes a middlegen task (tools etc are getting older now). The purpose is to get it to work then move to your own setup.

If you using the demo against oracle etc you do need to get it to build the tables - there is an ant task to to that. The hardest step is always setting up the JDBC driver - this is the same for any JDBC required tool.

I have seen no tables come up (when they should have) in a number of cases where the JDBC driver was buggy (usually a beta version). If this is a problem I suggest you create a small amount of JDBC Java code to test your connection and basic meta data results.