public class TestOracleSchemaValidation extends BaseCoreFunctionalTestCase {


	@Override
	protected Class<?>[] getAnnotatedClasses() {
		return new Class[] {Person.class, Address.class};
	}

	@Override
	protected boolean createSchema() {
		return false;
	}

	@Override
	protected void configure(Configuration configuration) {
		configuration.setProperty( AvailableSettings.HBM2DDL_AUTO, "validate" );
		configuration.setProperty( AvailableSettings.ENABLE_SYNONYMS, "true" );
		configuration.setProperty(
				AvailableSettings.HBM2DDL_JDBC_METADATA_EXTRACTOR_STRATEGY,
				JdbcMetadaAccessStrategy.INDIVIDUALLY.toString()
		);
	}

	@Test
	public void testIt() throws Exception {
		TransactionUtil.doInHibernate( this::sessionFactory, session -> {
			final Address address = new Address();
			address.setId( 1 );
			address.setCity( "London" );
			session.save( address );

		} );
	}

	@Entity
	@Table(name = "PERSON_SYN", schema = "c##andrea")
	public class Person {
		@Id
		int id;

		String name;

		public void setId(int id) {
			this.id = id;
		}

		public void setName(String name) {
			this.name = name;
		}
	}

	@Entity
	@Table(name = "ADDRESS", schema = "c##andrea")
	public class Address {
		@Id
		int id;

		String city;

		public void setId(int id) {
			this.id = id;
		}

		public void setCity(String city) {
			this.city = city;
		}
	}
}

hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.username=c##hibernate
hibernate.connection.password=hibernate_orm_test
hibernate.connection.url=jdbc\:oracle\:thin\:@localhost\:1521\:ORCLCDB