This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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: 137
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: 137
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