Spring 3 oracle schema wrapped by quotes

27 views Asked by At

I have a problem after update project to Spring 3. There is schema wrapped by quotes:

    StandardTableGroup (f1 : path.entity.scheduler.FffMessagesEntity(523113009709800)) {
      primaryTableReference : "dfc$scm".fff_messagesas f1_0

And result ORA-00942

[http-nio-9098-exec-1] DEBUG Request: - JDBC exception executing SQL [select * from "dfc$scm".fff_messages f1_0 where f1_0.fum_status in(?,?)] [n/a]

Entity class:

@Data
@Entity
@Table(name = "fff_messages", schema = "Sdfc$scm")
@SequenceGenerator(name = "SEQ_fff_messages", sequenceName="SEQ_fff_messages", schema  = "dfc$scm", allocationSize = 1)
public class FffMessagesEntity implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="SEQ_fff_messages")
@Column(name = "FUM_ID", nullable = false, length = 10)
private BigInteger fumId;

other fields

CriteriaBuilder:

@PersistenceContext
private EntityManager em;

public List<Dto> getName() {

    CriteriaBuilder cb = em.getCriteriaBuilder();
    CriteriaQuery<Dto> cq = cb.createQuery(Dto.class);
    Root<FffMessagesEntity> root = cq.from(FffMessagesEntity.class);

    cq.multiselect(root.get(FffMessagesEntity_.fumId),
            root.get(FffMessagesEntity_.fumMessageName),
            root.get(FffMessagesEntity_.fumMessageBody),
            root.get(FffMessagesEntity_.uniqGuid));

    cq.where(root.get(FctUnprocessedMessageEntity_.status).in(1, 2));

    try {
        return em.createQuery(cq).getResultList();
    } catch (NoResultException e) {
        return null;
    }
}

Dependencies:

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>3.1.0</version>
    <relativePath/>
</parent>
<dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-annotations</artifactId>
        <version>3.5.5-Final</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate.orm</groupId>
        <artifactId>hibernate-jpamodelgen</artifactId>
        <version>6.1.7.Final</version>
    </dependency>
    <dependency>
        <groupId>jakarta.xml.bind</groupId>
        <artifactId>jakarta.xml.bind-api</artifactId>
        <version>4.0.1</version>
    </dependency>
    <dependency>
        <groupId>javax.xml.bind</groupId>
        <artifactId>jaxb-api</artifactId>
        <version>2.3.1</version>
    </dependency>

I have tried use spring-boot-starter-parent another version (3.2.2), but there is same exception. So, on spring 2.7.1 no problem. I understand query is forming not by spring, but version of dependencies are difrent.

0

There are 0 answers