Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Seam seam-gen

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.

What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!