title: Spring boot test containers
body: <p>Is it possible to use test containers ie oracle-xe with spring boot, but have it used as DB for local deploy.. for instance get spring boot to start up in say develop profile and have the test container also start and be used for foe backend..</p>
  <p>I have seen a few examples if it being used for tests, but then its torn down/shut down.</p>
  <p>any ideas?</p>
  <p>UPDATE:</p>
  <p>So i managed to wire in the test container and start it up.. Got the spring properties set..</p>
  <p>when the schema.sql files loads i get, an error no privleges... im trying to create a new schema and add some tables into it.. but it doesnt seem to work..</p>
  <p>&quot;no prviliges on tablespace 'SYSTEM'&quot;</p>
  <pre><code>CREATE USER PM3 IDENTIFIED by PM3
  
   
  
  CREATE TABLE PM3.JOBS (
  
      JOB_ID NUMBER(3) NOT NULL,
  
      CUSTOMER_ID NUMBER(3) NOT NULL,
  
      DESCRIPTION VARCHAR(200),
  
      constraint PK_JOB_ID primary key (JOB_ID)
  
  );
  </code></pre>