aspose file tools*
The moose likes Other Application Frameworks and the fly likes Seam seam-gen Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Frameworks » Other Application Frameworks
Bookmark "Seam seam-gen" Watch "Seam seam-gen" New topic

Seam seam-gen

Tom Fulton
Ranch Hand

Joined: Mar 30, 2006
Posts: 94
I have been very impressed with the seam-gen facility for building a project. However, for some reason, I am not able to generate entities for an existing database. I am using JBoss 4.2 with Hypersonic, and have tables created and populated for an existing JSF application. The URL for the database is jdbc:hsqldb:hsql://localhost:1701 (as validated by JBoss' HSQL Database Manager), with the DB name of "jsfdb", username "sa", no password. Driver jar and name are correct. In seam setup, I have left off the schema and catalog. I get the following message when running "seam generate-entities":

[hibernate] org.hibernate.exception.SQLGrammarException: Could not get list of tables from database. Probably a JDBC driver problem.
[hibernate] Configured schema:null
[hibernate] Configured catalog:null
[hibernate] <SQLException while getting schemas>
[hibernate] <SQLException while getting catalogs>
[hibernate] java.sql.SQLException: Table not found in statement [SELECT * FROM SYSTEM_TABLES]

Can someone point me in the right direction? When I look at the tables at that URL, they show as PUBLIC.ACCOUNT, PUBLIC.CUSTOMER and so forth, if that matters.

I agree. Here's the link:
subject: Seam seam-gen
Similar Threads
Confuguring mySql for entity beans
Unable to load database schema in Jboss Dev Seam Project
Creating tables from classes in JBoss seam
Generate HBM Files using Middlegen to use cache usage=read-write
Middlegen and Hibernate