svjRT1q3

1<?xml version='1.0' encoding='UTF-8'?>
2<!DOCTYPE hibernate-configuration PUBLIC
3    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
4    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
5<hibernate-configuration>
6    <session-factory>
7        <mapping resource="quartz.sqlserver.hbm.xml"/>
8    </session-factory>
9</hibernate-configuration>
10	
11<?xml version="1.0" encoding="UTF-8"?>
12<!DOCTYPE hibernate-mapping PUBLIC
13    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
14    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
15<hibernate-mapping>
16    <database-object>
17        <create>
18            IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PINS_SCHEDULER_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)
19            BEGIN
20            CREATE TABLE [dbo].[PINS_SCHEDULER_CALENDARS] (
21            [SCHED_NAME] [VARCHAR] (120)  NOT NULL ,
22            [CALENDAR_NAME] [VARCHAR] (200)  NOT NULL ,
23            [CALENDAR] [IMAGE] NOT NULL
24            ) ON [PRIMARY];
25
26            ALTER TABLE [dbo].[PINS_SCHEDULER_CALENDARS] WITH NOCHECK ADD
27            CONSTRAINT [PK_PINS_SCHEDULER_CALENDARS] PRIMARY KEY  CLUSTERED
28            (
29            [SCHED_NAME],
30            [CALENDAR_NAME]
31            )  ON [PRIMARY];
32        END
33    </create>
34    <drop>
35        <!--IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[PINS_SCHEDULER_CALENDARS]') AND OBJECTPROPERTY(id, N'ISUSERTABLE') = 1)-->
36        <!--BEGIN-->
37            <!--DROP TABLE [dbo].[PINS_SCHEDULER_CALENDARS];-->
38        <!--END-->
39        SELECT 1
40    </drop>
41    <dialect-scope name="org.hibernate.dialect.SQLServer2012Dialect" />
42</database-object>
43
44
45</hibernate-mapping>
46	
47environments:
48    development:
49        dataSource:
50            dbCreate: update
51             dialect: org.hibernate.dialect.SQLServer2012Dialect
52             driverClassName: 
53  com.microsoft.sqlserver.jdbc.SQLServerDriver
54        url: 'jdbc:sqlserver://localhost;characterEncoding=utf-8;databaseName=*****'
55        username: ****
56        password: ****