Example usage for org.hibernate.dialect HSQLDialect HSQLDialect

List of usage examples for org.hibernate.dialect HSQLDialect HSQLDialect

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.dialect.*
  5. HSQLDialect
  6. HSQLDialect

Introduction

In this page you can find the example usage for org.hibernate.dialect HSQLDialect HSQLDialect.

Prototype

public HSQLDialect()

Source Link

Document

Constructs a HSQLDialect

Usage

From source file:com.opengamma.util.db.HSQLDbDialect.java

License:Open Source License

@Override
protected Dialect createHibernateDialect() {
    return new HSQLDialect();
}

From source file:com.opengamma.util.db.management.HSQLDbManagement.java

License:Open Source License

@Override
public synchronized Dialect getHibernateDialect() {
    if (_hibernateDialect == null) {
        // constructed lazily so we don't get log message about 'using dialect' if we're not actually using it
        _hibernateDialect = new HSQLDialect();
    }/*from   w w w  .ja  v  a2 s.  c o m*/
    return _hibernateDialect;
}

From source file:gov.nih.nci.protexpress.test.CsmInitializer.java

License:BSD License

/**
 * Csm initalizer constructor. Initializes the configuration and then creates and drops the db.
 *//*from   w w  w  .  j  a  v  a 2s  .com*/
public CsmInitializer() {
    URL url = getClass().getClassLoader().getResource("jaas.config");
    System.getProperties().setProperty("java.security.auth.login.config", url.getPath());

    this.csmHibernateConfig = new Configuration();
    url = getClass().getClassLoader().getResource("protExpress.csm.new.hibernate.cfg.xml");
    this.csmHibernateConfig = this.csmHibernateConfig.configure(url);
    this.dropScript = this.csmHibernateConfig.generateDropSchemaScript(new HSQLDialect());
    this.createScript = this.csmHibernateConfig.generateSchemaCreationScript(new HSQLDialect());

    dropAndCreateCsmDb();
}

From source file:net.lshift.hibernate.migrations.TransplantTableBuilderTest.java

License:Apache License

@Test
public void shouldCopyIntoTemporaryTableWithRenames() throws Exception {
    Configuration config = HibernateHelper.configuration();
    Dialect dialect = new HSQLDialect();
    DialectExtension extension = new DefaultDialectExtension();

    MigrationBuilder mb = new MigrationBuilder(config);

    CreateTableBuilder tempTable = new CreateTableBuilder(dialect, extension, "temp_table", "new_foo");
    tempTable.column("new_foo", Types.INTEGER, false);
    tempTable.column("bar", Types.VARCHAR, 255, false);

    HashMap renames = new HashMap();
    renames.put("new_foo", "old_foo");

    mb.alterTableViaTemporaryTable("source_table", tempTable, renames);

    Connection conn = createStrictMock(Connection.class);
    expect(conn.prepareStatement(// ww w  . ja v  a2  s.c o  m
            "create table temp_table (new_foo integer not null, bar varchar(255) not null, primary key (new_foo))"))
                    .andReturn(mockExecutablePreparedStatement());
    expect(conn.prepareStatement("insert into temp_table(new_foo,bar) select old_foo,bar from source_table"))
            .andReturn(mockExecutablePreparedStatementForUpdate(1));
    expect(conn.prepareStatement("drop table source_table")).andReturn(mockExecutablePreparedStatement());
    expect(conn.prepareStatement("alter table temp_table rename to source_table"))
            .andReturn(mockExecutablePreparedStatement());
    replay(conn);

    mb.apply(conn);
    verify(conn);
}

From source file:net.lshift.hibernate.migrations.TransplantTableBuilderTest.java

License:Apache License

@Test
public void shouldCopyIntoTemporaryTableWithoutRenames() throws Exception {
    Configuration config = HibernateHelper.configuration();
    Dialect dialect = new HSQLDialect();
    DialectExtension extension = new DefaultDialectExtension();

    MigrationBuilder mb = new MigrationBuilder(config);

    CreateTableBuilder tempTable = new CreateTableBuilder(dialect, extension, "temp_table", "foo");
    tempTable.column("foo", Types.INTEGER, false);
    tempTable.column("bar", Types.VARCHAR, 255, false);

    mb.alterTableViaTemporaryTable("source_table", tempTable);

    Connection conn = createStrictMock(Connection.class);
    expect(conn.prepareStatement(//from  w  w  w  .  j a v  a2s  .com
            "create table temp_table (foo integer not null, bar varchar(255) not null, primary key (foo))"))
                    .andReturn(mockExecutablePreparedStatement());
    expect(conn.prepareStatement("insert into temp_table(foo,bar) select foo,bar from source_table"))
            .andReturn(mockExecutablePreparedStatementForUpdate(1));
    expect(conn.prepareStatement("drop table source_table")).andReturn(mockExecutablePreparedStatement());
    expect(conn.prepareStatement("alter table temp_table rename to source_table"))
            .andReturn(mockExecutablePreparedStatement());
    replay(conn);

    mb.apply(conn);
    verify(conn);
}

From source file:no.abmu.finances.domain.AbstractLocalHibernate3Test.java

License:Open Source License

protected void setUp() throws Exception {
    AnnotationConfiguration configuration = new AnnotationConfiguration();
    configuration.setProperty(Environment.DRIVER, "org.hsqldb.jdbcDriver");
    configuration.setProperty(Environment.URL, "jdbc:hsqldb:mem:financeH3");
    configuration.setProperty(Environment.USER, "sa");
    configuration.setProperty(Environment.DIALECT, HSQLDialect.class.getName());
    configuration.setProperty(Environment.SHOW_SQL, "false");
    configuration.setProperty(Environment.HBM2DDL_AUTO, "create-drop");
    configuration.setProperty(Environment.STATEMENT_BATCH_SIZE, "0");
    configuration.setProperty("hibernate.cache.use_second_level_cache", "false");

    configuration.addClass(ReportSchema.class);

    configuration.addClass(Account.class);
    configuration.addClass(Post.class);
    configuration.addClass(PostPeriod.class);
    configuration.addClass(PostType.class);
    configuration.addClass(PostValidator.class);

    configuration.addClass(ReportData.class);
    configuration.addClass(PostData.class);
    configuration.addClass(SubReportDataList.class);

    configuration.addClass(AccountOrgUnitMapping.class);
    configuration.addClass(ReportDataOrgUnitMapping.class);

    configuration.addAnnotatedClass(ContactRole.class);
    configuration.addAnnotatedClass(CountryName.class);
    configuration.addAnnotatedClass(OrganisationName.class);
    configuration.addAnnotatedClass(OrganisationRelationRole.class);
    configuration.addAnnotatedClass(OrganisationTypeName.class);
    configuration.addAnnotatedClass(POBoxAddress.class);
    configuration.addAnnotatedClass(StreetAddress.class);
    configuration.addAnnotatedClass(ExtendedContactPerson.class);
    configuration.addAnnotatedClass(BankAccountNumber.class);
    configuration.addAnnotatedClass(ContactPerson.class);
    configuration.addAnnotatedClass(EmailAddress.class);
    configuration.addAnnotatedClass(FaxNumber.class);
    configuration.addAnnotatedClass(TelephoneNumber.class);
    configuration.addAnnotatedClass(WebAddress.class);
    configuration.addAnnotatedClass(Muncipality.class);
    configuration.addAnnotatedClass(Country.class);
    configuration.addAnnotatedClass(MuncipalityRelation.class);
    configuration.addAnnotatedClass(OrganisationType.class);
    configuration.addAnnotatedClass(OrganisationTypeRelation.class);
    configuration.addAnnotatedClass(ContactRelation.class);
    configuration.addAnnotatedClass(OrganisationRelation.class);
    configuration.addAnnotatedClass(OrganisationUnit.class);

    String[] arr = configuration.generateSchemaCreationScript(new HSQLDialect());

    sessionFactory = configuration.buildSessionFactory();
    session = sessionFactory.openSession();
    session2 = sessionFactory.openSession();

    this.session = SessionFactoryUtils.getSession(sessionFactory, true);
    TransactionSynchronizationManager.bindResource(sessionFactory, new SessionHolder(session));
}

From source file:no.abmu.finances.domain.AbstractLocalTest.java

License:Open Source License

