• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Seam seam-gen

 
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

Thanks!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic