This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread 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 Android Security Essentials Live Lessons this week in the Android 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
 
Don't get me started about those stupid light bulbs.
 
subject: explicity specifying name for hsqldb schema within hibernate
 
Similar Threads
Dialect class not found
Problem in insert query
Using Hibernate, but tables are not saved
Hibernate Maping error
illegalArgumentException, HSQLDB, and Hibernate