java - “如何使用 hibernate 和 spring 修复”Save XML
问题描述
有一类 Hibernate XML Type,我需要借助 hibernate @type custom 保存在 postgresql 中。该类是https://wiki.postgresql.org/wiki/Hibernate_XML_Type 但在保存时,似乎我没有分配该值。
我认为这是因为我的配置类,我没有在我的配置中添加@type 的那个属性,Any Idea @Getter @Setter @Entity @Table(name = "doc_sri") public class Bill {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "cod_doc")
private int idBill;
@Column(name = "key_doc")
private String keyBill;
@Column(name = "date_doc")
private String dateIssueBill;
@Type(type = "com.rolandopalermo.facturacion.ec.entity.SQLXMLType")
@Column(name = "xml_doc" )
private String xmlBill;
@Column(name = "status_doc")
private int statusBill;
@Column(name = "type_doc")
private String typeBill;
public Bill( String keyBill, String dateIssueBill, String xmlBill, int statusBill, String typeBill) {
super();
this.keyBill = keyBill;
this.dateIssueBill = dateIssueBill;
this.xmlBill = xmlBill;
this.statusBill = statusBill;
this.typeBill = typeBill;
}
}
下一节课是
@Configuration
@ComponentScan({ "com.rolandopalermo.facturacion.ec" })
@PropertySource("classpath:application.properties")
public class WebAppConfig {
private static final String PROPERTY_NAME_DATABASE_DRIVER = "org.postgresql.Driver";
private static final String PROPERTY_NAME_DATABASE_PASSWORD = "admin";
private static final String PROPERTY_NAME_DATABASE_URL = "jdbc:postgresql://localhost:5433/sri_data_base";
private static final String PROPERTY_NAME_DATABASE_USERNAME = "postgres";
private static final String PROPERTY_NAME_HIBERNATE_DIALECT = "org.hibernate.dialect.PostgreSQLDialect";
private static final String PROPERTY_NAME_HIBERNATE_SHOW_SQL = "true";
private static final String PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN = "com.rolandopalermo.facturacion.ec.entity";
private static final String PROPERTY_NAME_ENTITYMANAGER_PACKAGES_MAPPING = "com.rolandopalermo.facturacion.ec.entity.SQLXMLType";
@Bean
public DataSource dataSource() {
DriverManagerDataSource dataSource = null;
try {
dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName(PROPERTY_NAME_DATABASE_DRIVER);
dataSource.setUrl(PROPERTY_NAME_DATABASE_URL);
dataSource.setUsername(PROPERTY_NAME_DATABASE_USERNAME);
dataSource.setPassword(PROPERTY_NAME_DATABASE_PASSWORD);
} catch (Exception e) {
// TODO: handle exception
}
return dataSource;
}
@Bean
public LocalSessionFactoryBean sessionFactory() {
LocalSessionFactoryBean sessionFactoryBean = null;
try {
sessionFactoryBean = new LocalSessionFactoryBean();
sessionFactoryBean.setDataSource(dataSource());
sessionFactoryBean.setPackagesToScan(PROPERTY_NAME_ENTITYMANAGER_PACKAGES_TO_SCAN);
sessionFactoryBean.setHibernateProperties(hibProperties());
} catch (Exception e) {
// TODO: handle exception
}
return sessionFactoryBean;
}
private Properties hibProperties() {
Properties properties = null;
try {
properties = new Properties();
properties.put(PROPERTY_NAME_HIBERNATE_DIALECT, PROPERTY_NAME_HIBERNATE_DIALECT);
properties.put(PROPERTY_NAME_HIBERNATE_SHOW_SQL, PROPERTY_NAME_HIBERNATE_SHOW_SQL);
properties.put("xml", PROPERTY_NAME_ENTITYMANAGER_PACKAGES_MAPPING);
} catch (Exception e) {
// TODO: handle exception
}
return properties;
}
@Bean
public HibernateTransactionManager transactionManager() {
HibernateTransactionManager transactionManager = new HibernateTransactionManager();
transactionManager.setSessionFactory(sessionFactory().getObject());
return transactionManager;
}
@Bean
public UrlBasedViewResolver setupViewResolver() {
UrlBasedViewResolver resolver = new UrlBasedViewResolver();
resolver.setPrefix("/WEB-INF/pages/");
resolver.setSuffix(".jsp");
resolver.setViewClass(JstlView.class);
return resolver;
}
}
但是当我尝试保存时,它会执行以下错误
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 5.
解决方案
推荐阅读
- javascript - 未定义的 ReadableStream 前缀
- angular - ngFor 使用 trackby 按文本过滤
- c++ - 仅当使用 unordered_map 而不是向量时,将 const 作为此参数传递才会丢弃限定符
- javascript - 是的,如何根据其他几个变量的函数验证一个变量?
- python - 跨多面图设置轴限制
- laravel - Laravel 如何在工厂中有 if 语句?
- uml - UML 如果父类连接,是否子类也必须连接
- javascript - Javascript 尝试始终将侧边栏保持在 100vh
- javascript - 哪个函数想知道位置/地理位置?
- javascript - 突变有效载荷值始终 __ob__ :观察者