protected void setUp() throws Exception {
    AnnotationConfiguration configuration = new AnnotationConfiguration();
    configuration.setProperty(Environment.DRIVER, "org.hsqldb.jdbcDriver");
    configuration.setProperty(Environment.URL, "jdbc:hsqldb:mem:.");
    configuration.setProperty(Environment.USER, "sa");
    configuration.setProperty(Environment.DIALECT, HSQLDialect.class.getName());
    configuration.setProperty(Environment.SHOW_SQL, "false");
    configuration.setProperty(Environment.HBM2DDL_AUTO, "create-drop");
    configuration.setProperty(Environment.STATEMENT_BATCH_SIZE, "0");
    configuration.setProperty("hibernate.cache.use_second_level_cache", "false");

    configuration.addClass(ReportSchema.class);

    configuration.addClass(Account.class);
    configuration.addClass(Post.class);
    configuration.addClass(PostPeriod.class);
    configuration.addClass(PostType.class);
    configuration.addClass(PostValidator.class);

    configuration.addClass(ReportData.class);
    configuration.addClass(PostData.class);
    configuration.addClass(SubReportDataList.class);

    configuration.addClass(AccountOrgUnitMapping.class);
    configuration.addClass(ReportDataOrgUnitMapping.class);

    configuration.addAnnotatedClass(ContactRole.class);
    configuration.addAnnotatedClass(CountryName.class);
    configuration.addAnnotatedClass(OrganisationName.class);
    configuration.addAnnotatedClass(OrganisationRelationRole.class);
    configuration.addAnnotatedClass(OrganisationTypeName.class);
    configuration.addAnnotatedClass(POBoxAddress.class);
    configuration.addAnnotatedClass(StreetAddress.class);
    configuration.addAnnotatedClass(ExtendedContactPerson.class);
    configuration.addAnnotatedClass(BankAccountNumber.class);
    configuration.addAnnotatedClass(ContactPerson.class);
    configuration.addAnnotatedClass(EmailAddress.class);
    configuration.addAnnotatedClass(FaxNumber.class);
    configuration.addAnnotatedClass(TelephoneNumber.class);
    configuration.addAnnotatedClass(WebAddress.class);
    configuration.addAnnotatedClass(Muncipality.class);
    configuration.addAnnotatedClass(Country.class);
    configuration.addAnnotatedClass(MuncipalityRelation.class);
    configuration.addAnnotatedClass(OrganisationType.class);
    configuration.addAnnotatedClass(OrganisationTypeRelation.class);
    configuration.addAnnotatedClass(ContactRelation.class);
    configuration.addAnnotatedClass(OrganisationRelation.class);
    configuration.addAnnotatedClass(OrganisationUnit.class);

    String[] arr = configuration.generateSchemaCreationScript(new HSQLDialect());

    sessionFactory = configuration.buildSessionFactory();
    session = sessionFactory.openSession();
    session2 = sessionFactory.openSession();

    this.session = SessionFactoryUtils.getSession(sessionFactory, true);
    TransactionSynchronizationManager.bindResource(sessionFactory, new SessionHolder(session));
}

From source file:no.abmu.finances.domain.fixtures.FinancesDbHibernate3TestFixture.java

License:Open Source License

/**
 * Creates hibernate3 sessionFactory with finances classes for testing 
 * of finance module. // ww  w.ja  v a2  s .  c  om
 * 
 * The created sessionFactory is based on HSQLDB in memory database, 
 * this sessionFactory is for testing only and must not be used 
 * in production.
 * 
 * @return Hibernate3 SessionFactory of user Register.
 * @throws Exception if Hibernate fails to configure or create the 
 * specified sessionFactory.
 */
public static SessionFactory createFinancesFactory() throws Exception {
    Configuration configuration = createConfiguration();

    addFinancesClasses(configuration);

    configuration.generateSchemaCreationScript(new HSQLDialect());
    return configuration.buildSessionFactory();
}

From source file:no.abmu.finances.domain.fixtures.FinancesDbHibernate3TestFixture.java

License:Open Source License

/**
 * Creates hibernate3 sessionFactory with finances classes and 
 * organisationRegister classes for testing of finance module. 
 * //from   w w w.ja  v  a2  s.c  o m
 * The created sessionFactory is based on HSQLDB in memory database, 
 * this sessionFactory is for testing only and must not be used 
 * in production.
 * 
 * @return Hibernate3 SessionFactory of user Register.
 * @throws Exception if Hibernate fails to configure or create the 
 * specified sessionFactory.
 */
