Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Seam seam-gen  RSS feed

Tom Fulton
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!