當我嘗試運行本機查詢時，當我嘗試在 spring jpa 中運行時，出現以下錯誤native query。我已將方言添加到自定義方言中，擴展為spring.jpa.database-platform=com.config.HibernateCustomDialectCaused by: java.lang.NullPointerException: nullat com.vladmihalcea.hibernate.type.array.internal.AbstractArrayTypeDescriptor.setParameterValues(AbstractArrayTypeDescriptor.java:34) ~[hibernate-types-52-2.6.1.jar:na]at com.vladmihalcea.hibernate.type.array.StringArrayType.setParameterValues(StringArrayType.java:50) ~[hibernate-types-52-2.6.1.jar:na]at org.hibernate.type.TypeFactory.injectParameters(TypeFactory.java:149) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]at org.hibernate.type.TypeFactory.type(TypeFactory.java:135) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]下面是我的實體@Entity@Getter@Setter@NoArgsConstructor@TypeDef( name = "string-array", typeClass = StringArrayType.class)public class Session { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Long sessionId; @Type(type = "string-array") @Column(columnDefinition = "text[]", name = "tags") private String[] tags = null; private long oId; // More Fields} 自定義方言public class HibernateCustomDialect extends org.hibernate.dialect.PostgreSQL94Dialect { private static final Logger log = LoggerFactory.getLogger(HibernateCustomDialect.class); public HibernateCustomDialect() { super(); log.info("Registering Custom Hibernate Dialect - {}",HibernateCustomDialect.class.getName()); this.registerHibernateType(Types.ARRAY, StringArrayType.class.getName()); }}Jpa 存儲庫@Repositorypublic interface SessionRepository extends JpaRepository<Session, Long> { String sessionSummaryViewQuery ="SELECT session.session_id, session.tags FROM public.session WHERE session.oid=?1" @Query(value =sessionSummaryViewQuery,nativeQuery = true) List<SessionSummaryView> findByOpportunityId(long opportunityId);//, Pageable pageable);}
1 回答
縹緲止盈
TA貢獻2041條經驗 獲得超4個贊
在瀏覽互聯網并掃描所有與休眠相關的頁面后，我找到了一個解決方法。
我實現了一個CustomStringArrayType擴展com.vladmihalcea.hibernate.type.array.StringArrayType.
參考 - https://github.com/vladmihalcea/hibernate-types/issues/142我迫不及待地等待 PR 被合并，因此實現了如下解決方法：
public class CustomStringArrayType extends StringArrayType {
@Override
public void setParameterValues(Properties parameters) {
if (parameters.containsKey(super.PARAMETER_TYPE)) {
super.setParameterValues(parameters);
}
}
}
我修改后的HibernateDialect如下：
public class HibernateCustomDialect extends org.hibernate.dialect.PostgreSQL94Dialect {
private static final Logger log = LoggerFactory.getLogger(HibernateCustomDialect.class);
public HibernateCustomDialect() {
super();
log.info("Registering Custom Hibernate Dialect - {}",HibernateCustomDialect.class.getName());
this.registerHibernateType(Types.ARRAY, CustomStringArrayType.class.getName());
}
}
添加回答
舉報
0/150
提交
取消