aspose file tools*
The moose likes Object Relational Mapping and the fly likes explicity specifying name for hsqldb schema within hibernate 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 » Databases » Object Relational Mapping
Bookmark "explicity specifying name for hsqldb schema within hibernate" Watch "explicity specifying name for hsqldb schema within hibernate" New topic
Author

explicity specifying name for hsqldb schema within hibernate

Stuart Rogers
Ranch Hand

Joined: Oct 02, 2008
Posts: 133
It seems the default name for a schema in hsqldb is "PUBLIC" . This I discern looking in smdv.script


which in turn gets created due to what's in smdv.cfg.xml



and ties with StudentOfDistrict class



Question: what and where do I put a blurb to explictly name the hsqldb schema to be "SMDV" instead of the default "PUBLIC" ?
This would also be needed when you need to have more than one schema in hsqldb ( similar to having more than one database in, say, MySQL)


TIA,

Still-learning Steve
Arun Kumarr
Ranch Hand

Joined: May 16, 2005
Posts: 513

you can specify the schema in your HBM file.


If you are not laughing at yourself, then you just didn't get the joke.
Stuart Rogers
Ranch Hand

Joined: Oct 02, 2008
Posts: 133
syntax? or better yet, an example for schema "foobar"?


Thanks for replying!


Still-learning Steve
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: explicity specifying name for hsqldb schema within hibernate
 
Similar Threads
Problem in insert query
Using Hibernate, but tables are not saved
illegalArgumentException, HSQLDB, and Hibernate
Dialect class not found
Hibernate Maping error