edermfl

@Repository
public interface ClienteRepository extends JpaRepository<Cliente, Long> {
  
    public Cliente findByRg(String pRg);
    
    public Cliente findByRgAndNome (String pRg, String pNome);
    
    /**
     * Usando JPql
     * @param pPrimeiroNome

edermfl

@Repository
public interface ClienteRepository extends JpaRepository<Cliente, Long> {
  
    public Cliente findByRg(String pRg);
    
    public Cliente findByRgAndNome (String pRg, String pNome);
  
}

edermfl

@Repository
public interface ClienteRepository extends JpaRepository<Cliente, Long> {
  
    public Cliente findByRg(String pRg);
  
}

edermfl

@Repository
public interface ClienteRepository extends JpaRepository<Cliente, Long> {
    // não preciso definir nenhum método ainda!
}

edermfl

@Entity
@Table(name = "CLIENTE")
public class Cliente {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @Column
    private String nome;

edermfl

spring:
  jpa:
    hibernate:
      ddl-auto: create-drop
      naming-strategy: org.hibernate.cfg.ImprovedNamingStrategy
    database-platform: org.hibernate.dialect.H2Dialect
    show-sql: true
  datasource:
    url: jdbc:h2:mem:exemploparte2;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
    username: sa

edermfl

// ...
compile('org.springframework.boot:spring-boot-starter-data-jpa')
runtime('com.h2database:h2')
// ...

edermfl

<dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
   <groupId>com.h2database</groupId>
   <artifactId>h2</artifactId>
</dependency>

edermfl

environments {
    tenancies {
        mainTenant {
            database {
                username = 'MAIN'
                password = 'MAIN'
                url = 'jdbc:oracle:thin:@localhost:1521:xe'
                tablespace = 'TBS_DADOS'
                indexspace = 'TBS_INDICES'
                lobspace = 'TBS_LOBS'

edermfl

public class DatasourceIdResolverImpl implements DatasourceIdResolver {
    public String getCurrentDatasourceId() {
          return TenantContext.getCurrentTenant().getTenantId();
    }
}