This week's book giveaway is in the Programmer Certification forum.
We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
Win a copy of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 this week in the Programmer Certification forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Ron McLeod
  • Carey Brown
  • Paweł Baczyński
  • Piet Souris
  • Vijitha Kumara

Seam seam-gen

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.

My, my, aren't you a big fella. Here, have a tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!