explicity specifying name for hsqldb schema within hibernate

[Stuart Rogers]

It seems the default name for a schema in hsqldb is "PUBLIC" . This I discern looking in smdv.script

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE STUDENTS_OF_DISTRICT(ID BIGINT NOT NULL PRIMARY KEY,.......

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

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
  <session-factory>
  
    <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
    <property name="connection.autocommit">false</property>
    <property name="connection.url">jdbc:hsqldb:data/smdv</property>
    <property name="hibernate.connection.username">sa</property>
    <property name="connection.password"></property>
    <property name="connection.shutdown">true</property>
    <property name="current_session_context_class">thread</property>


    <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
    
    <!-- Drop and re-create the database schema on startup -->
    <property name="hbm2ddl.auto">create-drop</property>
    
    <!-- JDBC connection pool (use the built-in) -->
    <property name="connection.pool_size">2</property>
    
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

    <!--<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
    <property name="hibernate.cache.use_second_level_cache">true</property>
    <property name="hibernate.cache.use_query_cache">true</property> -->
    
    <mapping class="smdv.model.StudentOfDistrict"/>

  </session-factory>
</hibernate-configuration>

and ties with StudentOfDistrict class

package smdv.model;

import org.hibernate.*;
import org.hibernate.annotations.GenericGenerator;  
import org.hibernate.annotations.Parameter;

import org.hibernate.cfg.*;
import javax.persistence.*;

import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.event.ActionEvent;

import java.util.Arrays;
import java.util.HashMap;

import java.util.Date;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.text.DecimalFormat;
import java.sql.*;

import utils.*;


@Entity
@Table( name="students_of_district")  // must be lowercase for MySQL 4.x
public class StudentOfDistrict
{
    @Id
    @GeneratedValue(stragegy=GenerationType.AUTO)
    @Column( nullable=false)
    private Long id;
    
    @Column( name="student_id")
    private Long   studentId;        //  state-assigned student ID (SAISID)
    .......

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]

you can specify the schema in your HBM file.

[Stuart Rogers]

syntax? or better yet, an example for schema "foobar"?


Thanks for replying!


Still-learning Steve