Discussion:
[Middlegen-user] can't see tables, hsqldb
Brian McSweeney
2003-03-26 12:35:02 UTC
Permalink
Hi all,

I'm a newbie to middlegen. I've setup and ran the demo with no problem on
JBoss-3.04_tomcat-4.1.12.

However, what I really want to use middlegen for, is to check/modify the
relationships I have on a current app which is running on mysql.

With this in mind I modified the sample build to point at my application by
changing the database properties. Unfortunately, the relationships didn't get
shown - but some checking of the mailing lists and I realised that this was a
known problem.

http://www.mail-archive.com/middlegen-***@lists.sourceforge.net/msg00313.html

I tried the proposed solutions but unfortunately they didn't work.

Not to worry, I decided to deploy my app on hsqldb so I could see the tables
and their relationships there. I changed the hsqldb.xml file in

middlegen/samples/config/database

so that the property database.url looked as follows:
<property name="database.url" value="jdbc:hsqldb:hsql://localhost:1476"/>

unfortunately, when I run ant I get the following error:

BUILD FAILED
C:\soft\temp-middlegen\samples\build.xml:139: middlegen.MiddlegenException: Middlegen successfully connected to the data
base, 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?

I stopped JBoss and deployed the sample app that middlegen comes with and tried again.

No joy. I think I must have a problem with the database.url parameter, but this is the value in

the associated JBoss hsqldb-service.xml file. Any help with this problem would be greatly appreciated.

cheers,

Brian

Loading...