public static SessionFactory createFinancesAndOrgRegisterFactory() throws Exception {
    Configuration configuration = createConfiguration();

    addFinancesClasses(configuration);
    configuration.addClass(no.abmu.finances.domain.AccountOrgUnitMapping.class);
    configuration.addClass(no.abmu.finances.domain.ReportDataOrgUnitMapping.class);

    addOrganisationRegisterClasses(configuration);

    configuration.generateSchemaCreationScript(new HSQLDialect());
    return configuration.buildSessionFactory();
}

From source file:no.abmu.lise.domain.fixtures.OrgRegDbHibernate3TestFixture.java

License:Open Source License

/**
 * Creates hibernate3 sessionFactory of organisationRegister for testing 
 * of finance module. /*  www  .  j a v  a  2 s  .c o  m*/
 * 
 * The created sessionFactory is based on HSQLDB in memory database, 
 * this sessionFactory is for testing only and must not be used 
 * in production.
 * 
 * @return Hibernate3 SessionFactory of user Register.
 * @throws Exception if Hibernate fails to configure or create the 
 * specified sessionFactory.
 */
public static SessionFactory createSessionFactory() throws Exception {

    AnnotationConfiguration configuration = new AnnotationConfiguration();

    configuration.setProperty(Environment.DRIVER, "org.hsqldb.jdbcDriver");
    configuration.setProperty(Environment.URL, "jdbc:hsqldb:mem:.");
    configuration.setProperty(Environment.USER, "sa");
    configuration.setProperty(Environment.DIALECT, HSQLDialect.class.getName());
    configuration.setProperty(Environment.SHOW_SQL, "false");
    configuration.setProperty(Environment.HBM2DDL_AUTO, "create-drop");
    configuration.setProperty(Environment.STATEMENT_BATCH_SIZE, "0");
    configuration.setProperty("hibernate.cache.use_second_level_cache", "false");

    /* ** LISE Domain objects for testing ** */
    configuration.addAnnotatedClass(Consortium.class);
    configuration.addAnnotatedClass(Product.class);
    configuration.addAnnotatedClass(ProductCustomerRelation.class);
    configuration.addAnnotatedClass(PaymentToSupplier.class);
    configuration.addAnnotatedClass(InvoiceToCustomer.class);
    configuration.addAnnotatedClass(LiseComment.class);

    //        configuration.addClass(no.abmu.lise.domain.Product.class);
    //        configuration.addClass(no.abmu.lise.domain.Consortium.class);
    //        configuration.addClass(no.abmu.lise.domain.LiseComment.class);
    //        configuration.addClass(no.abmu.lise.domain.PaymentToSupplier.class);
    //        configuration.addClass(no.abmu.lise.domain.InvoiceOrganisation.class);
    //        configuration.addClass(no.abmu.lise.domain.ProductOrganisationRelation.class);

    /* Organisation Unit and necessary classes */
    configuration.addAnnotatedClass(ContactRole.class);
    configuration.addAnnotatedClass(CountryName.class);
    configuration.addAnnotatedClass(OrganisationName.class);
    configuration.addAnnotatedClass(OrganisationRelationRole.class);
    configuration.addAnnotatedClass(OrganisationTypeName.class);
    configuration.addAnnotatedClass(POBoxAddress.class);
    configuration.addAnnotatedClass(StreetAddress.class);
    configuration.addAnnotatedClass(ExtendedContactPerson.class);
    configuration.addAnnotatedClass(BankAccountNumber.class);
    configuration.addAnnotatedClass(ContactPerson.class);
    configuration.addAnnotatedClass(EmailAddress.class);
    configuration.addAnnotatedClass(FaxNumber.class);
    configuration.addAnnotatedClass(TelephoneNumber.class);
    configuration.addAnnotatedClass(WebAddress.class);
    configuration.addAnnotatedClass(Muncipality.class);
    configuration.addAnnotatedClass(Country.class);
    configuration.addAnnotatedClass(MuncipalityRelation.class);
    configuration.addAnnotatedClass(OrganisationType.class);
    configuration.addAnnotatedClass(OrganisationTypeRelation.class);
    configuration.addAnnotatedClass(ContactRelation.class);
    configuration.addAnnotatedClass(OrganisationRelation.class);
    configuration.addAnnotatedClass(OrganisationUnit.class);

    configuration.generateSchemaCreationScript(new HSQLDialect());

    return configuration.buildSessionFactory();
}