I'm attempting to use jpql to select data from a table that has a period in it's name
Here is my entity @Entity @Table(catalog = "Gateway", schema = "stage", name = "confluence.Performance") public class PerformanceEntity implements Serializable { @Id private Integer recordId; ...
I create a query: Query query = entityManager.createQuery("From PerformanceEntity"); return query.getResultList();
This produces a query like: select recordId from Gateway.stage.confluence.Performance I need it to produce a query like select recordId from Gateway.stage.[confluence.NAVPerformance]
I am using Spring to set the dialect: <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="database" value="SQL_SERVER"/> <property name="showSql" value="true"/> </bean> </property>
Any ideas, or do I need to use a native query?
|