juplo.de Git - hibernate4-maven-plugin/blob - src/it/patch.txt

   1 commit 046df1b894a9f65737461b4146bfe72acf97ca8e
   2 Author: Kai Moritz <kai@juplo.de>
   3 Date:   Fri Apr 5 12:37:19 2019 +0200
   4
   5     Configured the 5.2.18-tutorials to use the hibernate-maven-plugin
   6
   7 diff --git a/src/it/tutorials-5.2.18/annotations/pom.xml b/src/it/tutorials-5.2.18/annotations/pom.xml
   8 index effd4b7..505432c 100644
   9 --- a/src/it/tutorials-5.2.18/annotations/pom.xml
  10 +++ b/src/it/tutorials-5.2.18/annotations/pom.xml
  11 @@ -23,6 +23,30 @@
  12      <properties>
  13          <!-- Skip artifact deployment -->
  14          <maven.deploy.skip>true</maven.deploy.skip>
  15 +        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
  16      </properties>
  17
  18 +
  19 +    <build>
  20 +        <plugins>
  21 +            <plugin>
  22 +                <groupId>de.juplo</groupId>
  23 +                <artifactId>hibernate-maven-plugin</artifactId>
  24 +                <version>${hibernate-maven-plugin.version}</version>
  25 +                <executions>
  26 +                    <execution>
  27 +                        <phase>process-test-classes</phase>
  28 +                        <goals>
  29 +                            <goal>create</goal>
  30 +                        </goals>
  31 +                    </execution>
  32 +                </executions>
  33 +                <configuration>
  34 +                    <scanTestClasses>true</scanTestClasses>
  35 +                    <format>true</format>
  36 +                </configuration>
  37 +            </plugin>
  38 +        </plugins>
  39 +    </build>
  40 +
  41  </project>
  42 diff --git a/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml b/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml
  43 index a9590c1..df29d83 100644
  44 --- a/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml
  45 +++ b/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml
  46 @@ -15,7 +15,7 @@
  47
  48          <!-- Database connection settings -->
  49          <property name="connection.driver_class">org.h2.Driver</property>
  50 -        <property name="connection.url">jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
  51 +        <property name="connection.url">jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE</property>
  52          <property name="connection.username">sa</property>
  53          <property name="connection.password"></property>
  54
  55 @@ -31,9 +31,6 @@
  56          <!-- Echo all executed SQL to stdout -->
  57          <property name="show_sql">true</property>
  58
  59 -        <!-- Drop and re-create the database schema on startup -->
  60 -        <property name="hbm2ddl.auto">create</property>
  61 -
  62          <!-- Names the annotated entity class -->
  63          <mapping class="org.hibernate.tutorial.annotations.Event"/>
  64
  65 diff --git a/src/it/tutorials-5.2.18/basic/pom.xml b/src/it/tutorials-5.2.18/basic/pom.xml
  66 index 783ac6b..032919a 100644
  67 --- a/src/it/tutorials-5.2.18/basic/pom.xml
  68 +++ b/src/it/tutorials-5.2.18/basic/pom.xml
  69 @@ -23,6 +23,29 @@
  70      <properties>
  71          <!-- Skip artifact deployment -->
  72          <maven.deploy.skip>true</maven.deploy.skip>
  73 +        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
  74      </properties>
  75
  76 +    <build>
  77 +        <plugins>
  78 +            <plugin>
  79 +                <groupId>de.juplo</groupId>
  80 +                <artifactId>hibernate-maven-plugin</artifactId>
  81 +                <version>${hibernate-maven-plugin.version}</version>
  82 +                <executions>
  83 +                    <execution>
  84 +                        <phase>process-test-classes</phase>
  85 +                        <goals>
  86 +                            <goal>create</goal>
  87 +                        </goals>
  88 +                    </execution>
  89 +                </executions>
  90 +                <configuration>
  91 +                    <scanTestClasses>true</scanTestClasses>
  92 +                    <format>true</format>
  93 +                </configuration>
  94 +            </plugin>
  95 +        </plugins>
  96 +    </build>
  97 +
  98  </project>
  99 diff --git a/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml b/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml
 100 index 03d3937..df55e96 100644
 101 --- a/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml
 102 +++ b/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml
 103 @@ -15,7 +15,7 @@
 104
 105          <!-- Database connection settings -->
 106          <property name="connection.driver_class">org.h2.Driver</property>
 107 -        <property name="connection.url">jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
 108 +        <property name="connection.url">jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE</property>
 109          <property name="connection.username">sa</property>
 110          <property name="connection.password"/>
 111
 112 diff --git a/src/it/tutorials-5.2.18/entitymanager/pom.xml b/src/it/tutorials-5.2.18/entitymanager/pom.xml
 113 index d928fb6..8c13cf8 100644
 114 --- a/src/it/tutorials-5.2.18/entitymanager/pom.xml
 115 +++ b/src/it/tutorials-5.2.18/entitymanager/pom.xml
 116 @@ -23,6 +23,7 @@
 117      <properties>
 118          <!-- Skip artifact deployment -->
 119          <maven.deploy.skip>true</maven.deploy.skip>
 120 +        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
 121      </properties>
 122
 123      <dependencies>
 124 @@ -33,4 +34,27 @@
 125          </dependency>
 126      </dependencies>
 127
 128 +    <build>
 129 +        <plugins>
 130 +            <plugin>
 131 +                <groupId>de.juplo</groupId>
 132 +                <artifactId>hibernate-maven-plugin</artifactId>
 133 +                <version>${hibernate-maven-plugin.version}</version>
 134 +                <executions>
 135 +                    <execution>
 136 +                        <phase>process-test-classes</phase>
 137 +                        <goals>
 138 +                            <goal>create</goal>
 139 +                        </goals>
 140 +                    </execution>
 141 +                </executions>
 142 +                <configuration>
 143 +                    <scanTestClasses>true</scanTestClasses>
 144 +                    <dialect>org.hibernate.dialect.H2Dialect</dialect>
 145 +                    <format>true</format>
 146 +                </configuration>
 147 +            </plugin>
 148 +        </plugins>
 149 +    </build>
 150 +
 151  </project>
 152 diff --git a/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml b/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml
 153 index 0fc9523..edf7005 100644
 154 --- a/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml
 155 +++ b/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml
 156 @@ -18,7 +18,7 @@
 157
 158          <properties>
 159              <property name="javax.persistence.jdbc.driver" value="org.h2.Driver" />
 160 -            <property name="javax.persistence.jdbc.url" value="jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE" />
 161 +            <property name="javax.persistence.jdbc.url" value="jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE" />
 162              <property name="javax.persistence.jdbc.user" value="sa" />
 163              <property name="javax.persistence.jdbc.password" value="" />
 164
 165 diff --git a/src/it/tutorials-5.2.18/envers/pom.xml b/src/it/tutorials-5.2.18/envers/pom.xml
 166 index 7fa8a48..1d740ea 100644
 167 --- a/src/it/tutorials-5.2.18/envers/pom.xml
 168 +++ b/src/it/tutorials-5.2.18/envers/pom.xml
 169 @@ -23,6 +23,7 @@
 170      <properties>
 171          <!-- Skip artifact deployment -->
 172          <maven.deploy.skip>true</maven.deploy.skip>
 173 +        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
 174      </properties>
 175
 176      <dependencies>
 177 @@ -33,4 +34,27 @@
 178          </dependency>
 179      </dependencies>
 180
 181 +    <build>
 182 +        <plugins>
 183 +            <plugin>
 184 +                <groupId>de.juplo</groupId>
 185 +                <artifactId>hibernate-maven-plugin</artifactId>
 186 +                <version>${hibernate-maven-plugin.version}</version>
 187 +                <executions>
 188 +                    <execution>
 189 +                        <phase>process-test-classes</phase>
 190 +                        <goals>
 191 +                            <goal>create</goal>
 192 +                        </goals>
 193 +                    </execution>
 194 +                </executions>
 195 +                <configuration>
 196 +                    <scanTestClasses>true</scanTestClasses>
 197 +                    <dialect>org.hibernate.dialect.H2Dialect</dialect>
 198 +                    <format>true</format>
 199 +                </configuration>
 200 +            </plugin>
 201 +        </plugins>
 202 +    </build>
 203 +
 204  </project>
 205 diff --git a/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml b/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml
 206 index 45a7daf..fadc2a3 100644
 207 --- a/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml
 208 +++ b/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml
 209 @@ -18,7 +18,7 @@
 210
 211          <properties>
 212              <property name="javax.persistence.jdbc.driver" value="org.h2.Driver" />
 213 -            <property name="javax.persistence.jdbc.url" value="jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE" />
 214 +            <property name="javax.persistence.jdbc.url" value="jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE" />
 215              <property name="javax.persistence.jdbc.user" value="sa" />
 216              <property name="javax.persistence.jdbc.password" value="" />
 217
 218 diff --git a/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml b/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml
 219 index 55ccacd..35ad150 100644
 220 --- a/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml
 221 +++ b/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml
 222 @@ -12,6 +12,10 @@
 223    <version>1.0.0</version>
 224    <packaging>bundle</packaging>
 225
 226 +  <properties>
 227 +    <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
 228 +  </properties>
 229 +
 230    <dependencies>
 231      <dependency>
 232        <groupId>org.hibernate.javax.persistence</groupId>
 233 @@ -65,6 +69,23 @@
 234            </instructions>
 235          </configuration>
 236        </plugin>
 237 +      <plugin>
 238 +        <groupId>de.juplo</groupId>
 239 +        <artifactId>hibernate-maven-plugin</artifactId>
 240 +        <version>${hibernate-maven-plugin.version}</version>
 241 +        <executions>
 242 +          <execution>
 243 +            <goals>
 244 +              <goal>create</goal>
 245 +            </goals>
 246 +          </execution>
 247 +        </executions>
 248 +        <configuration>
 249 +          <url>jdbc:h2:mem:db_managed_jpa;MVCC=TRUE</url>
 250 +          <format>true</format>
 251 +          <execute>false</execute>
 252 +        </configuration>
 253 +      </plugin>
 254      </plugins>
 255    </build>
 256  </project>
 257 diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml
 258 index e45aab5..2836c5e 100644
 259 --- a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml
 260 +++ b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml
 261 @@ -12,6 +12,10 @@
 262    <version>1.0.0</version>
 263    <packaging>bundle</packaging>
 264
 265 +  <properties>
 266 +    <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
 267 +  </properties>
 268 +
 269    <dependencies>
 270      <dependency>
 271        <groupId>org.hibernate.javax.persistence</groupId>
 272 @@ -76,6 +80,21 @@
 273            </instructions>
 274          </configuration>
 275        </plugin>
 276 +      <plugin>
 277 +        <groupId>de.juplo</groupId>
 278 +        <artifactId>hibernate-maven-plugin</artifactId>
 279 +        <version>${hibernate-maven-plugin.version}</version>
 280 +        <configuration>
 281 +          <format>true</format>
 282 +        </configuration>
 283 +        <executions>
 284 +          <execution>
 285 +            <goals>
 286 +              <goal>create</goal>
 287 +            </goals>
 288 +          </execution>
 289 +        </executions>
 290 +      </plugin>
 291      </plugins>
 292    </build>
 293  </project>
 294 diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml
 295 index b0ebfe7..788ccab 100644
 296 --- a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml
 297 +++ b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml
 298 @@ -15,10 +15,10 @@
 299          <properties>
 300              <property name="hibernate.connection.driver_class" value="org.h2.Driver"/>
 301              <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
 302 -            <property name="hibernate.connection.url" value="jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE"/>
 303 +            <property name="hibernate.connection.url" value="jdbc:h2:mem:db_unmanaged_jpa;DB_CLOSE_DELAY=-1;MVCC=TRUE"/>
 304              <property name="hibernate.connection.username" value="sa"/>
 305              <property name="hibernate.connection.password" value=""/>
 306              <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
 307          </properties>
 308      </persistence-unit>
 309 -</persistence>
 310 \ No newline at end of file
 311 +</persistence>
 312 diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml
 313 index d24f03d..b3e19de 100644
 314 --- a/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml
 315 +++ b/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml
 316 @@ -12,6 +12,10 @@
 317    <version>1.0.0</version>
 318    <packaging>bundle</packaging>
 319
 320 +  <properties>
 321 +    <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
 322 +  </properties>
 323 +
 324    <dependencies>
 325      <dependency>
 326        <groupId>org.hibernate.javax.persistence</groupId>
 327 @@ -84,6 +88,21 @@
 328            </instructions>
 329          </configuration>
 330        </plugin>
 331 +      <plugin>
 332 +        <groupId>de.juplo</groupId>
 333 +        <artifactId>hibernate-maven-plugin</artifactId>
 334 +        <version>${hibernate-maven-plugin.version}</version>
 335 +        <configuration>
 336 +          <format>true</format>
 337 +        </configuration>
 338 +        <executions>
 339 +          <execution>
 340 +            <goals>
 341 +              <goal>create</goal>
 342 +            </goals>
 343 +          </execution>
 344 +        </executions>
 345 +      </plugin>
 346      </plugins>
 347    </build>
 348  </project>
 349 diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml
 350 index 7f9f238..175a2bf 100644
 351 --- a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml
 352 +++ b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml
 353 @@ -12,7 +12,7 @@
 354  <hibernate-configuration>
 355      <session-factory>
 356          <property name="hibernate.connection.driver_class">org.h2.Driver</property>
 357 -        <property name="hibernate.connection.url">jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
 358 +        <property name="hibernate.connection.url">jdbc:h2:mem:db_unmanaged_native;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
 359          <property name="hibernate.connection.username">sa</property>
 360          <property name="hibernate.connection.password"></property>
 361          <property name="hibernate.dialect">org.hibernate.dialect.H2Dialect</property>
 362 diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties
 363 index 7e1c4cf..0085971 100644
 364 --- a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties
 365 +++ b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties
 366 @@ -5,9 +5,9 @@
 367  # See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>.
 368  #
 369  jdbc-0.proxool.alias=pool-one
 370 -jdbc-0.proxool.driver-url=jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE
 371 +jdbc-0.proxool.driver-url=jdbc:h2:mem:db_unmanaged_native;DB_CLOSE_DELAY=-1;MVCC=TRUE
 372  jdbc-0.proxool.driver-class=org.h2.Driver
 373  jdbc-0.user=sa
 374  jdbc-0.password=
 375  jdbc-0.proxool.maximum-connection-count=2
 376 -jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
 377 \ No newline at end of file
 378 +jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
 379 diff --git a/src/it/tutorials-5.2.18/pom.xml b/src/it/tutorials-5.2.18/pom.xml
 380 index 26d0f89..a7e9b66 100644
 381 --- a/src/it/tutorials-5.2.18/pom.xml
 382 +++ b/src/it/tutorials-5.2.18/pom.xml
 383 @@ -70,6 +70,7 @@
 384              </testResource>
 385              <testResource>
 386                  <directory>src/test/resources</directory>
 387 +                <filtering>true</filtering>
 388              </testResource>
 389          </testResources>
 390      </build>
 391 diff --git a/src/it/tutorials-5.2.18/schema-annotations.sql b/src/it/tutorials-5.2.18/schema-annotations.sql
 392 new file mode 100644
 393 index 0000000..48eb18e
 394 --- /dev/null
 395 +++ b/src/it/tutorials-5.2.18/schema-annotations.sql
 396 @@ -0,0 +1,7 @@
 397 +
 398 +    create table EVENTS (
 399 +        id bigint not null,
 400 +        EVENT_DATE timestamp,
 401 +        title varchar(255),
 402 +        primary key (id)
 403 +    );
 404 diff --git a/src/it/tutorials-5.2.18/schema-basic.sql b/src/it/tutorials-5.2.18/schema-basic.sql
 405 new file mode 100644
 406 index 0000000..c5e2c0e
 407 --- /dev/null
 408 +++ b/src/it/tutorials-5.2.18/schema-basic.sql
 409 @@ -0,0 +1,7 @@
 410 +
 411 +    create table EVENTS (
 412 +        EVENT_ID bigint not null,
 413 +        EVENT_DATE timestamp,
 414 +        title varchar(255),
 415 +        primary key (EVENT_ID)
 416 +    );
 417 diff --git a/src/it/tutorials-5.2.18/schema-entitymanager.sql b/src/it/tutorials-5.2.18/schema-entitymanager.sql
 418 new file mode 100644
 419 index 0000000..48eb18e
 420 --- /dev/null
 421 +++ b/src/it/tutorials-5.2.18/schema-entitymanager.sql
 422 @@ -0,0 +1,7 @@
 423 +
 424 +    create table EVENTS (
 425 +        id bigint not null,
 426 +        EVENT_DATE timestamp,
 427 +        title varchar(255),
 428 +        primary key (id)
 429 +    );
 430 diff --git a/src/it/tutorials-5.2.18/schema-envers.sql b/src/it/tutorials-5.2.18/schema-envers.sql
 431 new file mode 100644
 432 index 0000000..ecec80e
 433 --- /dev/null
 434 +++ b/src/it/tutorials-5.2.18/schema-envers.sql
 435 @@ -0,0 +1,27 @@
 436 +
 437 +    create table EVENTS (
 438 +        id bigint not null,
 439 +        EVENT_DATE timestamp,
 440 +        title varchar(255),
 441 +        primary key (id)
 442 +    );
 443 +
 444 +    create table EVENTS_AUD (
 445 +        id bigint not null,
 446 +        REV integer not null,
 447 +        REVTYPE tinyint,
 448 +        EVENT_DATE timestamp,
 449 +        title varchar(255),
 450 +        primary key (id, REV)
 451 +    );
 452 +
 453 +    create table REVINFO (
 454 +        REV integer generated by default as identity,
 455 +        REVTSTMP bigint,
 456 +        primary key (REV)
 457 +    );
 458 +
 459 +    alter table EVENTS_AUD
 460 +        add constraint FK5cembm6xahf542q8e4h0pq2t1
 461 +        foreign key (REV)
 462 +        references REVINFO;
 463 diff --git a/src/it/tutorials-5.2.18/schema-osgi-managed-jpa.sql b/src/it/tutorials-5.2.18/schema-osgi-managed-jpa.sql
 464 new file mode 100644
 465 index 0000000..de92e46
 466 --- /dev/null
 467 +++ b/src/it/tutorials-5.2.18/schema-osgi-managed-jpa.sql
 468 @@ -0,0 +1,7 @@
 469 +create sequence hibernate_sequence start with 1 increment by 1;
 470 +
 471 +    create table DataPoint (
 472 +        id bigint not null,
 473 +        name varchar(255),
 474 +        primary key (id)
 475 +    );
 476 diff --git a/src/it/tutorials-5.2.18/schema-osgi-unmanaged-jpa.sql b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-jpa.sql
 477 new file mode 100644
 478 index 0000000..de92e46
 479 --- /dev/null
 480 +++ b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-jpa.sql
 481 @@ -0,0 +1,7 @@
 482 +create sequence hibernate_sequence start with 1 increment by 1;
 483 +
 484 +    create table DataPoint (
 485 +        id bigint not null,
 486 +        name varchar(255),
 487 +        primary key (id)
 488 +    );
 489 diff --git a/src/it/tutorials-5.2.18/schema-osgi-unmanaged-native.sql b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-native.sql
 490 new file mode 100644
 491 index 0000000..d89e280
 492 --- /dev/null
 493 +++ b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-native.sql
 494 @@ -0,0 +1,26 @@
 495 +create sequence hibernate_sequence start with 1 increment by 1;
 496 +
 497 +    create table DataPoint (
 498 +        id bigint not null,
 499 +        name varchar(255),
 500 +        primary key (id)
 501 +    );
 502 +
 503 +    create table DataPoint_AUD (
 504 +        id bigint not null,
 505 +        REV integer not null,
 506 +        REVTYPE tinyint,
 507 +        name varchar(255),
 508 +        primary key (id, REV)
 509 +    );
 510 +
 511 +    create table REVINFO (
 512 +        REV integer generated by default as identity,
 513 +        REVTSTMP bigint,
 514 +        primary key (REV)
 515 +    );
 516 +
 517 +    alter table DataPoint_AUD
 518 +        add constraint FK43jw6b5mtbfxur0xhyjxynbea
 519 +        foreign key (REV)
 520 +        references REVINFO;
 521 diff --git a/src/it/tutorials-5.2.18/verify.bsh b/src/it/tutorials-5.2.18/verify.bsh
 522 new file mode 100644
 523 index 0000000..9156c4a
 524 --- /dev/null
 525 +++ b/src/it/tutorials-5.2.18/verify.bsh
 526 @@ -0,0 +1,19 @@
 527 +import de.juplo.test.FileComparator;
 528 +
 529 +
 530 +FileComparator comparator = new FileComparator(basedir);
 531 +
 532 +if (!comparator.isEqual("schema-annotations.sql","annotations/target/create.sql"))
 533 +  return false;
 534 +if (!comparator.isEqual("schema-basic.sql","basic/target/create.sql"))
 535 +  return false;
 536 +if (!comparator.isEqual("schema-entitymanager.sql","entitymanager/target/create.sql"))
 537 +  return false;
 538 +if (!comparator.isEqual("schema-envers.sql","envers/target/create.sql"))
 539 +  return false;
 540 +if (!comparator.isEqual("schema-osgi-managed-jpa.sql","osgi/managed-jpa/target/create.sql"))
 541 +  return false;
 542 +if (!comparator.isEqual("schema-osgi-unmanaged-jpa.sql","osgi/unmanaged-jpa/target/create.sql"))
 543 +  return false;
 544 +if (!comparator.isEqual("schema-osgi-unmanaged-native.sql","osgi/unmanaged-native/target/create.sql"))
 545 +  return false;